On Fri, Oct 23, 2015 at 10:47 AM, Hick Gunter <hick at 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