Donald,
Will Leshner <[EMAIL PROTECTED]>
14/10/2004 04:20 AM
Please respond to sqlite-users
To: [EMAIL PROTECTED]
cc:
Subject: Re: [sqlite] strange rounding problem
>The point is that the number is in the database as '358', but by the time
we get it back from a query it has become '357.999'. We aren't doing any
floating point with the number. It is (apparently) happening for us in the
SQLite engine itself. But we depend on the number being '358' when we
query for it and because it isn't, on some machines, our app fails.
Can you come up with a minimal test case that exhibits this behaviour?
Ideally, it would be a series of SQL statements written into the sqlite
shell program that results in something visibly wrong. The second best
case would be a short (10-20 line) C program that uses the sqlite API only
to demonstrate the problem. Perhaps other users of this list could test on
their own machines and come up with more information.
Benjamin.
