functions avg(), sum(), min(), max() at select statement returns wrong results for fields with type double(x,x). But not always.

# MySQL dump 7.1 # # Host: localhost Database: test2 #-------------------------------------------------------- # Server version 3.23.12c-alpha

# # Table structure for table 'test' # CREATE TABLE test ( id int(11) NOT NULL auto_increment, f double(10,8), PRIMARY KEY (id) );

# # Dumping data for table 'test' #

INSERT INTO test VALUES (1,4.00000000); INSERT INTO test VALUES (2,3.00000000); INSERT INTO test VALUES (3,2.00000000); INSERT INTO test VALUES (4,1.00000000);

select * from test; id f 1 4.00000000 2 3.00000000 3 2.00000000 4 1.00000000

select avg(f) from test; avg(f) 0.000000000000

select sum(f) from test; sum(f) 0.00000000

select min(f) from test; min(f) 0.00000000

select max(f) from test; max(f) 0.00000000

select avg(f),sum(f), min(f), max(f) from test; avg(f) sum(f) min(f) max(f) 0.000000000000 10.00000000 1.00000000 4.00000000

1. Use other type instead of double. Decimal for example. 2. Use fake function call at first field.

<machine, os, target, libraries (multiple lines)> System: Linux gold 2.2.17 #1 Sun Jun 25 09:24:41 EST 2000 i686 unknown Architecture: i686

Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 20000220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno -rtti' LDFLAGS='' Configure command: ./configure --enable-shared --without-readline --enable-assembler --with-my sqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock --prefix =/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql --da tadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info -- includedir=/usr/include --mandir=/usr/share/man Perl: This is perl, version 5.005_03 built for i386-linux:

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail bugs...@lists.mysql.com instead.