Bugs item #2075180, was opened at 2008-08-26 08:49 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075180&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 5.6 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Qian Qiao (drizzlerain) Assigned to: Niels Nes (nielsnes) Summary: the unique column can't insert more than 1 row with null Initial Comment: OS:RedHat Linux AS 4 GCC: 3.4.6 1.setup: CREATE TABLE FEAT16 ( EMPNUM INT PRIMARY KEY, PNUM INT UNIQUE); 2.execute: INSERT INTO FEAT16 VALUES (3, NULL); INSERT INTO FEAT16 VALUES (4, NULL); 3.result: The first INSERT operation is OK,but the second INSERT operation is failed: !SQLException:assert:INSERT INTO: UNIQUE constraint 'feat16.feat16_pnum_unique' violated ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2008-09-10 11:17 Message: See also [ 2103348 ] unique problem with nulls http://sourceforge.net/tracker/index.php?func=detail&aid=2103348&group_id=56967&atid=482468 [ 2075241 ] When the NULL is in a column,it shouldn't add primary key http://sourceforge.net/tracker/index.php?func=detail&aid=2075241&group_id=56967&atid=482468 [ 1960373 ] kunion and nil http://sourceforge.net/tracker/index.php?func=detail&aid=1960373&group_id=56967&atid=482468 ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2008-08-26 15:34 Message: Logged In: YES user_id=43556 Originator: NO added insert_into_unique_column.SF-2075180.sql indeed we should allow for multiple NULL's ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2008-08-26 09:19 Message: Logged In: YES user_id=572415 Originator: NO *Possibly* related to the NIL semantics issue reported in [ 1960373 ] kunion and nil http://sourceforge.net/tracker/index.php?func=detail&aid=1960373&group_id=56967&atid=482468 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075180&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
