Archives of the TeradataForum

Message Posted: Wed, 09 Apr 2008 @ 12:32:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wed, 9 Apr 2008 16:44 -->

Hello,

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 ?

Thanks Lot

	<Prev	Next>		<<First	<Prev	Next>	Last>>