v.24.9New Feature

Implemented Interval Data Type Value Comparison Across Domains

Official CH changelog text
Implemented comparison for Interval data type values of different domains (such as seconds and minutes) so they are converting now to the least supertype. #68057 (Yarik Briukhovetskyi).
Implemented comparison operations for Interval data type values across different domains (e.g., seconds, minutes) by converting them to their least supertype.

Why it matters

This feature resolves the issue of comparing Interval values belonging to different units, such as seconds and minutes, by enabling automatic conversion to a common supertype. It improves query correctness and usability when working with mixed Interval domains.

How to use it

Users can directly compare Interval values of different domains in their queries without needing manual conversions. For example, comparisons between INTERVAL 10 SECOND and INTERVAL 1 MINUTE will work as expected.

Related resources

PreviousNext