SQLite

View Ticket
Login
Ticket Hash: f00d096caee3738323d6b951df8f5001e297a575
Title: Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-22 17:32:39
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-22 10:47:09:

Consider the following test case:

CREATE TABLE t0(c0 UNIQUE);
INSERT INTO t0 VALUES(0);
SELECT * FROM t0 WHERE (0, t0.c0) IN(SELECT DENSE_RANK() OVER(), LAG(0) OVER() FROM t0); -- sqlite3.c:87244: sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed.

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