I am running sa 12.0.1.3726 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. asked 04 Jun '12, 12:14 Ryan Erickson |
I have no issues with either 12.0.1.3456 or 12.0.1.3741. 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 Glenn Paulley 1
It appears one of my earlier scripts turned off fire_triggers(then errored out and never turned it back on). Turned it back on and it functioned as expected
(04 Jun '12, 13:12)
Ryan Erickson
Replies hidden
The answer is "fire_triggers", what is the question? "How do I mess with people's minds?" Correct! :)
(04 Jun '12, 13:34)
Breck Carter
|
It works OK for me in 12.0.1.3298, so it must be a new
featurebug.It also worked for my co-worker on 12.0.1.3718 so it must be very new.
FWIW, it's not very new, it's reaaaaal old - even v5.5 contains that feature:
Just for the record:)