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