| 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 5.56 years ago |
Created: |
2019-10-07 21:07:42 5.56 years ago |
| 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".
| ||||