v.19.16Improvement

Clickhouse Ignores Values on the Right Side of IN Operator That Are Not Convertible to the Left Side Type

Official CH changelog text
ClickHouse ignores values on the right side of IN operator that are not convertible to the left side type. Make it work properly for compound types – Array and Tuple. #7283 (Alexander Kuzmenkov)
Improved the behavior of the IN operator to correctly handle values on the right side that are not convertible to the left side type, specifically for compound types like Array and Tuple.

Why it matters

Previously, ClickHouse ignored values on the right side of the IN operator if they were not convertible to the left side's type. This update ensures proper type checking and comparison for compound types such as Array and Tuple, preventing incorrect query results and improving query reliability.

How to use it

This feature works transparently and requires no special configuration. Users can simply use the IN operator with Array and Tuple values, and ClickHouse will now handle type conversion checks correctly.

Related resources

PreviousNext