Bug #11493 Alter table rename to default database does not work without db name qualifying

Description:
Renaming or moving table using ALTER TABLE ... RENAME from 1 database to the default database does not work without qualifying the database name in the target table name.

How to repeat:
CREATE DATABASE db1;
CREATE DATABASE db2;
USE db1
CREATE TABLE  t (i int);
ALTER TABLE t RENAME db2.t;

Table t moved to database db2.

ALTER TABLE db2.t RENAME t;

This does not move table t back to database db1, which is the default database. Need to use

ALTER TABLE db2.t RENAME db1.t;

to successfully moved table t to database db1.

Rename table works fine without the database qualifier.
RENAME TABLE db2.t TO t;
is able to move the table t from db2 to the default database.

Tested on Win 2000 Sp4, MySQL server 5.0.8 beta

Verified on Linux too.

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/28066

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/28980

Pushed to 4.1.15 and 5.0.12.

Noted in 4.1.15, 5.0.12 changelogs.