Bug Report: NullPointerException when using ARRAY_CONTAINS on column

1

This code gives a NullPointerException error:

SELECT *
FROM foo
WHERE ARRAY_CONTAINS(ARRAY[1,2,3],id)

Considering that id is an column in the table foo.

I don’t know if it is supposed to work or not, but I think the error being a nullpointer indicates that, in the best case, it is an untreated error and, in the worst, it’s not working as intended.

2

@teoxugo Able to reproduce, thanks for the steps. I have filed a bug with Engineering

1 Like