v.19.8Improvements

In Predicate Now Generates Null Result from Null Input Like the Equal Function

In predicate now generates Null result from Null input like the Equal function. #5152 (Jian Wu)
IN predicate now returns Null when the input is Null, consistent with the behavior of the Equal function.

Why it matters

This change ensures that the IN 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. The IN predicate will automatically return Null when given Null inputs in the updated version.