SQLite

View Ticket
Login
2019-12-28
00:37 Fixed ticket [37823501c6]: Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMempOp->p1)' failed. plus 5 other changes (artifact: 927f79f9fb user: drh)
00:36
Recompute the values for all generated columns after NOT NULL ON CONFLICT REPLACE constraints fire. Tickets [37823501c68a09f9] and [5fbc159eeb092130]. (check-in: 4cc12c1886 user: drh tags: trunk)
2019-12-27
17:06 New ticket [37823501c6] Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMempOp->p1)' failed.. (artifact: dbba73b454 user: mrigger)

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
5.35 years ago
Created: 2019-12-27 17:06:56
5.35 years ago
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-27 17:06:56:

Consider the following test case:

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.

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