SQLite

View Ticket
Login
Ticket Hash: cf36cb4e0200e6ea894ada9b8b36f88fa8f7f861
Title: FTS database disk image is malformed for UTF-16 encoding after update
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-20 13:24:42
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-11 18:06:36: (text/x-fossil-wiki)
The following test case unexpectedly results in an error:

<pre>
PRAGMA encoding = 'UTF-16';
CREATE VIRTUAL TABLE vt0 USING fts5(c0);
INSERT INTO vt0 VALUES (x'46f0');
UPDATE vt0 SET c0=NULL;
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- database disk image is malformed
</pre>