Archives of the TeradataForum

Message Posted: Mon, 19 May 2014 @ 19:48:35 GMT


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

Subj:		Re: Unique violation error on INSERT INTO a SET table

From:		Pirri, Antonio

Hi,

when you use the "INSERT SELECT" the duplicate rows are eliminating silently, because it make an table level constraint check and it discards all the rows, but if you use the "INSERT VALUES", the engine don't eliminate silently because it make an ROW LEVEL check, and it fail because the SET table condition.

Thank

Antonio Angel Pirri
PS Consultant