v.1.1.54310New Feature

Added sumWithOverflow Aggregate Function

Added the sumWithOverflow aggregate function.
Added the sumWithOverflow aggregate function that performs summation of values allowing overflow without errors.

Why it matters

The sumWithOverflow function was created to address the problem of overflow errors during aggregation of large numeric values in ClickHouse. It allows summing numbers with overflow by wrapping the result around instead of throwing an error, enabling users to work with large data sets where overflow might occur and maintain query stability.

How to use it

Use the sumWithOverflow aggregate function in your queries in the same way as the standard sum function. For example:

SELECT sumWithOverflow(column_name) FROM table_name

This will calculate the sum of values in column_name and if overflow occurs, it will wrap around without failing the query.