Snowflake - false positive error on array functions

Completed

I think there may be a statement missing that allows the usage of square brackets for array construction:

 

The statement is valid and executes correctly in Snowflake

4 comments
Comment actions Permalink

Hi,

Is there a chance to share that query in order to reproduce it on my own?

0
Comment actions Permalink

Sure, you can use anything as simple as the following:

SELECT
ARRAY_INTERSECTION([123, 125, 124], [1111, 1112])
0
Comment actions Permalink

Thanks for the follow-up.

The fix will be available in the next IDE updates, please see DBE-15890.

0
Comment actions Permalink

Awesome, thank you

0

Please sign in to leave a comment.