On 1/29/15, Donald Shepherd <donald.sheph...@gmail.com> wrote:
> I'm still not convinced whether it's the behaviour causing my problem, but
> it does look like negative zero is another special case:
> SQLite version 2014-11-18 20:57:56
> Enter ".help" for usage hints.
> sqlite> create table datatable2 (doublevalue real);
> sqlite> insert into datatable2 values(-0.0);
> sqlite> select * from datatable2;
> 0.0

I suppose so.  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.

D. Richard Hipp
sqlite-users mailing list

Reply via email to