SQLite

View Ticket
Login
Ticket Hash: 752fdbf6e73c24a3aec03c54864286805d64e0fa
Title: FTS database disk image is malformed for UTF-16 encoding and integrity check
Status: Closed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-24 20:51:13
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-24 19:09:00:

Consider the following test case:

PRAGMA encoding = 'UTF-16';
CREATE VIRTUAL TABLE vt0 USING fts5(c0, c1);
INSERT INTO vt0(vt0, rank) VALUES('pgsz', '37');
INSERT INTO vt0(c0, c1) VALUES (0.66077, 1957391816);
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- unexpected: database disk image is malformed

Unexpectedly, the integrity check indicates an error.