SQLite

View Ticket
Login
Ticket Hash: 37823501c68a09f9806c96e9767d81bc02e229af
Title: Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMem[pOp->p1])' failed.
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-28 00:37:03
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-27 17:06:56: (text/x-fossil-wiki)
Consider the following test case:

<pre>
CREATE TABLE t0(c0 NOT NULL DEFAULT '', c1 AS(c0) NOT NULL);
REPLACE INTO t0(c0) VALUES(NULL); -- sqlite3.c:85112: sqlite3VdbeExec: Assertion `memIsValid(&aMem[pOp->p1])' failed.
</pre>

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