On Sep 8, 2005, at 11:33 AM, D. Richard Hipp wrote:
SUM ignores NULLs. So if it ignores everything, it returns the sum of nothing, which is 0. (Not the 0.0 issue is fixed in CVS HEAD.)
Ah. Perhaps I shouldn't have filed a bug report then. Sorry about that. I wonder what other databases do with this?