MySQL Bugs: #63319: index_merge

Bug #63319	index_merge_myisam fails
Submitted:	18 Nov 2011 19:07	Modified:	2 Dec 2012 17:47
Reporter:	Vladislav Vaintroub	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.5.19	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	regression

Description:
MTR test index_merge_myisam fails.

How to repeat:
bzr branch lp:mysql-server/5.5 mysql-5.5
cd mysql-5.5
mkdir xxx
cd xxx
cmake .. -DCMAKE_BUILD_TYPE=Debug
make
cd mysql-test
perl mysql-test-run.pl --suite=main index_merge_myisam

Output:
<skip long output>
Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.index_merge_myisam

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases

full output of the test

Attachment: mtrout.txt (text/plain), 39.63 KiB.

This test worked in 5.5.17:

macbook-pro:mysql-test openxs$ ./mtr --suite=main index_merge_myisam
Logging: ./mtr  --suite=main index_merge_myisam
111118 21:09:23 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/2VEbR4n9OJ/ is case insensitive
111118 21:09:23 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.5.17
Checking supported features...
 - skipping ndbcluster
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: /Users/openxs/dbs/5.5/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/Users/openxs/dbs/5.5/mysql-test/var'...
Installing system database...
Using server port 64653

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.index_merge_myisam                  [ pass ]  30923
...

So, this looks like recent regression.

Thank you for the bug report. Verified on Windows 7 64-bit.

mysqltest: Result content mismatch

 - saving 'h:/dbs/mysql-5.5/mysql-test/var/log/main.index_merge_myisam/' to 'h:/dbs/mysql-5.5/mysql-test/var/log/main.index_merge_myisam/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 39 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.index_merge_myisam

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases

h:\dbs\mysql-5.5\mysql-test>

no more interested in having it fixed.