Bugs item #2075241, was opened at 2008-08-26 09:22 Message generated for change (Comment added) made by romulog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075241&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: MonetDB5 "stable" >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Jane Chen (cjnn) Assigned to: Niels Nes (nielsnes) Summary: When the NULL is in a column,it shouldn't add primary key Initial Comment: OS: RedHat Linux AS 4 GCC: 3.4.6 1.setup: create table A ( test int ); insert into A (test) values (NULL); 2.execute: alter table A add constraint test1 primary key (test); 3.result: The operation is successful, but the table has "null". ---------------------------------------------------------------------- >Comment By: Romulo Goncalves (romulog) Date: 2008-11-14 14:54 Message: The fix for this bug were the check ins: [Monetdb-sql-checkins] sql/src/server sql_schema.mx, Nov2008, 1.152, 1.152.2.1 [Monetdb-sql-checkins] sql/src/server sql_updates.mx, Nov2008, 1.153, 1.153.2.1 [Monetdb-sql-checkins] sql/src/storage store.mx, Nov2008, 1.22, 1.22.2.1 ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2008-08-26 15:52 Message: Logged In: YES user_id=43556 Originator: NO added test alter_add_constraint_should_check_existing_data.SF-2075241.sql . We currently don't check constraints when added to an existing column/table. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075241&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
