v.21.11Improvements

Fixed Date32 Comparison with Other Types

Official CH changelog text
Fixed comparison of Date32 with Date, DateTime, DateTime64 and String. #30219 (liang.huang).
Fixed the comparison logic between Date32 and other date/time types like Date, DateTime, DateTime64, and String in ClickHouse.

Why it matters

This fix resolves inconsistencies and errors when comparing Date32 values with different date/time formats and string representations. It ensures accurate and reliable comparison operations across these data types, improving data correctness and query results.

How to use it

Users do not need to take any specific action to enable this fix. The improved comparison behavior is integrated into ClickHouse and will be applied automatically when executing comparison operations involving Date32 with Date, DateTime, DateTime64, or String types.

Related resources

PreviousNext