ARRAY Type Element Reference vs. JSON Type Array Reference - Advanced SQL Engine - Teradata Database

When parsing a request that features syntax matching both a Teradata Vantage 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 Vantage ARRAY type.
2. If it is determined that the source is not an ARRAY type, TeradataVantage checks to see if it is an instance of the JSON type.
3. If it is a JSON type instance, Vantage 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.