17.20 - Duplicate Rows - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

ANSI session mode allows rows, but duplicate rows are possible only if the table does not contain a primary key or any columns with unique constraints. Otherwise, a "duplicate row" error will be generated.

In Teradata session mode, duplicate rows generated from an INSERT ... SELECT statement were ignored and no error or warning was generated.