SQLite

View Ticket
Login
Ticket Hash: e258f008ce2344f013d2ac0f761e2bd95a092549
Title: FTS rebuild in transaction causes integrity-check to fail
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-10-08 13:35:03
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-10-07 21:07:42:

Consider the following test case:

CREATE VIRTUAL TABLE vt0 USING fts5(c0);
INSERT INTO vt0(c0) VALUES (NULL);
BEGIN TRANSACTION;
INSERT INTO vt0(vt0) VALUES('rebuild');
INSERT INTO vt0(vt0) VALUES('rebuild');
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- database disk image is malformed

Unexpectedly, the integrity check results in an error "database disk image is malformed".