Marek writes:
From: <wmar...@kki.net.pl>
To: mysq...@lists.mysql.com
Subject: [Fatal error in comparing numbers]
Description:
When you use in a query (at least) two figures 11.4 and 18.9 the results are
incorrect. It seems something like malicious numbers but it is quite
annuying and disqualifying.
In a query select (11.4+18.90)=30.30 the result will be "0".
although select 11.4+18.9 will give 30.30 ie correct answer. I don't think
the summe 30.30 is fatal figure because for example trying with 11.5 and
18.8 gives good answers. Trying with for example 111.4 and 118.9 etc gives
good results.
Hi!
I have tried all your examples with 4.0.2 and all worked fine. This
is some bug fixed long time ago.
I did not try it with current 3.23 branch though ....