SQLite

View Ticket
Login
Ticket Hash: bf1aab897889867e1f43c3b780314b6c6fa24e71
Title: FTS merge does not terminate
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-23 15:24:30
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-10-17 13:56:47: (text/x-fossil-wiki)
Consider the following test case:

<pre>
CREATE VIRTUAL TABLE vt0 USING fts4(c0, order=DESC);
INSERT INTO vt0(c0) VALUES (0);
INSERT INTO vt0(c0) VALUES (0);
UPDATE vt0 SET c0 = NULL;
INSERT INTO vt0(vt0) VALUES('merge=1,4'); -- unexpected: does not terminate
</pre>

Unexpectedly, merge commands of the format merge=X,4 do not always terminate, as demonstrated by the example above.