v.19.15Improvement

Add Ability to Use Function Hex Without Using Reinterpretasstring for Float32, Float64

Add ability to use function hex without using reinterpretAsString for Float32, Float64. #7024 (Mikhail Korotov)
Added support for the hex function to directly accept Float32 and Float64 types without needing to use reinterpretAsString.

Why it matters

This feature simplifies the process of converting floating point numbers (Float32 and Float64) to their hexadecimal string representation by removing the extra step of reinterpreting the data as strings. It enhances usability and improves query readability.

How to use it

You can now apply the hex function directly on Float32 or Float64 columns or values, for example:

SELECT hex(your_float32_column) FROM your_table;

No need to wrap the input with reinterpretAsString anymore.