16.20 - ARRAY Type Element Reference vs. JSON Type Array Reference - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ JSON Data Type

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference

When parsing a request that features syntax matching both a Teradata ARRAY type element reference and a JSON type array reference, the following logic is employed:

  1. The syntax is first treated as an element reference on a Teradata ARRAY type.
  2. If it is determined that the source is not an ARRAY type, Teradata checks to see if it is an instance of the JSON type.
  3. If it is a JSON type instance, Teradata interprets the syntax as a JSON type array reference.
  4. If it is not a JSON type instance, an error is returned indicating an incorrect array element reference.