I can't follow this thread (NULLs make my head hurt), but it looks like Dr. Hipp has already taken action. Yesterday he made two changes to the source:
SUM returns NULL when it has no inputs: http://www.sqlite.org/cvstrac/chngview?cn=2678 A SUM() of all NULLs returns NULL. A SUM() of nothing return 0. A SUM() of a mixture of NULLs and numbers returns the sum of the numbers: http://www.sqlite.org/cvstrac/chngview?cn=2677 --Ned. http://nedbatchelder.com -----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Friday, 09 September, 2005 4:22 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SUM and NULL values Dr. Hipp, If my opinion is worth anything I'd prefer to stay with the standard, even though it might be a pain, etc. I've had too much bad experience with people writing code that depends on the quirks in other people's code. The decision is ultimately yours, and thanks for putting so much effort into it!
