While trying to search/replace some text from an SQLite3 dump I noticed that, unfortunately, .DUMP does not produce the exact same numbers as a plain SELECT on the same values.
I know all about expected floating point inaccuracies, but I don’t see why it should matter in this case as we have two different places in the same app (SQLite3) where the same number is ‘displayed’ using whatever default format. IMO, in both places the same number should display exactly the same (i.e., using the same format), both for consistency and easy verification between dump and actual database. Below is a sample script and its output that demonstrate the issue (using SQLite 3.18.0 2017-03-28 18:48:43): SCRIPT: ------------ create table xxx(x); insert into xxx values(1.23); select * from xxx; .dump OUTPUT: ------------ 1.23 PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE xxx(x); INSERT INTO xxx VALUES(1.2299999999999999822); COMMIT; Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
