Duplicate Rows and INSERT
When an insert operation would create a duplicate row, the outcome of the operation depends on how the table is defined. The system ignores trailing pad characters in character strings when comparing values for field or row duplication.
IF the table is defined as … |
THEN the duplicate row is … |
MULTISET with no UNIQUE constraints |
inserted. |
|
not inserted. An error is returned to the requestor. If inserting into an identity column table, this is true only when the column is defined WITH NO CYCLE. An error can occur in this case if an attempt is made to cycle. The system can also return errors for other reasons, like uniqueness violations, before a duplicate row violation can be reported. |