[sqlite] Sqlite SUM erroneous return value

[wvanry]

Hi,

I have created a table with the following values.....

CREATE TABLE [test] ([Id] TEXT DEFAULT(0), [PV] REAL DEFAULT(0));

insert into [test] ("Id", "PV") values ('485314EL', '-720.237');
insert into [test] ("Id", "PV") values ('485314L',  '-720.237');
insert into [test] ("Id", "PV") values ('485314LE', '720.237');
insert into [test] ("Id", "PV") values ('485440EL', '-720.237');
insert into [test] ("Id", "PV") values ('485440L',  '-720.237');
insert into [test] ("Id", "PV") values ('485440LE', '720.237');
insert into [test] ("Id", "PV") values ('522116EL', '720.237');
insert into [test] ("Id", "PV") values ('522116L', '720.237');
insert into [test] ("Id", "PV") values ('522116LE', '-720.237');
insert into [test] ("Id", "PV") values ('522122EL', '720.237');
insert into [test] ("Id", "PV") values ('522122L', '720.237');
insert into [test] ("Id", "PV") values ('522122LE', '-720.237');

However when I execute a SUM against this table I get an incorrect
value. The query I use is 

SELECT SUM([PV] ) from [test] 

The returned value is 2.2737e-13 instead of 0. 

Can anyone shed some light?


Sent from my BlackBerry® wireless device
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users