SQLite Forum

ORDER BY not working for a specific DB/table
The purpose of the CLI .dump command is to produce a file of SQL commands which, when executed, will produce "the same database content" as the database which was originally .dump'ed.

In the case of double precision floating-point numbers, round tripping the **exact** value requires that 18 digits be used.  Humans are not expected to look at nor care what is contained in the .dump file.

However, when the CLI application "prints" a floating-point number it does so for human consumption.  This means that it only displays a limited precision and "rounds" the result so that it is pretty for the viewer, because if all floating-point values were always printed to their full 18-digits of precision, one would quickly tire of looking at them.  Almost all UI's "pretty print" floating point values rather than the actual value.