v.19.8Improvements
In Predicate Now Generates Null Result from Null Input Like the Equal Function
Inpredicate now generatesNullresult fromNullinput like theEqualfunction. #5152 (Jian Wu)
Why it matters
This change ensures that theIN predicate handles Null inputs correctly by producing Null results instead of potentially misleading boolean values. It aligns the behavior of IN with that of the Equal function, improving correctness and predictability in query results involving Null values.How to use it
Users do not need to perform any explicit action to enable this behavior. TheIN predicate will automatically return Null when given Null inputs in the updated version.