VARIANT_ARRAY

Array of VARIANT type data.

VARIANT_ARRAY is created when parsing JSON_ARRAY.

Accessing elements

va=VARIANT_ARRAY([1,2,3])

va[0]   // => 1
va[1]   // => 2
va[2]   // => 3

Converting

VARIANT_ARRAY(array_expr)
VARIANT_ARRAY(expr)
  1. converts an ARRAY argument to VARIANT_ARRAY
  2. converts an expression of any type to VARIANT_ARRAY

Parsing

1
JSON_ARRAY:fieldname