SQLite

View Ticket
Login
Ticket Hash: c28a01da72f8957c01a224a31ba5f649b4547cc4
Title: REPLACE causes segfault in table with generated column and foreign key
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-11-01 15:19:51
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-11-01 08:00:47:

Using the following test case, I can reliably reproduce a segmentation fault on my machine:

CREATE TABLE t0 (c0, c1 a UNIQUE AS (1), c2, c3, FOREIGN KEY(c3) REFERENCES t0(c1));
CREATE VIRTUAL TABLE vt0 USING fts4(c0);
PRAGMA foreign_keys = true;
CREATE INDEX i0 ON t0(0) WHERE 0;
INSERT INTO vt0 VALUES (0);
REPLACE INTO t0(c3, c2, c0) VALUES (0, 0, 0), (0, 0, 0); -- Segmentation fault