[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] ***suspected spam*** Re: Simple Math Question
From:       Dominique Devienne <ddevienne () gmail ! com>
Date:       2015-10-23 9:01:50
Message-ID: CAFCRh-84Gea6RM4F6wMc+Wrcnysicpx5gZ1MPWfFUj6y69mn4A () mail ! gmail ! com
[Download RAW message or body]

On Fri, Oct 23, 2015 at 10:47 AM, Hick Gunter <hick@scigames.at> wrote:

> Once the binary representation of an integer value becomes longer than the
> mantissa, even integers will start to fall into the space in between
> adjacent floating point values...
>
> asql> select (9007199254740992.0 + 1.0) - (9007199254740992.0 + 2.0);
> (9007199254740992.0 + 1.0) - (9007199254740992.0 + 2.0)
> -------------------------------------------------------
> -2.0
> asql> select (9007199254740992.0 + 1.0) - (9007199254740992.0);
> (9007199254740992.0 + 1.0) - (9007199254740992.0)
> -------------------------------------------------
> 0.0


See also
http://stackoverflow.com/questions/1848700/biggest-integer-that-can-be-stored-in-a-double
for more details. --DD
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]