v.23.5Improvement
IN Operator Supports Comparison of Date and Date32
INoperator support the comparison ofDateandDate32. Closes #48736. #48806 (flynn).
Why it matters
This feature enables users to use theIN 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 theIN 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.