SQLite

View Ticket
Login
Ticket Hash: dfd66334cfc2cde31d3c0bf6fcc30705b76b3002
Title: Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-23 15:17:35
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-23 13:36:14:

Consider the following test case:

CREATE TABLE t0(c0);
CREATE TABLE t1(c0);
SELECT * FROM t0 LEFT JOIN t1 WHERE (t1.c0 BETWEEN 0 AND 0) > ('' AND t0.c0); -- sqlite3.c:103271: impliesNotNullRow: Assertion `pWalker->eCode==0' failed.

When compiling with -DSQLITE_DEBUG, the SELECT triggers an assertion error.