Bug #12328 Test case 'rpl_flush_tables' fails to rename database file
Submitted: 2 Aug 2005 23:49 Modified: 4 Aug 2005 23:47
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.1.10b OS:Windows (Windows XP (Professional))
Assigned to: Jim Winstead CPU Architecture:Any

[2 Aug 2005 23:49] Kent Boortz 
Description:
Test case failure

rpl_flush_tables                [ fail ]
At line 15: query 'rename table t1 to t5, t2 to t1' failed: 7:
Error on rename of '.\test\t1.MYI' to '.\test\t5.MYI' (Errcode: 13)

How to repeat:
Run 4.1.10b on Windows, and run the test case 'rpl_flush_tables'
[3 Aug 2005 20:07] Jim Winstead 
the problem is that the merge table in the test (t3) has the underlying table (t1) open, so windows refuses to rename the files for it. that problem can be avoided by adding a 'flush tables' before the rename, of course, but i believe that would thwart what the test is trying to verify.
[3 Aug 2005 22:47] Jim Winstead 
This test will be disabled on Windows, per discussion with Brian. It relies on a behavior not supported on that platform.
[4 Aug 2005 0:43] Jim Winstead 
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:                                         
                                                                                
  http://lists.mysql.com/internals/27873
[4 Aug 2005 23:47] Jim Winstead 
Fixed in 4.1.14 and 5.0.12.