On the plus side they come out equal, so apart from neatness of the display, all's good. Interesting how the auto EQP output shows up in the .dump output. But at least it starts with -- so won't harm anything.
SQLite version 3.18.0 2017-03-28 18:48:43 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table xxx (x primary key); Run Time: real 0.000 user 0.000000 sys 0.000000 sqlite> insert into xxx values (1.23); Run Time: real 0.000 user 0.000000 sys 0.000000 sqlite> select * from xxx; --EQP-- 0,0,0,SCAN TABLE xxx x 1.23 Run Time: real 0.004 user 0.000000 sys 0.000000 sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE xxx (x primary key); --EQP-- 0,0,0,SCAN TABLE xxx INSERT INTO xxx(x) VALUES(1.2299999999999999822); COMMIT; sqlite> INSERT INTO xxx(x) VALUES(1.2299999999999999822); Run Time: real 0.000 user 0.000000 sys 0.000000 Error: UNIQUE constraint failed: xxx.x sqlite> delete from xxx; Run Time: real 0.000 user 0.000000 sys 0.000000 sqlite> INSERT INTO xxx(x) VALUES(1.2299999999999999822); Run Time: real 0.000 user 0.000000 sys 0.000000 sqlite> select * from xxx; --EQP-- 0,0,0,SCAN TABLE xxx x 1.23 Run Time: real 0.003 user 0.000000 sys 0.000000 sqlite> insert into xxx values (1.23); Run Time: real 0.000 user 0.000000 sys 0.000000 Error: UNIQUE constraint failed: xxx.x -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, May 03, 2017 2:12 PM To: SQLite mailing list Subject: Re: [sqlite] .DUMP displays floats differently from SELECT In a previous message I suggest that behaviour under macOS changed between SQLite 3.16.0 and SQLite 3.18.0. I then received information from a lurker who uses Windows 7: SQLite version 3.17.0 2017-02-13 16:02:40 INSERT INTO "xxx" VALUES(1.23); … SQLite version 3.18.0 2017-03-28 18:48:43 INSERT INTO xxx VALUES(1.2299999999999999822); It does seem that this is due to a recent change in SQLite source code. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
