16.20 - Restrictions - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Types and Literals

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference
  • 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 Teradata Database to do relational comparison on ARRAY data. For information about these functions, see “ARRAY Functions and Operators” in 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 Teradata Database 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.