[MonetDB-users] 'on delete cascade' constraint over mapi fails
kruseman at xs4all.nl
Tue Oct 30 21:23:58 CET 2007
Consider the following setup:
CREATE TABLE parent (key int PRIMARY KEY);
CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE
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.
More information about the users-list