SQLite

View Ticket
Login
Ticket Hash: 188f912b51cd802a4fd5ac8f0609f00c3e459741
Title: Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-22 23:48:45
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-22 21:53:18:

Consider the following test case:

CREATE TABLE t0(c0 TEXT, CHECK(c0 IN (c0)));
INSERT INTO t0 VALUES(0);
UPDATE t0 SET c0 = 0; -- sqlite3.c:86323: sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed.

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