Re: [sqlite] SQLite4 key encoding bug

2012-07-10 Thread Richard Hipp
On Tue, Jul 10, 2012 at 11:54 AM, Igor Tandetnik wrote: > 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

Re: [sqlite] SQLite4 key encoding bug

2012-07-10 Thread Igor Tandetnik
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

Re: [sqlite] SQLite4 key encoding bug

2012-07-10 Thread Richard Hipp
On Tue, Jul 10, 2012 at 11:33 AM, Igor Tandetnik wrote: > On 7/10/2012 11:24 AM, Ryan Johnson wrote: > >> On 10/07/2012 9:58 AM, >> bardzotajneko...@interia.pl wrote: >> >>> SQLite version 4.0.0 2012-07-07 12:21:48 >>> Enter ".help" for instructions >>> Enter SQL statements

Re: [sqlite] SQLite4 key encoding bug

2012-07-10 Thread Igor Tandetnik
On 7/10/2012 11:24 AM, Ryan Johnson wrote: On 10/07/2012 9:58 AM, bardzotajneko...@interia.pl wrote: SQLite version 4.0.0 2012-07-07 12:21:48 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(a); sqlite> insert into t values(123); sqlite> insert

Re: [sqlite] SQLite4 key encoding bug

2012-07-10 Thread Ryan Johnson
On 10/07/2012 9:58 AM, bardzotajneko...@interia.pl wrote: SQLite version 4.0.0 2012-07-07 12:21:48 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(a); sqlite> insert into t values(123); sqlite> insert into t values(123.0); sqlite> insert into t

[sqlite] SQLite4 key encoding bug

2012-07-10 Thread bardzotajnekonto
SQLite version 4.0.0 2012-07-07 12:21:48 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(a); sqlite> insert into t values(123); sqlite> insert into t values(123.0); sqlite> insert into t values(12323); sqlite> insert into t values(12323.0); sqlite>