Bugs item #2075241, was opened at 2008-08-26 09:22 Message generated for change (Comment added) made by stmane 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: Open Resolution: Fixed Priority: 6 Private: No Submitted By: Jane Chen (cjnn) Assigned to: Niels Nes (nielsnes) >Summary: SQL: When 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: Stefan Manegold (stmane) Date: 2009-08-14 13:53 Message: tagged subject ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-08-13 20:03 Message: re-opened as the test fails, again, since checkin on 2009/08/05 on the Aug2009 branch, now complaining QUERY = alter table A add constraint test1 primary key (test, id); ERROR = !CONSTRAINT PRIMARY KEY: a table can have only one PRIMARY KEY cf., http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugTracker-2008/alter_add_constraint_should_check_existing_data.SF-2075241.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugTracker-2008/alter_add_constraint_should_check_existing_data.SF-2075241.out.00.html ---------------------------------------------------------------------- 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 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
