v.24.6New Feature

Support Decimal Arguments in Binary Math Functions

Support decimal arguments in binary math functions (pow, atan2, max2, min2, hypot). #64582 (Mikhail Gorshkov).
Support for decimal arguments has been added to binary math functions including pow, atan2, max2, min2, and hypot in ClickHouse.

Why it matters

This feature enables users to use decimal data types directly with key binary mathematical functions, improving precision and consistency when working with decimal numbers and eliminating the need to cast decimals to other types before function usage.

How to use it

Simply pass decimal type arguments to the supported binary math functions like pow, atan2, max2, min2, and hypot in your SQL queries without any additional configuration or casting.