diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/rename.test | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-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.test | 97 |
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 - |