SQLite

View Ticket
Login
Ticket Hash: dd1f67bf252deceff9c8f47f8ffdda12f3819aa8
Title: FTS integrity-check malfunctions nondeterministically with tokenize="ascii"
Status: Closed Type: Code_Defect
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-10-24 20:36:11
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-10-24 19:44:02:

Consider the following test case:

CREATE VIRTUAL TABLE vt0 USING fts5(c0, tokenize = "ascii", prefix = 1);
INSERT INTO vt0(c0) VALUES (x'd1');
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- unexpected error: database disk image is malformed

Unexpectedly, the integrity-check fails sometimes/nondeterministically with the error "database disk image is malformed".