On Wednesday, 23 August, 2017 16:28, Dominique Devienne <ddevie...@gmail.com> wrote:
>On Wed, Aug 23, 2017 at 6:11 PM, Keith Medcalf <kmedc...@dessus.com> wrote: >> sqlite> pragma function_list; >> group_concat|1 >> group_concat|1 >> julianday|1 >> julianday|1 >> nullif|1 >> nullif|1 >> sqlite_compileoption_get|1 >> sqlite_compileoption_get|1 >> current_timestamp|1 >> current_timestamp|1 >> sqlite_compileoption_used|1 >> sqlite_compileoption_used|1 >Where's that pragma from Keith? Thanks, --DD >There's no such pragma at https://sqlite.org/pragma.html >and below you can see it's just as good as another, which pragma >happily ignores. They were added "experimentally" on July 7, 2017 -- meaning they do not show up in the documentation yet, and presumably that the implementation may change (and may currently be perhaps a little buggy or inconsistent -- if it breaks you own both halves when you use undocumented/pre-release features). You will note that for example the returned rows show both the builtin and user-defined function names, even though one may be overriding the other in various circumstances, and also no differentiation between scalar functions, aggregates, and no flags or argument numbers/types. However if all you are looking for is whether or not a certain module or function is loaded (by name) on a connection then it returns that information. Anything more specific is not returned though -- so you have to assume that the function you want is the one you see. They appeared in the 3.20.0 release code although turned off by default -- you need to "build your own" with the preprocessor symbol SQLITE_INTROSPECTION_PRAGMAS defined. The commit to trunk can be found here: https://www.sqlite.org/src/info/e0b6ae92adfae46f --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
