DuckDB favg returns the wrong average when values differ greatly in magnitude
· 3 min read
In DuckDB 1.5.5 and 2.0.0, favg returns the wrong average when values differ greatly in magnitude. Over the four doubles 1, 1e100, 1, and −1e100, it returns 0.0. It should return 0.5.