Affects Version/s: None
Fix Version/s: None
FAILED: Error in semantic analysis: line 4:8 Non Constant Expressions for Array Indexes not Supported dut
...just wrote my own UDF to do this, and it is trivial. We should support this natively.
Let foo have these rows:
SELECT arr[i] FROM foo
Similarly, for the same table,
SELECT 3 IN arr FROM foo
...these use cases are needless limitations of functionality. We shouldn't need UDFs to accomplish these goals.