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:
- The syntax is first treated as an element reference on a Teradata ARRAY type.
- 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.
- If it is a JSON type instance, Teradata interprets the syntax as a JSON type array reference.
- If it is not a JSON type instance, an error is returned indicating an incorrect array element reference.