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: (text/x-fossil-wiki)
Consider the following test case:

<pre>
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
</pre>

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