SQLite

View Ticket
Login
Ticket Hash: cd3311e32372c0216d61582aee707b466da3e193
Title: FTS database disk image is malformed for update on languageid
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-21 20:43:50
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-20 22:18:23:

Consider the following statements:

CREATE VIRTUAL TABLE vt0 USING fts4(c0, languageid="lid");
INSERT INTO vt0 VALUES (0), (1);
BEGIN;
UPDATE vt0 SET lid = 1;
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- unexpected: database disk image is malformed

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