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

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

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.