Bug #34376 merge-big test fails
Submitted: 7 Feb 2008 10:00 Modified: 27 Mar 2008 19:27
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Merge storage engine Severity:S2 (Serious)
Version:5.1.24 OS:Any
Assigned to: Ingo Strüwing CPU Architecture:Any

[7 Feb 2008 10:00] Ingo Strüwing 
Description:
main.merge-big                 [ fail ]

mysqltest: At line 107: query 'SELECT * FROM t4 ORDER BY c1' failed: 1146: Table 'test.t4' doesn't exist

The result from queries just before the failure was:
< snip >

How to repeat:
bk clone bk-internal.mysql.com:/home/bk/mysql-5.1-engines mysql-5.1-axmrg
cd mysql-5.1-axmrg
BUILD/compile-pentium64-debug-max --with-debug=full --prefix="/home2/mydev/install-5.1-axmrg"
cd mysql-test
./mysql-test-run.pl merge-big

Suggested fix:
Eliminate CREATE...SELECT tests as this statement is disabled for MERGE tables since fix for Bug#26379 - Combination of FLUSH TABLE and REPAIR TABLE corrupts a MERGE table (5.1.23).
[7 Feb 2008 11:04] 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:

  http://lists.mysql.com/commits/41859

ChangeSet@1.2518, 2008-02-07 12:04:19+01:00, istruewing@stella.local +2 -0
  Bug#34376 - merge-big test fails
  After changes to the bug fix for bug 26379 (Combination of FLUSH
  TABLE and REPAIR TABLE corrupts a MERGE table) the test case
  merge-big failed.
  Repaired the test case.
  Removed tests for INSERT ... SELECT, which is disabled for MERGE.
  Test case change only.
[15 Feb 2008 19:10] Ingo Strüwing 
Queued to 6.0-engines, 5.1-engines.
[27 Mar 2008 11:18] Bugs System 
Pushed into 5.1.24-rc
[27 Mar 2008 17:50] Bugs System 
Pushed into 6.0.5-alpha
[27 Mar 2008 19:27] Paul DuBois 
Test case change. No changelog entry needed.