Bugs item #1643543, was opened at 2007-01-24 14:33 Message generated for change (Comment added) made by romulog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1643543&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: SQL: Drop column (which is a primary key with foreign keys) Initial Comment: Dear developers, The example show the bug: [EMAIL PROTECTED] test]$ mclient sql>create table t1(id int, name varchar(1024)); sql>alter table t1 add constraint id_p primary key(id); sql> sql>create table t2(id_f int, age int, foreign key(id_f) references t1(id)); sql>alter table t2 add constraint id_p primary key(id_f); sql>alter table t1 drop id; sql>select * from t1; % sys.t1 # table_name % name # name % varchar # type % 0 # length sql> Regards, Romulo ---------------------------------------------------------------------- >Comment By: Romulo Goncalves (romulog) Date: 2007-01-29 18:48 Message: Logged In: YES user_id=1498628 Originator: YES This bug is fixed and it is covered by: sql/src/tests/BugConstraints/drop_column_1643542.sql Regards, Romulo ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2007-01-25 18:03 Message: Logged In: YES user_id=1498628 Originator: YES A test was created to cover this bug: sql/src/tests/BugConstraints/drop_column_1643542.sql Regards, Romulo ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1643543&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
