Bugs item #2075180, was opened at 2008-08-26 14:49 Message generated for change (Tracker Item Submitted) made by Item Submitter 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: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Qian Qiao (drizzlerain) Assigned to: Nobody/Anonymous (nobody) 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 ---------------------------------------------------------------------- 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
