/ View Ticket
Ticket Hash: 1b06916e01c82b66d0c5f0543ae2327681df9a8b
Title: Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-22 18:23:47
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-22 17:09:08:

Consider the following test case:

CREATE TABLE t0(c0 CHECK(c1 IN(c1)), c1 INT);
INSERT INTO t0(c1) VALUES('0'); -- sqlite3.c:86300: sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed.

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