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.

Bernardo Sulzbach
sqlite-users mailing list

Reply via email to