Bugs item #1823387, was opened at 2007-10-31 11:20 Message generated for change (Settings changed) made by romulog 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: Closed >Resolution: Fixed 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 ---------------------------------------------------------------------- >Comment By: Romulo Goncalves (romulog) Date: 2007-10-31 13:05 Message: Logged In: YES user_id=1498628 Originator: YES the structures are (after loading) copied for each client, ie the key_dup functions did not correctly propagate the on_delete value The fix and committed in the stable branch. Now we just need to wait for the propagation to have fixed in the current branch. A test was also added (the log message): Add tests for bug: cascade_operations_in_different_sessions.SF-1823387 The test is done with two files: cascade_operations_in_different_sessions.SF-1823387_create to load the data and then the Mserver is restarted by Mtest. cascade_operations_in_different_sessions.SF-1823387_drop to perform the delete and check if it was done correctly. In this way no scripts are needed and we are sure that the Mserver was restarted. 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
