ARRAY and JSON Type Element References - Teradata Vantage

When parsing a request that features syntax matching both a Vantage ARRAY type element reference and a JSON type array reference, the following logic is used:

1. The syntax is first treated as an element reference on a Vantage ARRAY type.
2. If the source is not an ARRAY type, Vantage checks to see if the source is an instance of the JSON type.
3. If the source is a JSON type instance, Vantage interprets the syntax as a JSON type array reference.
4. If the source is not a JSON type instance, an error is returned indicating an incorrect array element reference.