Bug #14072 mysql test suite
Submitted: 17 Oct 2005 13:01 Modified: 18 Oct 2005 12:29
Reporter: ming lu Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.12 OS:Linux (red hat 9)
Assigned to: CPU Architecture:Any

[17 Oct 2005 13:01] ming lu
Description:
    I run a test against to the MySQL server with the mysql test suite (/mysql-test/mysql-test-run.sh) in the red hat9 system. Four cases failed during the test, they are alter_table.test, delayed.test, query_cache.test and the subselect.test. The result is not match with the mysql manual 's description, it said that all the test cases must be passed. So  i think it should be  a problem about the test suite.
     I will provide the output log file after the bug is opened.

How to repeat:
     Compile and install the mysql-5.0.12-beta-linux source distribution in the redhat9 system. Then run the test suite as following command :
     ./mysql-test-run.sh --force
[17 Oct 2005 13:03] ming lu
the output log file of my test

Attachment: test1.log (text/plain), 20.02 KiB.

[17 Oct 2005 13:31] Valeriy Kravchuk
Thank you for a problem report. Please, describe the hardware used and how you compiled the sources (configure command used).

Have you tried to repeat this problem on newer 5.0.13 version?
[18 Oct 2005 6:05] ming lu
1. The computer i used is a compatible pc. Main configuration is followed:
  CPU:  Intel(R) Celeron 2.66Ghz
  Memory : 512MB

2. compile method:

./configure --prefix=/private/mysql-project/mysql-bin
make
make install
/private/mysql-project/mysql-bin/bin/mysql_install_db --basedir=/private/mysql-project/mysql-bin --datadir=/private/mysql-project/mysql-bin/var
/private/mysql-project/mysql-bin/bin/mysqld_safe &

3. I only did the test against to the 5.0.12 version.
[18 Oct 2005 6:06] ming lu
1. The computer i used is a compatible pc. Main configuration is followed:
  CPU:  Intel(R) Celeron 2.66Ghz
  Memory : 512MB

2. compile method:

./configure --prefix=/private/mysql-project/mysql-bin
make
make install
/private/mysql-project/mysql-bin/bin/mysql_install_db --basedir=/private/mysql-project/mysql-bin --datadir=/private/mysql-project/mysql-bin/var
/private/mysql-project/mysql-bin/bin/mysqld_safe &

3. I only did the test against to the 5.0.12 version.
[18 Oct 2005 12:29] Valeriy Kravchuk
Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Additional info:

Please, try to run tests with 5.0.13-rc at least. 

I've just run ./mysql-test-run --force for the latest 5.0.16-BK on Fedora Core 1, built from sources with configure command just like yours, and all 334 tests were successful.