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: (text/x-fossil-wiki)
Consider the following test case:

<pre>
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.
</pre>

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