MySQL Bugs: #22155: Double rename failure

Bug #22155	Double rename failure
Submitted:	9 Sep 2006 7:48	Modified:	6 Sep 2007 12:22
Reporter:	Georg Richter
Status:	Closed
Category:	Server: Falcon	Severity:	S3 (Non-critical)
Version:	5.2	OS:	Linux (Linux)
Assigned to:		Target Version:

Description:
If I rename a Falcon table, then rename it again, I get an error message.
If I rename a MyISAM table, then rename it again, I get no error message.

How to repeat:
mysql> create database jstar18;
Query OK, 1 row affected (0.00 sec)

mysql> create database jstar19;
Query OK, 1 row affected (0.00 sec)

mysql> use jstar18;
Database changed
mysql> create table t1 (s1 int) engine = myisam;
Query OK, 0 rows affected (0.00 sec)

mysql> rename table t1 to jstar19.t1;
Query OK, 0 rows affected (0.00 sec)

mysql> rename table jstar19.t1 to t1;
Query OK, 0 rows affected (0.00 sec)

mysql> create table t2 (s1 int) engine = jstar;
Query OK, 0 rows affected (0.11 sec)

mysql> rename table t2 to jstar19.t2;
Query OK, 0 rows affected (0.00 sec)

mysql> rename table jstar19.t2 to t2;
ERROR 1025 (HY000): Error on rename of './jstar19/t2' to './jstar18/t2' (errno: 157)

See test case falcon_bug_161.test for reproduction.

Renaming tables across databases doesn't work.  The initial rename
didn't produce an error, but it didn't produce a table either.  The
second rename failed because there was no table to rename.

Test case renamed to falcon_bug_22155.test to reflect correct bug number.

This seems to be fixed.  George, can you verify?

I don't think Georg needs to re-check; the original reporter was me.
(Georg copied the bugs that I reported from mantis to bugs.mysql.com.)

I have re-tested with a few variations, I confirm that the
bug has disappeared.

Fixed in 6.0.2-alpha

A note has been added to the 6.0.2 changelog: 

Renaming tables to or from Falcon tablespaces would raise an error