Re: [sqlite] List of innocuous functions?

2020-01-25 Thread sky5walk
Doh! I'm on 3.30.0. Gotcha, thanks. On Sat, Jan 25, 2020 at 8:22 PM Richard Hipp wrote: > On 1/25/20, sky5w...@gmail.com wrote: > > SELECT DISTINCT name FROM pragma_function_list > > --WHERE (flags & 0x20)!=0 -- no such column: flags > > ORDER BY name; > > > > Works if I drop the WHERE. >

Re: [sqlite] List of innocuous functions?

2020-01-25 Thread Richard Hipp
On 1/25/20, sky5w...@gmail.com wrote: > SELECT DISTINCT name FROM pragma_function_list > --WHERE (flags & 0x20)!=0 -- no such column: flags > ORDER BY name; > > Works if I drop the WHERE. > Is there a special compile flag that must be used? You need to be using SQLite 3.31.0 or later. -- D.

Re: [sqlite] List of innocuous functions?

2020-01-25 Thread sky5walk
SELECT DISTINCT name FROM pragma_function_list --WHERE (flags & 0x20)!=0 -- no such column: flags ORDER BY name; Works if I drop the WHERE. Is there a special compile flag that must be used? On Fri, Jan 24, 2020 at 5:42 PM Brian Curley wrote: > separate but somewhat related question, based

Re: [sqlite] List of innocuous functions?

2020-01-24 Thread Brian Curley
separate but somewhat related question, based on the response: Has any thought been given to updating the documentation to cover those pragmas that have been upgraded to selectable entities? I've only been able to find a handful of references along the way, such as pragma_table_info,

Re: [sqlite] List of innocuous functions?

2020-01-24 Thread Richard Hipp
SELECT DISTINCT name FROM pragma_function_list WHERE (flags & 0x20)!=0 ORDER BY name; On 1/24/20, Peter Kolbus wrote: > Is there any documentation showing, or an easy way to generate, the exact > list of SQLite-provided functions that are innocuous? > > I’d like to turn on the new

[sqlite] List of innocuous functions?

2020-01-24 Thread Peter Kolbus
Is there any documentation showing, or an easy way to generate, the exact list of SQLite-provided functions that are innocuous? I’d like to turn on the new SQLITE_TRUSTED_SCHEMA but support a variety of applications and am hoping for something to guide analysis. Thanks -Peter