On 7/10/2012 11:44 AM, Richard Hipp wrote:
SQLite4 is still using "double" internally for floating point computations. (Yes, there are plans to change that but it has not happened yet.) The bug above is due to rounding errors in the doubles, specifically rounding errors that occur when doing the key encoding.
Both 123.0 and 12323.0 should be exactly representable in a double, as far as I can tell.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users