sumKahan 

Calculates the sum of the numbers with Kahan compensated summation algorithm
Slower than sum function.
The compensation works only for Float types.

Syntax

sumKahan(x)

Arguments

Returned value

Example

Query:

SELECT sum(0.1), sumKahan(0.1) FROM numbers(10);

Result:

┌───────────sum(0.1)─┬─sumKahan(0.1)─┐
│ 0.9999999999999999 │             1 │
└────────────────────┴───────────────┘

Rating: 4 - 1 votes

Was this content helpful?
★★★★☆