Archives of the TeradataForum
Message Posted: Wed, 09 Apr 2008 @ 12:32:36 GMT
<-- Anonymously Posted: Wed, 9 Apr 2008 16:44 -->
I have an IDENTITY column as below,
CREATE SET TABLE dbtest.test, NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( P_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 2 INCREMENT BY 1 MINVALUE 2 MAXVALUE 99999999 NO CYCLE), P_NAME VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL) UNIQUE PRIMARY INDEX ( P_ID);
This is what I do in steps,
1. This table is empty initially
2. I first insert USER values (Which don't have duplicates) into the column P_ID.
3. In the next insert, when I try to supply NULLs to the column (intented to generate keys), I get Duplicate Primary Key error. This problem is random, doesn't happen always.
Can someone throw some light, on what could be the issue ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|