On 10/17/2016 07:12 AM, Quan Yong Zhai wrote:
I can’t reproduce the problem,
As it has already been pointed out, this is normal for floating point
arithmetic. In your machine, implementation, and SQLite installation the
two value representations may be identical, while in others it may not be.
fabs(a - b) is the simplest way to have an idea of how close two values
are, and dividing by the magnitude of one of them (after checking that
it is not zero, etc.) afterwards is also a good idea in some cases.
sqlite-users mailing list