SQLite Forum

SQLITE_DEBUG, SQLITE_MAX_EXPR_DEPTH=0 triggers assertion failure
Login

SQLITE_DEBUG, SQLITE_MAX_EXPR_DEPTH=0 triggers assertion failure

(1) By 0xjnml on 2020-08-20 11:49:55 [link] [source]

Not sure if a bug or an illegal/unsupported compile time options combination.

Commit https://sqlite.org/src/info/3c5e63c22ffbfeb6


SQLite-3c5e63c2$ cat bug.sh 
make distclean
./configure CFLAGS="-DSQLITE_DEBUG -DSQLITE_MAX_EXPR_DEPTH=0"
make testfixture
cd test
../testfixture permutations.test extraquick misc1.test
SQLite-3c5e63c2$ ./bug.sh 
rm -f *.lo *.la *.o sqlite3 libsqlite3.la

...

misc1-20.1... Ok
misc1-21.1...testfixture: sqlite3.c:101599: sqlite3ExprListFlags: Assertion `pExpr!=0' failed.
./bug.sh: line 5:  7887 Aborted                 (core dumped) ../testfixture permutations.test extraquick misc1.test
SQLite-3c5e63c2$

(2) By Dan Kennedy (dan) on 2020-08-20 16:27:22 in reply to 1 [link] [source]

Thanks again. This one is a bug in SQLite. Only affects SQLITE_MAX_EXPR_DEPTH=0 builds. Fixed here:

https://sqlite.org/src/info/5f58dd3a19605b6f

(3.1) By 0xjnml on 2020-08-21 09:46:48 edited from 3.0 in reply to 2 [source]

Confirming the linked commit fixed the issue. Thank you.

What's the release policy of the project? Are there point releases after a couple of fixes like this accumulate?