30 Oct
2007
30 Oct
'07
8:23 p.m.
Consider the following setup: CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE); INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1); Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records. However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint. Kind regards, Sander Kruseman