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: | |
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
[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".