SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: marinoc
To: [EMAIL PROTECTED]
Subject: Failure when comparing floating point numbers
>Description:
A table is created with a field of type float(10,2). The field is
populated with a value of 0.8. Attempting to select the row with value of
0.8 will fail with SQL query like "SELECT * FROM table WHERE field=0.8".
However, the following SQL query will succeed "SELECT * FROM table WHERE
field like 0.80"
>How-To-Repeat:
Create a table with field of type float(10,2). Populate the table
with a value of 0.8 for the field of type float(10,2). Execute the SQL query
"SELECT * FROM table WHERE field=0.8".
>Fix:
A proper fix has not been determined. The row can be found using an
alternate SQL query, "SELECT * FROM table WHERE field like 0.80".
>Submitter-Id: <submitter ID>
>Originator: Christopher Marino
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: none
>Synopsis: <synopsis of the problem (one line)>
>Severity: serious
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.36 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for redhat-linux-gnu
on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 14 days 12 hours 13 min 18 sec
Threads: 3 Questions: 4483310 Slow queries: 0 Opens: 11911 Flush tables:
5 Open tables: 64 Queries per second avg: 3.576
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux devlnx.powerlink.qld.gov.au 2.4.2-2smp #1 SMP Sun Apr 8
20:21:34 EDT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++'
CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 May 27 06:53 /lib/libc.so.6 ->
libc-2.2.2.so
-rwxr-xr-x 1 root root 1236396 Apr 7 07:58 /lib/libc-2.2.2.so
-rw-r--r-- 1 root root 26350254 Apr 7 05:27 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 7 05:27 /usr/lib/libc.so
Configure command: ./configure i386-redhat-linux --prefix=/usr
--exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc
--datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib
--libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com
--mandir=/usr/share/man --infodir=/usr/share/info --without-debug
--without-readline --enable-shared --with-extra-charsets=complex
--with-bench --localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql
--with-extra-charsets=all --with-berkeley-db
Important Message:
[This transmission or any part of it is intended solely for the named
addressee. It is confidential. The copying or distribution of this
transmission or any information it contains, by anyone other than the
addressee, is prohibited.
If you have received this transmission in error, please let us know by
telephone 61 7 3860 2111 or by reply email to the sender. If you are not
the named addressee, you must destroy the original transmission and its
contents.
You may not rely on electronically transmitted material unless the
transmission is subsequently confirmed by fax or letter. Material
transmitted to you should also be checked by reference to a hard copy of
that material printed directly from our word processing system.]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
