v.23.2Improvement

Improve Date Conversion for Boundary Value 65535

Improve behaviour of conversion into Date for boundary value 65535 (2149-06-06). #46042 #45914 (Joanna Hulboj).
Improved handling of the conversion of integer values to Date type, specifically for the boundary value 65535 which corresponds to the date 2149-06-06.

Why it matters

This feature addresses issues with the conversion of the maximum allowed value for the Date type in ClickHouse. It ensures that the boundary value 65535 is correctly interpreted as the date 2149-06-06, preventing conversion errors or unexpected behavior when working with this upper limit date value.

How to use it

No explicit user action is required. The improvement is applied internally to the Date type conversion logic, so any conversion from integers to Date that involves the boundary value 65535 will automatically benefit from this fix.