List:General Discussion« Previous MessageNext Message »
From:Christopher R. Jones Date:February 22 2000 2:48pm
Subject:Re: Serious BUG in 3.23!
View as plain text  
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. 416 203-7465
Fax. 416 203-3044
Email cj@stripped


Thread
Serious BUG in 3.23!Dimitri22 Feb
  • Re: Serious BUG in 3.23!Gary Bickford22 Feb
    • Re: Serious BUG in 3.23!Tim Bunce22 Feb
      • Re: Serious BUG in 3.23!Dan Nelson22 Feb
        • Re: Serious BUG in 3.23!Tim Bunce22 Feb
          • Re: Serious BUG in 3.23!Benjamin Pflugmann25 Feb
            • Re: Serious BUG in 3.23!Thimble Smith25 Feb
              • Re: Serious BUG in 3.23!Benjamin Pflugmann25 Feb
  • Re: Serious BUG in 3.23!Jaime Teng22 Feb
  • Re: Serious BUG in 3.23!James Lyon22 Feb
  • Re: Serious BUG in 3.23!Jan Dvorak22 Feb
  • Re: Serious BUG in 3.23!Jan Dvorak25 Feb
  • Re: Serious BUG in 3.23!Gary Bickford2 Mar
Re: Serious BUG in 3.23!Jimmy Moore22 Feb
Re: Serious BUG in 3.23!Dimitri22 Feb
Re: Serious BUG in 3.23!Christopher R. Jones22 Feb
  • Re: Serious BUG in 3.23!Vivek Khera22 Feb
  • Re: Serious BUG in 3.23!Benjamin Pflugmann25 Feb
  • Re: Serious BUG in 3.23!Gary Bickford25 Feb
Re: Serious BUG in 3.23!James Lyon23 Feb