summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_rename.result
diff options
context:
space:
mode:
authorunknown <mskold@mysql.com>2006-05-05 17:18:47 +0200
committerunknown <mskold@mysql.com>2006-05-05 17:18:47 +0200
commitb1e20006b686180f8b6cbe2234dd6ab2a7c4f9ef (patch)
tree027ce32b2e9090c7ed5589b95c5cea1ce00e429a /mysql-test/r/ndb_rename.result
parent38b1f7c7c3790a6ee59dd213eab16fe9c6fd97f4 (diff)
downloadmariadb-git-b1e20006b686180f8b6cbe2234dd6ab2a7c4f9ef.tar.gz
Bug#16997 Table rename that changes database does not rename indexes, recreate indexes in new database
Diffstat (limited to 'mysql-test/r/ndb_rename.result')
-rw-r--r--mysql-test/r/ndb_rename.result14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_rename.result b/mysql-test/r/ndb_rename.result
new file mode 100644
index 00000000000..cacef136311
--- /dev/null
+++ b/mysql-test/r/ndb_rename.result
@@ -0,0 +1,14 @@
+DROP TABLE IF EXISTS t1,t2;
+drop database if exists mysqltest;
+CREATE TABLE t1 (
+pk1 INT NOT NULL PRIMARY KEY,
+attr1 INT NOT NULL,
+attr2 INT,
+attr3 VARCHAR(10),
+INDEX i1(attr1)
+) ENGINE=ndbcluster;
+alter table t1 rename t2;
+create database ndbtest;
+alter table t2 rename ndbtest.t2;
+drop table ndbtest.t2;
+drop database ndbtest;