GENERATE_SERIES is not available in the command-line shell

Digital Dog <[email protected]>
Newsgroups gmane.comp.db.sqlite.general
Message-ID <CAJR80-yeU-117w4_q0KQLKXKDkVQ8TL2Bh5Trc89EJpXVv=adw@mail.gmail.com>
Hi!

In the docs here
https://www.sqlite.org/series.html
there's this statement "The generate_series(START,END,STEP) table-valued
function is a loadable extension included in the SQLite source tree, **and
compiled into the command-line shell.**" Unfortunately in version 3.30.1 on
Windows downloaded from SQLite.org it's not available by default.
Is it going to be fixed in 3.31?
Thanks!

C:\>sqlite3
SQLite version 3.30.1 2019-10-10 20:19:45
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT value FROM generate_series(5,50);
Error: no such table: generate_series
sqlite>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.