v.20.4New Feature

Consider NULL Equal to NULL in IN Operator with transform_null_in Option

Official CH changelog text
Consider NULL to be equal to NULL in IN operator, if the option transform_null_in is set. #10085 (achimbab)
Enable treating NULL values as equal to NULL within the IN operator when the transform_null_in option is enabled.

Why it matters

By default, NULL comparisons using the IN operator do not consider two NULL values as equal. This feature addresses the problem of unexpected behavior when NULL values are involved in IN expressions, allowing users to treat NULL as equal to NULL. It provides more intuitive and flexible handling of NULL values in queries.

How to use it

To enable this feature, set the setting transform_null_in to 1. For example, use the query:

sql<br>SET transform_null_in = 1<br>

Related resources

PreviousNext