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.)
As a data point, MySQL returns NULL for a SUM over fields that are all NULL. I am not suggesting, of course, that SQLite should imitate MySQL.