| Ticket Hash: | 771fe61761260c704bf6abf53f286a1daad0b513 | |||
| Title: | FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Minor | Priority: | Low | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2020-01-02 16:24:33 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2020-01-01 22:29:52:
(text/x-fossil-wiki)
Consider the following test case:
<pre>
PRAGMA encoding = 'UTF16';
CREATE VIRTUAL TABLE vt0 USING fts5(c0);
INSERT INTO vt0 VALUES (SUBSTR(x'37', ''));
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- database disk image is malformed
</pre>
Unexpectedly, the integrity check fails with an error. This issue could be related to the open FTS4 bug [1dc432db3b].
| ||||