Archives of the TeradataForum

Message Posted: Tue, 01 Apr 2008 @ 23:29:17 GMT


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

Subj:		Re: Duplicate Row Error during an Update

From:		McCall, Glenn David

Can someone explain what a duplicate row error is?

I'm getting this error when I try to run an update statement (using the from clause)

I would have thought the meaning was obvious but it means this:

1) You have a table like this

     Create table dup_row_error (
          I1 integer,
          I2 integer
     );

2) with this data

     Insert into dup_row_error values (1, 2);
     Insert into dup_row_error values (1, 3);

3) and you do something like this:

     Update dup_row_error
          Set i2 = 2
     Where i2 = 3;

The error occurs because the table is defined as "set". This means that duplicate rows are not allowed. In general, rows that are identical (i.e. duplicates) are not of much use (how do you distinguish between them?). Sometimes people allow disable the "set" definition to speed up loading processes.

Hope this helps

Glenn Mc