| Ticket Hash: | e258f008ce2344f013d2ac0f761e2bd95a092549 | |||
| Title: | FTS rebuild in transaction causes integrity-check to fail | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Critical | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-10-08 13:35:03 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2019-10-07 21:07:42:
(text/x-fossil-wiki)
Consider the following test case:
<pre>
CREATE VIRTUAL TABLE vt0 USING fts5(c0);
INSERT INTO vt0(c0) VALUES (NULL);
BEGIN TRANSACTION;
INSERT INTO vt0(vt0) VALUES('rebuild');
INSERT INTO vt0(vt0) VALUES('rebuild');
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- database disk image is malformed
</pre>
Unexpectedly, the integrity check results in an error "database disk image is malformed".
| ||||