Support function_list in pre-built binaries from SQLite download page

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Support function_list in pre-built binaries from SQLite download page

Dominique Devienne
sqlite> pragma function_list;
sqlite>

Nothing returned, so obviously the -DSQLITE_INTROSPECTION_PRAGMAS
compile-time option is not used [1]. Could it be ON by default please? TIA,
--DD

[1] https://www.sqlite.org/pragma.html#pragma_function_list
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Support function_list in pre-built binaries from SQLite download page

Dominique Devienne
On Fri, Nov 30, 2018 at 4:11 PM Dominique Devienne <[hidden email]>
wrote:

> Nothing returned, so obviously the -DSQLITE_INTROSPECTION_PRAGMAS
> compile-time option is not used [1]. Could it be ON by default please?
> TIA, --DD
>

ping.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Support function_list in pre-built binaries from SQLite download page

Dominique Devienne
On Tue, Dec 4, 2018 at 10:08 AM Dominique Devienne <[hidden email]>
wrote:

> On Fri, Nov 30, 2018 at 4:11 PM Dominique Devienne <[hidden email]>
> wrote:
>
>> Nothing returned, so obviously the -DSQLITE_INTROSPECTION_PRAGMAS
>> compile-time option is not used [1]. Could it be ON by default please?
>> TIA, --DD
>>
>
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 function_list;
sqlite>

Tried latest 3.26 from pre-built Windows binaries at [1], and still no
function listing :(

Am I misusing that feature? Wrong pragma never give errors AFAIK, so hard
to say.

Also, I tried using .dbconfig, and function_list is not listed there either.

sqlite> .dbconfig
       enable_fkey off
    enable_trigger on
    fts3_tokenizer off
    load_extension on
  no_ckpt_on_close off
       enable_qpsg off
       trigger_eqp off
    reset_database off
         defensive off
sqlite>

Should it be?

Thanks, --DD

[1] https://www.sqlite.org/download.html
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Support function_list in pre-built binaries from SQLite download page

Richard Hipp-3
On 12/4/18, Dominique Devienne <[hidden email]> wrote:
> Wrong pragma never give errors AFAIK,

That is how pragmas are designed to work, yes.  Unknown pragmas are
silently ignored.
--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Support function_list in pre-built binaries from SQLite download page

Dominique Devienne
On Tue, Dec 4, 2018 at 3:30 PM Richard Hipp <[hidden email]> wrote:

> On 12/4/18, Dominique Devienne <[hidden email]> wrote:
> > Wrong pragma never give errors AFAIK,
>
> That is how pragmas are designed to work, yes.  Unknown pragmas are
> silently ignored.


Thanks for confirming my "AFAIK" Richard.

But no comment on my request to compile-in pragma_function_list by default
in the pre-built Windows shell?
Or ehther to add it as a .dbconfig option?
Or my question about finding out which compile-time features are used in
the library?

--DD
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Support function_list in pre-built binaries from SQLite download page

Keith Medcalf

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?

---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume.

>-----Original Message-----
>From: sqlite-users [mailto:sqlite-users-
>[hidden email]] On Behalf Of Dominique Devienne
>Sent: Tuesday, 4 December, 2018 07:37
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Support function_list in pre-built binaries
>from SQLite download page
>
>On Tue, Dec 4, 2018 at 3:30 PM Richard Hipp <[hidden email]> wrote:
>
>> On 12/4/18, Dominique Devienne <[hidden email]> wrote:
>> > Wrong pragma never give errors AFAIK,
>>
>> That is how pragmas are designed to work, yes.  Unknown pragmas are
>> silently ignored.
>
>
>Thanks for confirming my "AFAIK" Richard.
>
>But no comment on my request to compile-in pragma_function_list by
>default
>in the pre-built Windows shell?
>Or ehther to add it as a .dbconfig option?
>Or my question about finding out which compile-time features are used
>in
>the library?
>
>--DD
>_______________________________________________
>sqlite-users mailing list
>[hidden email]
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users