FYI. There's no need to pin back the whole db version just to get the old style dbdump format. The original dump is available from the distribution as a standalone program here:
http://www.sqlite.org/src/artifact/819eb33f6ff788a4 --dbdump.c-- ** If this file is compiled with -DDBDUMP_STANDALONE then a "main()" routine ** is included so that this routine becomes a command-line utility. The ** command-line utility takes two or three arguments which are the name ** of the database file, the schema, and optionally the table Compile and enjoy. Peter On Mon, Jan 22, 2018 at 11:46 AM, Tony Papadimitriou <to...@acm.org> wrote: > I reported this same issue in May 2017 (http://mailinglists.sqlite.or > g/cgi-bin/mailman/private/sqlite-users/2017-May/072714.html) > I too consider this a problem (diffing dumps is one good reason why) but, > unfortunately, this was an intentional change by this check-in: > > [7359fcac] Increase the number of significant digits in floating point > literals on ".dump" output from the shell. > > Tony > -----Original Message----- From: Iulian Onofrei > > This is clearly a bug, as it outputs incorrect and different output from > the > previous versions. > > I have a "REAL" column with float values having up to 2 decimals, and using > ".dump" with the latest version incorrectly converts them like this: > > "0.05" -> "0.050000000000000002775" > > I rely on dumps to track changes to some databases, so this breaks it > completely, and I currently had to pin sqlite to an older version which > isn't desired. > > Thank you, > iulianOnofrei > > _______________________________________________ > 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