On Thu, 25 Oct 2018 09:32:05 -0700 Nathan Green wrote: > According to the online documentation (https://www.sqlite.org/series.html ), > generate_series is compiled into the command line shell. As it turns out, > this is not so. It is not even an option in the build system from what I > can tell. It would be nice to at least have a build flag to enable it.
> I searched the list archives and noticed an email from late 2015 that > indicates that generate_series was never actually a part of the shell. > Apparently no one ever took up the task of making that happen. Would it be > okay if I put together a patch for this? I would prefer it to be enabled by > default, but I can implement it either way. Here it also doesn't work: SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" for usage hints. sqlite> select * from generate_series(1,1000); Error: no such table: generate_series It's a pity because it's a very nice tally table and fast method of generating sequential data, random data, intended number of rows etc. which would be a useful addition in the shell one-liners or other sqlite scripts. It's also useful for simple performance assessments. I vote for GENERATE_SERIES to be included in official sqlite3 binary and libraries. Thanks in advance. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
