/ View Ticket
Login
Ticket UUID: d6ec09eccf68cfcac6a05b4ee054be1c1b8a8f6e
Title: Assertion fault in FTS4
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2018-02-13 16:35:22
Version Found In: 3.22.0
User Comments:
drh added on 2018-02-13 16:12:09: (text/x-fossil-wiki)
The following SQL generates an assertion fault in FTS4:

<blockquote><verbatim>
CREATE VIRTUAL TABLE ft USING fts4(a, b, c);
INSERT INTO ft(rowid, a, b, c) VALUES(1, 'unus duo', NULL, NULL);
INSERT INTO ft(rowid, a, b, c) VALUES(2, NULL, NULL, NULL);
BEGIN;
  UPDATE ft SET b='septum' WHERE rowid = 1;
  UPDATE ft SET c='octo' WHERE rowid = 1;
COMMIT;
</verbatim></blockquote>

Bisecting shows that this problem first appeared with
check-in [a1d08fd3d0419da8] on 2015-09-29 and was released
with version 3.9.0.

This is a simplification of a problem discovered in the wild and reported
to SQLite developers through private channels.