| 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:
(text/x-fossil-wiki)
Consider the following test case: <pre> 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. </pre> When compiling with -DSQLITE_DEBUG, the SELECT triggers an assertion error. | ||||