SQLite

View Ticket
Login
Ticket Hash: 8a6fa2bb22d7aa777920b055366a1f7261e6cf03
Title: FTS order=DESC results into integrity-check failing
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-10-11 14:28:21
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-10-10 21:47:35:

Consider the following test case:

CREATE VIRTUAL TABLE vt0 USING fts4(c0, order=DESC);
INSERT INTO vt0(c0) VALUES (0), (0);
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".