Re: List of innocuous functions?

SELECT DISTINCT name FROM pragma_function_list
--WHERE (flags & 0x200000)!=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 <[email protected]> wrote:

> 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, pragma_index_info, and the aforementioned
> pragma_function_list, at least that I recall. Any sort of listing of what's
> available like these?
>
> I'd think that it would be helpful in the peanut gallery. Thanks!
>
> Regards.
>
> Brian P Curley
>
>
>
> On Fri, Jan 24, 2020 at 4:12 PM Richard Hipp <[email protected]> wrote:
>
> > SELECT DISTINCT name
> >    FROM pragma_function_list
> >  WHERE (flags & 0x200000)!=0
> >  ORDER BY name;
> >
> > On 1/24/20, Peter Kolbus <[email protected]> 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_TRUSTED_SCHEMA but support a variety
> > of
> > > applications and am hoping for something to guide analysis.
> > >
> > > Thanks
> > > -Peter
> > > _______________________________________________
> > > sqlite-users mailing list
> > > [email protected]
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> >
> >
> > --
> > D. Richard Hipp
> > [email protected]
> > _______________________________________________
> > sqlite-users mailing list
> > [email protected]
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users