SQLite

View Ticket
Login
Ticket Hash: 7c13db5c3bf7400198d3d24de3518f2a2b6af53c
Title: Debug assertion sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbort(v, pParse->mayAbort)' failed
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-26 23:40:46
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-26 22:44:05:

Consider the following test case:

CREATE TABLE t0(c0 PRIMARY KEY, c1, c2 UNIQUE) WITHOUT ROWID;
INSERT OR FAIL INTO t0(c2) VALUES (0), (NULL) ON CONFLICT(c2) DO UPDATE SET c1 = c0 -- sqlite3.c:108474: sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbort(v, pParse->mayAbort)' failed.

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