[sqlite] Problem with SQLite version 3.9.2 together with user authentication extension

2015-11-26 Thread Ulrich Telle
Am 26.11.2015 um 01:30 schrieb Simon Slavin: > > On 25 Nov 2015, at 8:25pm, Ulrich Telle wrote: > >> SELECT name, rootpage, sql FROM 'main'.sqlite_master ORDER BY rowid > > Can you try that again without the quotes around "main" ? > > SELECT name, rootpage, sql FROM main.sqlite_master ORDER BY

[sqlite] Problem with SQLite version 3.9.2 together with user authentication extension

2015-11-26 Thread Simon Slavin
On 25 Nov 2015, at 8:25pm, Ulrich Telle wrote: > SELECT name, rootpage, sql FROM 'main'.sqlite_master ORDER BY rowid Can you try that again without the quotes around "main" ? SELECT name, rootpage, sql FROM main.sqlite_master ORDER BY rowid Simon.

[sqlite] Problem with SQLite version 3.9.2 together with user authentication extension

2015-11-25 Thread Ulrich Telle
I further tracked the problem down to lines 379 to 384 in build.c: #if SQLITE_USER_AUTHENTICATION else if( pParse->db->auth.authLeveldb->auth.authLevel != 0 && pParse->db->auth.authLevel SQLite version 3.8.7 introduced the user authentication extension. This > extension worked well for all

[sqlite] Problem with SQLite version 3.9.2 together with user authentication extension

2015-11-25 Thread Ulrich Telle
SQLite version 3.8.7 introduced the user authentication extension. This extension worked well for all 3.8.x versions. Now I intended to upgrade to SQLite version 3.9.2. However, if I enable the user authentication extension using the compile time define SQLITE_USER_AUTHENTICATION I experience