Bug #8243 alter table db1.foo rename db2.foo loses table
Submitted: 1 Feb 2005 17:52 Modified: 9 Mar 2005 12:10
Reporter: John David Duncan Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:4.1.9 OS:
Assigned to: Assigned Account CPU Architecture:Any

[1 Feb 2005 17:52] John David Duncan
Description:
If you use ALTER TABLE ... RENAME to move an NDB table from one database to another, the table becomes unusable.

How to repeat:
create database bug;
use test ;
create table t ( i int ) type = ndb;
insert into t values (3 ) ;
alter table t rename bug.t;
use bug;
show tables;
desc t;
select * from t ;
[4 Feb 2005 15:46] Tomas Ulin
Made a test case in latest 4.1.10 tree, seems to work
+ DROP TABLE IF EXISTS t1;
+ drop database if exists bug;
+ use test ;
+ create table t1 ( i int ) type = ndb;
+ Warnings:
+ Warning       1287    'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
+ insert into t1 values (3 ) ;
+ create database bug;
+ alter table t1 rename bug.t1;
+ use bug;
+ show tables;
+ Tables_in_bug
+ t1
+ desc t1;
+ Field Type    Null    Key     Default Extra
+ i     int(11) YES             NULL
+ select * from t1 ;
+ i
+ 3
+ use test;
+ show tables;
+ Tables_in_test
+ drop database if exists bug;
[7 Feb 2005 8:10] Tomas Ulin
Can't repeat this in 4.1.9 either:

- downloaded and untar'd 4.1.9-max release on build
- ran below as testcase directly in mysql-test-run
- result looks ok

+ create database mysqltest;
+ use test ;
+ create table t1 ( i int ) engine = ndb;
+ insert into t1 values (3 ) ;
+ alter table t1 rename mysqltest.t1;
+ use mysqltest;
+ show tables;
+ Tables_in_mysqltest
+ t1
+ use test;
+ show tables;
+ Tables_in_test
+ drop database mysqltest;
[8 Feb 2005 15:27] John David Duncan
This test case isn't adequate -- it's not the "show tables" statement that failed in my case, but the "select * from t" which is included in the bug report but not in the test case. 

- JD
[10 Mar 2005 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".