Bugs item #1296395, was opened at 2005-09-20 15:31 Message generated for change (Comment added) made by romulog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1296395&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: (zombie: SQL 2.8.0) Status: Open Resolution: Accepted Priority: 5 Private: No Submitted By: Fabian (mr-meltdown) Assigned to: Niels Nes (nielsnes) Summary: SQL: ON DELETE/UPDATE CASCADE accepted but not executed Initial Comment: monetdb-> create table a (id int primary key); Operation successful monetdb-> create table b (id int, foreign key (id) references a(id) on delete cascade); Operation successful monetdb-> insert into a values (1); 1 affected row monetdb-> insert into b values(1); 1 affected row monetdb-> delete from a; 1 affected row monetdb-> select * from b; +------------+ | id | +============+ | 1 | +------------+ 1 row monetdb-> although the ON DELETE CASCADE clause is accepted, it is not implemented. We better not accept this, or best just implement it. ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2007-01-18 11:03 Message: Logged In: YES user_id=1498628 Originator: NO In my opinion it should be implemented. It will take some time, but it is a nice feature for our system. What do you think? Regards, Romulo ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2006-06-06 21:00 Message: Logged In: YES user_id=963970 Niels, shall we remove the syntactical support for this from the parser? (Like is done for WITH CHECK OPTION?) ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2006-01-22 21:58 Message: Logged In: YES user_id=963970 yes ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2006-01-22 21:26 Message: Logged In: YES user_id=572415 postponed until after the release, I suppose? ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2006-01-15 14:46 Message: Logged In: YES user_id=963970 this needs major work, postponing for now. ---------------------------------------------------------------------- Comment By: Sjoerd Mullender (sjoerd) Date: 2005-12-19 16:55 Message: Logged In: YES user_id=43607 BugDay_2005-12-19, sjoerd: TEST ADDED / FAILURE sql/src/test/BugDay_2005-12-19_2.9.3/Tests/delete_cascade.SF-1296395.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1296395&group_id=56967 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
