15.10 - ARRAY Type Element Reference vs. JSON Type Array Reference - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K

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.