Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
3.0.0
-
None
-
None
Description
Currently, we are not dealing with the nullability of IN predicate correctly.
1. IN(In, InSet, InSubquery) with nulls in the left values should return FALSE if the right side is an empty set. Example: `null in (select a from t where false)` should return false.
2. InSubquery is nullable according to the SQL standard. But we are using a non-nullable ExistenceJoin for the expression `(a in (select b from t)) is null`.