Bugs item #1643522, was opened at 2007-01-24 14:12 Message generated for change (Settings changed) made by romulog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1643522&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: Add Constraint: Initial Comment: Dear developers, I am using M5 SQL and I created the following tables: create table t1(id int, name varchar(1024)); alter table t1 add constraint id_p primary key(id); create table t2(id_f int, age int, foreign key(id_f) references t1(id)); alter table t2 add constraint age_p primary key(age); And I add the same contraint more than one time: [EMAIL PROTECTED] test]$ mclient sql>alter table t1 add constraint id_p primary key(id); sql>alter table t1 add constraint id_p primary key(id); sql>alter table t1 add constraint id_p primary key(id); sql>select * from keys; % sys.keys, sys.keys, sys.keys, sys.keys, sys.keys # table_name % id, table_id, type, name, rkey # name % int, int, int, varchar, int # type % 4, 4, 1, 12, 4 # length [ 4769, 4766, 0, "id_p", -1 ] [ 4781, 4778, 2, "t2_id_f_fkey", 4769 ] [ 4783, 4778, 0, "age_p", -1 ] [ 6018, 4766, 0, "id_p", -1 ] [ 6020, 4778, 0, "age_p", -1 ] [ 6022, 4766, 0, "id_p", -1 ] [ 6024, 4766, 0, "id_p", -1 ] [ 6026, 4766, 0, "id_p", -1 ] sql> Well, it seems something is wrong here. Regards, Romulo ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1643522&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
