17.10 - Restrictions - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
  • You cannot pass ARRAY values as arguments to the search condition in a WHERE clause. You can pass individual elements of an ARRAY to the search condition in a WHERE clause. Also, you may use system functions provided by Vantage to do relational comparison on ARRAY data. For information about these functions, see Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates, B035-1145.
  • You cannot specify an ARRAY column in any of the following SQL DML clauses:
    • INTERSECT, MINUS, or UNION set operator
    • DISTINCT operator
    • ORDER BY, GROUP BY, or HAVING clause of a SELECT statement
  • You cannot create UDMs for an ARRAY type. The only valid methods for an ARRAY type are the methods that Vantage creates automatically for an ARRAY type. Therefore, you cannot specify an ARRAY type name in the FOR clause of a CREATE/REPLACE METHOD statement.
  • An ARRAY column cannot be a component of an index.
  • Any restrictions that apply to a UDT also apply to an ARRAY type.