Bug #29690 Falcon_temporary_alter fails if coupled with Falcon_bug_27767
Submitted: 10 Jul 2007 13:08 Modified: 20 Jul 2007 12:13
Reporter: Giuseppe Maxia Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S2 (Serious)
Version:6.0.1 OS:Other (Mac OS X, Linux)
Assigned to: Hakan Küçükyılmaz CPU Architecture:Any
Tags: falcon, testing

[10 Jul 2007 13:08] Giuseppe Maxia 
Description:
When running the test suite on Linux, or Mac OS X, Intel based,
test falcon_temporary_alter fails if run after test falcon_bug_27767.

Running the test alone succeeds.

ChangeSet@1.2616, 2007-07-09 17:32:09-04:00

How to repeat:
./mtr --skip-im --skip-ndb falcon_bug_27767 falcon_temporary_alter

Suggested fix:
N/A
[10 Jul 2007 13:13] Hakan Küçükyılmaz 
Verified on Linux 64-bit. falcon_temporary_alter also fails on Pushbuild.

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon_bug_27767               [ pass ]             69
falcon_temporary_alter         [ fail ]

Errors are (from /home/hakan/work/mysql/mysql-5.1-falcon/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 8: query 'CREATE table t1 as select * from t1_temp' failed: 1050: Table 't1' already exists
(the last lines may be the most important ones)
Result from queries before failure can be found in /home/hakan/work/mysql/mysql-5.1-falcon/mysql-test/var/log/falcon_temporary_alter.log
[10 Jul 2007 13:14] Hakan Küçükyılmaz 
Regression.
[10 Jul 2007 22:16] 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/30639

ChangeSet@1.2619, 2007-07-11 00:16:13+02:00, hakank@lu0011.wdf.sap.corp +4 -0
  Fix for Bug#29690.
[20 Jul 2007 12:13] MC Brown 
Changes affect internal test case, no documentation required.