-
Notifications
You must be signed in to change notification settings - Fork 2k
Closed
Labels
bugSomething isn't workingSomething isn't working
Description
Describe the bug
A clear and concise description of what the bug is.
This #2156 introduce an optimization for checking value in/not in the list.
But it ignore the NULL case.
In the SQL system, NULL is not equal to NULL.
Like below case:
select 1 in (2,3,4,5,......100, null) return null
But now It will return false.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
A clear and concise description of what you expected to happen.
Additional context
Add any other context about the problem here.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working