Bug #59276 Test "partition_exch_qa_14" fails, because "EXCHANGE PARTITION" succeeds
Submitted: 4 Jan 2011 12:08 Modified: 10 Jan 2013 12:04
Reporter: Joerg Bruehe Email Updates:
Status: Can't repeat Impact on me:
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.6.1-m5,mysql-trunk OS:Windows
Assigned to: Assigned Account CPU Architecture:Any
Tags: partition, pb2, windows

[4 Jan 2011 12:08] Joerg Bruehe
Test failure in the release build of 5.6.1-m5, on Windows only:

parts.partition_exch_qa_14               [ fail ]
        Test ended at 2010-12-29 22:34:29

CURRENT_TEST: parts.partition_exch_qa_14
mysqltest: At line 33: query 'ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10' succeeded - should have failed with errno 1710...

The result from queries just before the failure was:
use test;

 - saving '/PATH/mysql-test/var/log/parts.partition_exch_qa_14/' to '/PATH/mysql-test/var/log/parts.partition_exch_qa_14/'

When the test is then retried, it fails different:
CURRENT_TEST: parts.partition_exch_qa_14
mysqltest: At line 13: command "mkdir" failed with error 1. my_errno=17
I suspect this is because the directory already exists, as the "--rmdir" of the first run may have failed because the succeeding command left a file.

All this is identical for 32 and 64 bit, and it already happened at the first build (no source change to the second build).

How to repeat:
Run the test suite ...

Suggested fix:
Check the test on Windows, I suspect some Windows-specific difference may make the "EXCHANGE PARTITION" pass.

Also, check whether the test file is correct and minimal:
The same sequence of commands occurs 3 times with a very minor difference in setting variables, to me this looks like a merge error.
If this is really intentional, it definitely is worth an explanatory comment
(in fact, the whole test should get a description of the intended check).
[7 Jan 2011 4:07] Anitha Gopi
Failing everyday in daily-trunk run
[7 Jan 2011 9:55] Mattias Jonsson
I think this is because data/index directory is no supported on windows, since it is not supported, there are no differences between the tables.
[7 Jan 2011 18:32] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:


3447 Horst.Hunger	2011-01-07
      bug#59276: Test must not run on Windows platforms, as directory options in partitions are ignored there.
[24 Jan 2011 11:55] Horst Hunger
Pushed to mysql-5.6.1-m5-release. Merged to mysql-trunk and pushed.
[27 Jan 2011 3:51] Anitha Gopi
The test is now skipped on windows. http://pb2.norway.sun.com/?action=archive_download&archive_id=2884508&pretty=please