ot;gerald_clark" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>; "MySQL"
<[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 4:12 PM
Subject: Re: Is it normal?
Any ca
lin)" <[EMAIL PROTECTED]>; "MySQL"
<[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 4:12 PM
Subject: Re: Is it normal?
Any calculation involving a floating point number will be imprecise.
It does not mater what column types are involved.
Octavian Rasnita wrote:
&g
;
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect \(Berlin\)" <[EMAIL PROTECTED]>,
"MySQL" <[EMAIL PROTECTED]>
References: <006101c2c09a$9c0f7330$[EMAIL PROTECTED]>
<01e601c2c0ce$1a5cf1d0$dc4fc7d9@mephisto>
Sub
L" <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 11:42 PM
Subject: Re: Is it normal?
Octavian,
mysql> create table test(id float);
mysql> insert into test values(1.123), (3.1495);
mysql> select * from test where id=1.123;
Empty set (0.00 sec)
Shouldn't this last
-
From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 11:42 PM
Subject: Re: Is it normal?
Octavian,
> mysql> create table
rer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, January 20, 200
ECTED]>
Sent: Monday, January 20, 2003 10:34
Subject: Is it normal?
> Hi all,
>
> I've tried the following SQL queries:
>
> mysql> create table test(id float);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into test values(1.123), (3.1495);
Hi all,
I've tried the following SQL queries:
mysql> create table test(id float);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values(1.123), (3.1495);
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from test where id=1.123;
Empty set