SQLite

View Ticket
Login
Ticket Hash: 745f1abcdc5b5119c64314c34a19ef047bb50627
Title: FTS integrity-check malfunctions for transaction and the prefix option
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-10-11 15:33:29
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-10-10 22:22:22:

Consider the following test case:

CREATE VIRTUAL TABLE vt0 USING fts4(c0, prefix=1);
BEGIN;
INSERT INTO vt0 VALUES (0);
INSERT INTO vt0(vt0) VALUES('optimize');
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- database disk image is malformed

The integrity-check results in an error "database disk image is malformed", which is unexpected.