v.24.1Improvement

When Comparing Float32 Columns with Const Strings, Read as Float32

Official CH changelog text
When comparing a Float32 column and a const string, read the string as Float32 (instead of Float64). #58724 (Raúl Marín).
When comparing a Float32 column with a constant string, the string is now parsed as Float32 instead of Float64.

Why it matters

This feature ensures more accurate and efficient comparisons between Float32 columns and constant string values by matching the string parsing type to Float32. It prevents unnecessary type widening to Float64, which can improve performance and reduce subtle comparison inconsistencies.

How to use it

No special action is required by the user. Comparisons between Float32 columns and constant strings will now automatically parse the string as Float32.

Related resources

PreviousNext