summaryrefslogtreecommitdiff
path: root/mysql-test/t/rename.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/rename.test
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/rename.test')
-rw-r--r--mysql-test/t/rename.test97
1 files changed, 0 insertions, 97 deletions
diff --git a/mysql-test/t/rename.test b/mysql-test/t/rename.test
deleted file mode 100644
index a55bc845acc..00000000000
--- a/mysql-test/t/rename.test
+++ /dev/null
@@ -1,97 +0,0 @@
-#
-# Test of rename table
-#
-
---source include/count_sessions.inc
-
---disable_warnings
-drop table if exists t0,t1,t2,t3,t4;
-# Clear up from other tests (to ensure that SHOW TABLES below is right)
-drop table if exists t0,t5,t6,t7,t8,t9,t1_1,t1_2,t9_1,t9_2;
---enable_warnings
-
-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;
-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;
-
-# The following should give errors
---error ER_TABLE_EXISTS_ERROR
-rename table t1 to t2;
---error ER_TABLE_EXISTS_ERROR
-rename table t1 to t1;
---error ER_TABLE_EXISTS_ERROR
-rename table t3 to t4, t2 to t3, t1 to t2, t4 to t2;
-show tables like "t_";
---error ER_TABLE_EXISTS_ERROR
-rename table t3 to t1, t2 to t3, t1 to t2, t4 to t1;
---error ER_NO_SUCH_TABLE
-rename table t3 to t4, t5 to t3, t1 to t2, t4 to t1;
-
-select * from t1;
-select * from t2;
-select * from t3;
-
-# This should give a warning for t4
-drop table if exists t1,t2,t3,t4;
-
-#
-# Bug #2397 RENAME TABLES is not blocked by
-# FLUSH TABLES WITH READ LOCK
-#
-
-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;
-send RENAME TABLE t1 TO t2, t3 to t4;
-connection con2;
-show tables;
-UNLOCK TABLES;
-connection con1;
-reap;
-connection con2;
-
-# Wait for the the tables to be renamed
-# i.e the query below succeds
-let $query= select * from t2, t4;
-source include/wait_for_query_to_succeed.inc;
-
-show tables;
-
-drop table t2, t4;
-
-disconnect con2;
-disconnect con1;
-connection default;
-
-
---echo End of 4.1 tests
-
-
---echo #
---echo # Bug#14959: "ALTER TABLE isn't able to rename a view"
---echo # Bug#53976: "ALTER TABLE RENAME is allowed on views
---echo # (not documented, broken)"
---echo #
-create table t1(f1 int);
-create view v1 as select * from t1;
---error ER_WRONG_OBJECT
-alter table v1 rename to v2;
-drop view v1;
-drop table t1;
-
---echo End of 5.0 tests
-
---source include/wait_until_count_sessions.inc
-