Bugs item #1823387, was opened at 2007-10-31 11:20 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1823387&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Romulo Goncalves (romulog) Assigned to: Niels Nes (nielsnes) Summary: Cascade operations in different sessions... Initial Comment: Dear developers, I am using linux and the current cvs branch for MonetDB5 and SQL. If I create the tables: 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); And then restart my mserver5 and execute the query: DELETE FROM parent WHERE key = 1; The cascade deletion is not performed because the catalog information for keys is wrong. This means that the information to perform the cascade delete (fkey->on_delete) is 0 (NO_ACTION) instead of 1 (CASCADE). If the mserver is not restarted the value is correct. After some debug I got some useful information: I also checked the catalog load (when the mserver is restarted) and the value is set correctly. However, when I do the bin of the schema (normally done with mvc_bind_schema) the information is incorrect. I hope my description is useful to fix the bug. Regards, Romulo ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1823387&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
