Bugs item #2803477, was opened at 2009-06-09 12:49 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2803477&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 "stable" Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: Arjen de Rijke (arjenderijke) Assigned to: Niels Nes (nielsnes) Summary: alter table drop contraint error Initial Comment: Using the may 2009 source tarball on a standard cwi desktop, doing a add table drop constraint command in sql, the database schema administration is corrupted. If you run the attached script, the command "/mclient -lsql -ddatabasename -D" reports 2 foreign key constraints, but there are 4. The same thing happens if you do the add constraint before the drop constraint. The script is the simplest situation where the error occurs. If you replace "ALTER TABLE TABLE_B DROP CONSTRAINT UNQ_VALUE_C;" with "ALTER TABLE TABLE_C DROP CONSTRAINT FK_TABLE_C_TABLE_D_ID;" the error also occurs. If you replace it with "ALTER TABLE TABLE_C DROP CONSTRAINT FK_TABLE_C_TABLE_A_ID;", the error does not occur. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-06-15 19:30 Message: a test was added to the bugtracker-2009 directory (alter_table_drop_constraint.SF-2803477) ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-06-15 19:29 Message: fixed by using leftjoins ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2803477&group_id=56967 ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
