diff options
| author | unknown <mskold@mysql.com> | 2004-12-06 14:51:10 +0100 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2004-12-06 14:51:10 +0100 |
| commit | c6b3c442a5ba34c027a7fa405620e9a1684ed50d (patch) | |
| tree | f201e8bf2eaec493e1061ae5458aa6629dfb0c9a /mysql-test/t/ndb_alter_table.test | |
| parent | 04866cf0f1c9341dff58e45c5063508f83e8aeb8 (diff) | |
| download | mariadb-git-c6b3c442a5ba34c027a7fa405620e9a1684ed50d.tar.gz | |
Fix for bug#6935 table rename does not work with ndb tables
Diffstat (limited to 'mysql-test/t/ndb_alter_table.test')
| -rw-r--r-- | mysql-test/t/ndb_alter_table.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test index 22b1a0e476d..892443a1407 100644 --- a/mysql-test/t/ndb_alter_table.test +++ b/mysql-test/t/ndb_alter_table.test @@ -2,6 +2,7 @@ --disable_warnings DROP TABLE IF EXISTS t1; +drop database if exists mysqltest; --enable_warnings # @@ -21,6 +22,22 @@ SELECT * FROM t1; DROP TABLE t1; # +# Verfify changing table names between databases +# +CREATE DATABASE mysqltest; +USE mysqltest; +CREATE TABLE t1 ( + a INT NOT NULL, + b INT NOT NULL +) ENGINE=ndbcluster; +RENAME TABLE t1 TO test.t1; +SHOW TABLES; +DROP DATABASE mysqltest; +USE test; +SHOW TABLES; +DROP TABLE t1; + +# # More advanced test # create table t1 ( |