INSERT Operations That Are Not Valid - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

INSERT Operations That Are Not Valid

An INSERT operation causes an error or failure message to be returned if any of the following are true.

  • The operation attempts to assign a value that will result in a violation of a unique index specification.
  • The operation attempts to insert a row with no value for a column that has no default and is defined as NOT NULL.
  • The operation attempts to assign a nonnull value that violates a CHECK constraint declared for a column.
  • The operation attempts to assign a value that is of a different numeric type than that declared for the column and the assigned value cannot be converted correctly.
  • The operation attempts to assign a character value that is not in the repertoire of the destination character data type.
  • The operation attempts to insert a character string trailing pad characters into a VARCHAR field, and that operation causes the row to become identical to another row (except for the number of trailing pad characters).
  • In ANSI session mode, inserting character data, if in order to comply with maximum length of the target column, non-pad characters are truncated from the source data.
  • Notice:

    KANJI1 support is deprecated. KANJI1 is not allowed as a default character set. The system changes the KANJI1 default character set to the UNICODE character set. Creation of new KANJI1 objects is highly restricted. Although many KANJI1 queries and applications may continue to operate, sites using KANJI1 should convert to another character set as soon as possible.