Re: Serious BUG in 3.23!

[Christopher R. Jones]

If it is true that computers cannot accurately store 0.2 than should not
all applications have this trouble?
For example a test perl script:
#!\apps\perl\bin\perl.exe -w 
use strict;

my $test;
$test = 0.2;
if( $test == 0.2 )
{
	print("Test: $test\n");
}
else
{
	print("Not Test: $test\n");
}

I would expect the same results using C, BASIC, FORTRAN and MySQL.

>All very true, but it ought to be possible for mysqld to do the right
>thing for simple constants that have not undergone any manipulation
>(addition, subtraction etc).
>
>The code within the client and server just need to take care not to
>"manipulate" the number in any way.
>
>Tim.
>
>-- 
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread28563@stripped
>
>To unsubscribe, send a message to:
>    <mysql-unsubscribe-cj=interlog.com@stripped>
>
>
>
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. [phone]
Fax. [phone]
Email cj@stripped