SQLite

View Ticket
Login
Ticket Hash: 8c9458e703666e1a422c4ac808aaeeaa919474e0
Title: row-value updates in triggers do not work.
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2017-01-03 13:37:02
Version Found In: 3.16.0
User Comments:
drh added on 2017-01-02 21:40:30:

Row-value UPDATE statements inside of TRIGGERs cause segfaults, memory leaks, and/or assertion faults. Example:

CREATE TABLE t1(a,b,c);
INSERT INTO t1 VALUES(1,2,3);
CREATE TABLE t2(x);
CREATE TRIGGER r2 AFTER INSERT ON t2 BEGIN
  UPDATE t1 SET (a,b,c)=(SELECT 4,5,6);
END;
INSERT INTO t2 VALUES(1);
SELECT * FROM t1;
SELECT * FROM t2;

This problem has existed ever since row value were added in version 3.15.0, about two months ago.