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.
> >
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.
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
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_in
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
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
__
6 matches
Mail list logo