v.23.5Improvement

IN Operator Supports Comparison of Date and Date32

IN operator support the comparison of Date and Date32. Closes #48736. #48806 (flynn).
The IN operator now supports comparison with Date and Date32 data types in ClickHouse.

Why it matters

This feature enables users to use the IN operator for filtering and matching values directly against Date and Date32 columns, improving query expressiveness and convenience when working with date data types.

How to use it

Users can now write queries that use the IN operator with Date or Date32 columns as usual, for example:
SELECT * FROM table WHERE date_column IN ('2024-01-01', '2024-01-02')

No special configuration is required to enable this feature.