v.19.15Improvement
Add Ability to Use Function Hex Without Using Reinterpretasstring for Float32, Float64
Add ability to use functionhexwithout usingreinterpretAsStringforFloat32,Float64. #7024 (Mikhail Korotov)
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 thehex 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.