Due to recent checkin for implict type conversion, avg broke and it always returns NULLs.
The following test case shows the error:
Suppose table T(string c1) has 2 rows
select avg(c1), sum(c1), count(c1) from T
NULL 1.0 1
Fixing the description and summary to reflect the seriousness of the bug.
Fixed some test outputs.