| 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.
| ||||