Archives of the TeradataForum
Message Posted: Thu, 12 Oct 2006 @ 15:02:10 GMT
I'm just adding my 2 cents to this query. To answer why it doesn';t show the error is simple.
When you use the INSERT..SELECT it goes for table level constraint check and it discards all the rows. Hence there is no rows processed.
However, if you go for INSERT VALUES approach. It goes for ROW LEVEL check. WHEN it goes for ROW level check it fails as SET table doesn't permit duplicate row. Hence you get the error.
Instead of writing
insert into temp1 (2,2);
If you write
insert into temp1 SELECT 2,2
Then you will not see the error again as it will get discarded by table level constraints.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|