Hi,
Will Leshner wrote:
In version SQLite 2.8.15 I'm having a situation with a query that I don't quite understand. This only happens on some machines. Basically I have a table with an Integer field that contains integers. And I have a query that is returning those integers as real numbers. So, for example, if I have 234 in the field, I'm getting back '233.9999999'. As I step through the code, I'm finding myself in Stringify in the OP_Callback case of sqliteVdbeExec. Inside of Stringify, the column's flags are set to MEM_Real, which causes the value to be converted from a real number to a string using sqlite_snprintf(). On many machines the number comes in as, say, '234.000000' and it gets turned into '234'. But on some machines it comes in as '233.999999' and goes out as '233.999999', which messes things up down the line. Has anybody run into anything like this before? Is there some setting I may be missing. We recently upgraded from 2.8.6 to 2.8.15 and it is entirely possible we changed a setting somewhere during the upgrade.
Thanks.
Not a solution, but ... get any sqlite manager like sqliteadmin or sqliteexplorer and check what is really stored in database table.
Regards Boguslaw Brandys
