I am running sa 184.108.40.20626 and having issues with my system triggers when executing the following script
CREATE TABLE test1 (id INTEGER PRIMARY KEY); CREATE TABLE test2 (id2 INTEGER PRIMARY KEY, id INTEGER, FOREIGN KEY id(id) REFERENCES test1(id) ON UPDATE CASCADE ON DELETE CASCADE); insert into test1(id)values(1); insert into test2(id2,id)values(1,1); delete from test1;
I get Primary key for row in table 'test1' is referenced by foreign key 'id' in table 'test2' when it should be handled by the ON DELETE rule.
I have no issues with either 220.127.116.1156 or 18.104.22.16841.
Is this a simplified repro of a larger problem?
Is is possible that you have the fire_triggers option set, or used the -gf server option?
answered 04 Jun '12, 13:06