Description:
Mysql arbitrarily rounds large floats
How-To-Repeat:
create table temp (
id int unsigned not null auto_increment primary key,
amount float(8,2)
);
insert into temp(amount) values(244409.29);
insert into temp(amount) values(444409.29);
insert into temp(amount) values(777409.29);
insert into temp(amount) values(999409.29);
select * from temp;
+----+-----------+
| id | amount |
+----+-----------+
| 1 | 244509.30 |
| 2 | 444509.28 |
| 3 | 777509.31 |
| 4 | 999509.31 |
+----+-----------+
4 rows in set (0.00 sec)
Fix:
Not Known
>Submitter-Id: <submitter ID>
Originator: Lonny Byrd
Organization: Bake Crafters
<organization of PR author (multiple lines)>
MySQL support: none
Synopsis: Mysql arbitrarily rounds large floats
Severity: serious
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.42 (Source distribution) AND mysql 3.23.53
Environment:
machine, os, target, libraries (multiple lines)>
System: FreeBSD secure.bakecrafters.com 4.4-RELEASE FreeBSD 4.4-RELEASE #8:
Mon
Apr 1 09:00:21 GMT 2002
[EMAIL PROTECTED]:/usr/src/sys/compile/SERVERBERT i386
Also tried on System: Linux squiggle.kianta.com 2.4.9-31 #1 Tue Feb 26
07:11:02 EST 2002 i686 unknown
running mysql Ver 11.18 Distrib 3.23.53, for pc-linux-gnu (i686) and got
identical results
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/
bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='c++'
CXXFLAGS='-O -pipe -f
elide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1205382 Sep 18 2001 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Jan 23 2002 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 572876 Sep 18 2001 /usr/lib/libc.so.4
Configure command:
./configure --localstatedir=/var/db/mysql --without-perl --w
ithout-debug --without-readline --without-bench --with-mit-threads=no --with
-lib
wrap --with-low-memory --enable-assembler --with-berkeley-db --prefix=/usr/l
ocal
i386--freebsd4.4
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
