Create 'main' test directory and move 't' and 'r' there

1 files changed, 80 insertions, 0 deletions

diff --git a/mysql-test/main/rename.result b/mysql-test/main/rename.result
new file mode 100644
index 00000000000..ff8566abe02
--- /dev/null
+++ b/mysql-test/main/rename.result
@@ -0,0 +1,80 @@
+drop table if exists t0,t1,t2,t3,t4;
+drop table if exists t0,t5,t6,t7,t8,t9,t1_1,t1_2,t9_1,t9_2;
+create table t0 SELECT 1,"table 1";
+create table t2 SELECT 2,"table 2";
+create table t3 SELECT 3,"table 3";
+rename table t0 to t1;
+rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
+select * from t1;
+3	table 3
+3	table 3
+rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
+rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
+select * from t1;
+1	table 1
+1	table 1
+rename table t1 to t2;
+ERROR 42S01: Table 't2' already exists
+rename table t1 to t1;
+ERROR 42S01: Table 't1' already exists
+rename table t3 to t4, t2 to t3, t1 to t2, t4 to t2;
+ERROR 42S01: Table 't2' already exists
+show tables like "t_";
+Tables_in_test (t_)
+t1
+t2
+t3
+rename table t3 to t1, t2 to t3, t1 to t2, t4 to t1;
+ERROR 42S01: Table 't1' already exists
+rename table t3 to t4, t5 to t3, t1 to t2, t4 to t1;
+ERROR 42S02: Table 'test.t5' doesn't exist
+select * from t1;
+1	table 1
+1	table 1
+select * from t2;
+2	table 2
+2	table 2
+select * from t3;
+3	table 3
+3	table 3
+drop table if exists t1,t2,t3,t4;
+Warnings:
+Note	1051	Unknown table 'test.t4'
+connect  con1,localhost,root,,;
+connect  con2,localhost,root,,;
+connection con1;
+CREATE TABLE t1 (a int);
+CREATE TABLE t3 (a int);
+connection con2;
+FLUSH TABLES WITH READ LOCK;
+connection con1;
+RENAME TABLE t1 TO t2, t3 to t4;
+connection con2;
+show tables;
+Tables_in_test
+t1
+t3
+UNLOCK TABLES;
+connection con1;
+connection con2;
+show tables;
+Tables_in_test
+t2
+t4
+drop table t2, t4;
+disconnect con2;
+disconnect con1;
+connection default;
+End of 4.1 tests
+#
+# Bug#14959: "ALTER TABLE isn't able to rename a view"
+# Bug#53976: "ALTER TABLE RENAME is allowed on views
+#             (not documented, broken)"
+#
+create table t1(f1 int);
+create view v1 as select * from t1;
+alter table v1 rename to v2;
+ERROR HY000: 'test.v1' is not of type 'BASE TABLE'
+drop view v1;
+drop table t1;
+End of 5.0 tests