/ View Ticket
Login
Ticket Hash: b439bfcfb7deedc6b0e81f4574809904b163b867
Title: REINDEX segfaults on table with generated columns
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-14 17:44:36
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-14 16:37:33: (text/x-fossil-wiki)
The following test case segfaults on the current trunk:

<pre>
CREATE TABLE t0(c0 AS(1 >= 1), c1 UNIQUE AS(TYPEOF(c0)), c2);
CREATE VIRTUAL TABLE t1 USING fts4;
INSERT INTO t0 VALUES(0);
REINDEX; -- segfault
</pre>

Removing the CREATE VIRTUAL TABLE causes the REINDEX to not terminate. Note that the test case uses the not yet released GENERATED COLUMN feature.

drh added on 2019-12-14 17:44:36: (text/x-fossil-wiki)
If you take out the CREATE VIRTUAL TABLE statement, you get an infinite
loop.  Both are the same problem.  Now fixed.