v.21.1Improvements

All Decimal and Float Queries Allowed with Result Types Float32 or Float64

Official CH changelog text
All queries of type Decimal * Float or vice versa are allowed, including aggregate ones (e.g. SELECT sum(decimal_field * 1.1) or SELECT dec_col * float_col), the result type is Float32 or Float64. #18145 (Mike).
Support for multiplication between Decimal and Float data types in all query contexts, including aggregates, with the result being Float32 or Float64.

Why it matters

This feature resolves the limitation where multiplication between Decimal and Float types was not supported, enabling more flexible and accurate mathematical operations involving mixed numeric types, particularly in aggregate functions.

How to use it

Users can directly write queries involving multiplication between Decimal and Float columns or constants, for example:

SELECT sum(decimal_field  1.1)
SELECT dec_col  float_col

No special settings are required; the feature is enabled by default.

Related resources

PreviousNext