v.23.2Improvement

More Convenient Usage of Big Integers and ORDER BY WITH FILL in ClickHouse

Official CH changelog text
More convenient usage of big integers and ORDER BY WITH FILL. Allow using plain integers for start and end points in WITH FILL when ORDER BY big (128-bit and 256-bit) integers. Fix the wrong result for big integers with negative start or end points. This closes #16733. #46152 (Alexey Milovidov).
Improved support for big integers (128-bit and 256-bit) in ORDER BY WITH FILL, allowing usage of plain integers as start and end points and fixing incorrect results when these points are negative.

Why it matters

This feature addresses the inconvenience and inaccuracies encountered when using big integer types with ORDER BY WITH FILL. It enables users to specify start and end points as simple integers even for large integer columns, and corrects the handling of negative boundary values, thereby enhancing query correctness and usability.

How to use it

When using ORDER BY WITH FILL on columns with Int128 or Int256 types, you can now specify the start and end parameters as plain integer literals. The system will correctly interpret these values and produce accurate results even if they are negative.

Related resources

PreviousNext