@Gemma
linked you to a download via pm
And found the cause i think
http://dev.mysql.com/doc/refman/5.0/...ith-float.html
Quote:
The result is correct. Although the first five records look like they should not satisfy the comparison (the values of a and b do not appear to be different), they may do so because the difference between the numbers shows up around the tenth decimal or so, depending on factors such as computer architecture or the compiler version or optimization level. For example, different CPUs may evaluate floating-point numbers differently.
|