SQLite

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:

The following test case segfaults on the current trunk:

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

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:

If you take out the CREATE VIRTUAL TABLE statement, you get an infinite loop. Both are the same problem. Now fixed.