6 messages in com.mysql.lists.bugsRe: Fatal error in comparing numbers
FromSent OnAttachments
Marek25 Mar 2002 02:41 
BICHOT Guilhem 17261325 Mar 2002 03:44 
Sinisa Milivojevic25 Mar 2002 06:57 
Mats Remman25 Mar 2002 07:18 
Sinisa Milivojevic25 Mar 2002 07:45 
Michael Widenius25 Mar 2002 09:37 
Subject:Re: Fatal error in comparing numbers
From:Sinisa Milivojevic (sin@mysql.com)
Date:03/25/2002 06:57:43 AM
List:com.mysql.lists.bugs

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 ....