Bugs item #2075180, was opened at 2008-08-26 06:49 Message generated for change (Comment added) made by nielsnes 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: Niels Nes (nielsnes) Date: 2008-08-26 13: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 07: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
