On Tue, Dec 4, 2018 at 6:16 PM Keith Medcalf <kmedc...@dessus.com> wrote: > > My introspection pragma's work, and always have. Then again, I compile with them turned on. Perhaps if they are available the option should appear in the compile_options output, at least?
Indeed, that too Keith. But from the looks of it, this lists only explicitly turned on features, not OFF-by-default ones I guess. I wish SQLITE_INTROSPECTION_PRAGMAS [1] was ON by default in downloaded shell. Perhaps patience is needed (see below). BTW, googling around, I found I asked about function_list almost 10 years ago! See [2]. Time flies... SQLite is amazing software. But it is very "opinionated" software too :) Oh, well, another 10 years, and maybe I'll get over that... --DD PS: Strange how the compiler is reported as GCC 5.2. Mingw-build? Instead of native MSVC? Cross-Compiled? [1] https://www.sqlite.org/compile.html#introspection_pragmas [2] http://sqlite.1065341.n5.nabble.com/listing-registered-SQL-functions-aggregate-or-scalar-td47951.html C:\Users\ddevienne>sqlite3 -version 3.26.0 2018-12-01 12:34:55 bf8c1b2b7a5960c282e543b9c293686dccff272512d08865f4600fb58238b4f9 C:\Users\ddevienne>sqlite3 SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> pragma compile_options; COMPILER=gcc-5.2.0 ENABLE_DBSTAT_VTAB ENABLE_FTS3 ENABLE_FTS5 ENABLE_JSON1 ENABLE_RTREE ENABLE_STMTVTAB ENABLE_UNKNOWN_SQL_FUNCTION THREADSAFE=0 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users