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