SQLite

View Ticket
Login
Ticket Hash: 9cb7d0ef445913e7ba0af883be3d2be73fc6c17f
Title: Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-22 14:30:38
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-22 09:34:38:

Consider the following test case:

PRAGMA locking_mode = EXCLUSIVE;
PRAGMA journal_mode = PERSIST;
CREATE VIRTUAL TABLE vt0 USING fts5(c0);
INSERT INTO vt0(vt0) VALUES('integrity-check');
INSERT INTO vt0(vt0, rank) VALUES('usermerge', 2); -- sqlite3.c:213961: fts5StructureRead: Assertion `p->iStructVersion!=0' failed.

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