ARRAY Type Element Reference vs. JSON Type Array Reference

Teradata Vantageā„¢ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

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.