Description:
When MySQL is compiled using the following commands (from Section 2.4.3.5 of the MySQL Manual):
CC=xlc_r CFLAGS="-ma -O2 -qstrict -qoptimize=2 -qmaxmem=8192"
CXX=xlC_r CXXFLAGS="-ma -O2 -qstrict -qoptimize=2 -qmaxmem=8192"
./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data
--libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex
--enable-thread-safe-client --enable-local-infile --with-named-z-libs=no
--disable-shared --with-embedded-server --with-innodb
the type_float test fails with this output:
Logging: ./mysql-test-run type_float
MySQL Version 5.0.41
Skipping ndbcluster, mysqld not compiled with ndbcluster
Skipping SSL, mysqld not compiled with SSL
Using MTR_BUILD_THREAD = 0
Using MASTER_MYPORT = 9306
Using MASTER_MYPORT1 = 9307
Using SLAVE_MYPORT = 9308
Using SLAVE_MYPORT1 = 9309
Using SLAVE_MYPORT2 = 9310
Using IM_PORT = 9312
Using IM_MYSQLD1_PORT = 9313
Using IM_MYSQLD2_PORT = 9314
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Installing Master Database
=======================================================
Starting Tests in the 'main' suite
TEST RESULT TIME (ms)
-------------------------------------------------------
type_float [ fail ]
Errors are (from /opt/freeware/src/packages/BUILD/mysql-5.0.41/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/type_float.result Wed May 2 18:10:49 2007
--- r/type_float.reject Tue Jun 12 22:12:54 2007
***************
*** 280,290 ****
1 SIMPLE t1 ALL NULL NULL NULL NULL 26 Using temporary; Using filesort
select sum(b) s from t1 group by a;
s
! 0.00
100.00
0.00
-0.00
- -0.00
0.00
select sum(b) s from t1 group by a having s <> 0;
s
--- 280,290 ----
1 SIMPLE t1 ALL NULL NULL NULL NULL 26 Using temporary; Using filesort
select sum(b) s from t1 group by a;
s
! -0.00
100.00
0.00
+ 0.00
-0.00
0.00
select sum(b) s from t1 group by a having s <> 0;
s
***************
*** 294,303 ****
100.00
select sum(b) s from t1 group by a having s <=> 0;
s
0.00
0.00
-0.00
- -0.00
0.00
select sum(b) s from t1 group by a having s <=> 0 order by s;
s
--- 294,303 ----
100.00
select sum(b) s from t1 group by a having s <=> 0;
s
+ -0.00
0.00
0.00
-0.00
0.00
select sum(b) s from t1 group by a having s <=> 0 order by s;
s
***************
*** 312,323 ****
1 SIMPLE t1 index NULL a 14 NULL 26 Using index
select sum(b) s from t1 group by a;
s
! 0.00
100.00
0.00
- -0.00
0.00
0.00
select sum(b) s from t1 group by a having s <> 0;
s
100.00
--- 312,323 ----
1 SIMPLE t1 index NULL a 14 NULL 26 Using index
select sum(b) s from t1 group by a;
s
! -0.00
100.00
0.00
0.00
0.00
+ 0.00
select sum(b) s from t1 group by a having s <> 0;
s
100.00
***************
*** 326,334 ****
100.00
select sum(b) s from t1 group by a having s <=> 0;
s
0.00
0.00
- -0.00
0.00
0.00
select sum(b) s from t1 group by a having s <=> 0 order by s;
--- 326,334 ----
100.00
select sum(b) s from t1 group by a having s <=> 0;
s
+ -0.00
0.00
0.00
0.00
0.00
select sum(b) s from t1 group by a having s <=> 0 order by s;
-------------------------------------------------------
All other tests are successful.
How to repeat:
Configure and compile as described above, and run test.
