Sent from my BlackBerry® wireless device
-----Original Message-----
From: "Van Ry, Wayne" <[EMAIL PROTECTED]>
Date: Wed, 4 Jun 2008 14:17:33
To:<[EMAIL PROTECTED]>
Subject: FW: Sqlite SUM erroneous return value
>______________________________________________
> From: Van Ry, Wayne
> Sent: 04 June 2008 14:16
> To: 'sqlite-users@sqlite.org'
> Subject: Sqlite SUM erroneous return value
>
> 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?
>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - -
This message is intended only for the personal and confidential use of the
designated recipient(s) named above. If you are not the intended recipient of
this message you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited. This
communication is for information purposes only and should not be regarded as an
offer to sell or as a solicitation of an offer to buy any financial product, an
official confirmation of any transaction, or as an official statement of Lehman
Brothers. Email transmission cannot be guaranteed to be secure or error-free.
Therefore, we do not represent that this information is complete or accurate
and it should not be relied upon as such. All information is subject to change
without notice.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
