Snowflake - false positive error on array functions

Completed
Avatar
Dawid
Created

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

Votes

0

Share

4 comments
Avatar
Daniil
Created

Hi,

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

0
Avatar
Dawid
Created

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

SELECT
  ARRAY_INTERSECTION([123, 125, 124], [1111, 1112])
0
Avatar
Daniil
Created

Thanks for the follow-up.

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

0
Avatar
Dawid
Created

Awesome, thank you

0

Please sign in to leave a comment.