Re: [sqlite] SUM and NULL values

[Robert Simpson]

If SQLite doesn't conform to the SQL standard, it'll break several other 
dependencies on the standard:

CREATE TABLE salaries (empid int, hourlywage money, yearlywage money, 
emptype int)

INSERT INTO salaries VALUES(1, 12.95, null, 1)
INSERT INTO salaries VALUES(2, null, 80000.00, 2)

SELECT COALESCE(SUM(hourlywage * 40 * 52), SUM(yearlywage)) from salaries 
GROUP BY emptype


In SQL Server, this returns:


--------------------- 
26936.0000
80000.0000


In SQLite it returns:


--------------------- 
26936
0