Archives of the TeradataForum

Message Posted: Mon, 19 May 2014 @ 16:40:19 GMT


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

Subj:		Unique violation error on INSERT INTO a SET table

From:		Attila_Finta

My understanding is that a SET table is supposed to ?silently? eliminate duplicates, but that seems to depend on the INSERT statement syntax.? See example below.? Is this to be expected? ?

     create set table tmp_work_db.SetTblChk (col1 byteint, col2 byteint) primary index
     (col1);

     insert into tmp_work_db.SetTblChk sel 1,2; insert into tmp_work_db.SetTblChk sel 1,2;
     insert into tmp_work_db.SetTblChk (1,2);

     0 rows processed.
     CREATE Command Complete

     1 rows processed.
     INSERT Command Complete

     0 rows processed.
     INSERT Command Complete

     ERROR [23000] [Teradata][ODBC Teradata Driver][Teradata Database] Duplicate row error in
     TMP_WORK_DB.SetTblChk.
     INSERT Command Failed.

Thanks.

Attila