Archives of the TeradataForum
Message Posted: Mon, 06 Feb 2006 @ 13:58:40 GMT
It came up in the MULTISET-debate, that an INSERT/SELECT in a SET-table with an UPI would not generate an error.
This is for Teradata mode.
Is there a good reason for this?
PS: I very much like the silently ignoring of dupes when INSERT/SELECTing to a SET-table without an UPI/USI.
By the way, the behaviour is documented in the manuals (SQL Reference Volume 1).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|