Home Page for the TeradataForum
 

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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016