|
|
Archives of the TeradataForum
Message Posted: Tue, 13 Nov 2001 @ 17:56:43 GMT
Subj: | | Error 2801 Duplicate Unique Prime Key |
|
From: | | Tom Wrobel |
I HAVE ENCOUNTERED A SITUATION ON V2R4. I HAVE 2 TABLES (TEST1 and TEST2) THAT ARE IDENTICAL IN DEFINITION AND ALSO IN CONTENT. THE
TABLE DESCRIPTION IS:
CREATE SET TABLE DB.TEST1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL
( FIELD1 CHAR(1) ,
FIELD2 CHAR(1) ,
CNT DECIMAL(10,0))
UNIQUE PRIMARY INDEX ( FIELD1 ,FIELD2 );
IF I PERFORM THE FOLLOWING SQL, I RECEIVE ERROR 2801
INSERT INTO DB.TEST1 (FIELD1,FIELD2,CNT) VALUES ('1','1',0)
HOWEVER, IF I PERFORM THIS SQL, I RECEIVE NO ERROR WITH ONLY A MESSAGE OF ZERO ROWS INSERTED. AS THE TABLES ARE DUPLICATE, I BELIEVE I
SHOULD HAVE RECEIVED 2801.
INSERT INTO DB.TEST1 SELECT * FROM DB.TEST2
| |