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.

How-To-Repeat: Write in a client a statement: select (11.4+18.9)=30.30;

Fix: Have no idea.

Synopsis: <Critical error in comparing numbers> Submitter-Id: <0> Originator: <Marek Woch> Organization: <Marek Woch> MySQL support: [none] Severity: [critical ] Priority: [high ] Category: [mysqld] Class: [ sw-bug ] Release: mysql-3.23.38 although my version is signed 3.32.47

Exectutable: [mysqld, mysqld-opt] Environment: <Celeron 700, memory 195 MB, mainboard BVC3A> System: <Win98> Compiler: VC++ 6.0 Architecture: i

--- Przylacz sie do nas! Niezapomniane wrazenia z antywiruswej akcji!

---