On 6/13/19, Donald Shepherd <donald.sheph...@gmail.com> wrote: > > When I reported that testing on 3.8.7.2 stored -0.0 but retrieved 0.0, your > comment on this list was that "SQLite converts integer floating point > values to actual integers for storage (because that takes up less space on > disk) and then converts back to double upon retrieval. That round-trip > would change -0.0 into +0.0." I was wondering when this changed?
You are right. I had forgotten about that point. This has not been changed even now, and so -0.0 does get truncated to +0.0 when it is stored in the database file. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users