v.23.5Improvement

Aggregation Functions Updated for Signed Integers in ClickHouse

Official CH changelog text
Aggregation function groupBitAnd/Or/Xor now work on signed integer data. This makes them consistent with the behavior of scalar functions bitAnd/Or/Xor. #49292 (exmy).
Aggregation functions groupBitAnd, groupBitOr, and groupBitXor now support signed integer data types, aligning their behavior with scalar bitwise functions.

Why it matters

Previously, these aggregation functions did not operate correctly on signed integers, causing inconsistency and limiting their usability. This update ensures consistent bitwise aggregation results for both signed and unsigned integer data, improving functionality and user experience.

How to use it

Use the aggregation functions groupBitAnd, groupBitOr, and groupBitXor on columns containing signed integer data as usual in your SELECT queries. No additional configuration is needed.

Related resources

PreviousNext