summaryrefslogtreecommitdiff
path: root/mysql-test/r/rename.result
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/r/rename.result
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/r/rename.result')
-rw-r--r--mysql-test/r/rename.result80
1 files changed, 0 insertions, 80 deletions
diff --git a/mysql-test/r/rename.result b/mysql-test/r/rename.result
deleted file mode 100644
index ff8566abe02..00000000000
--- a/mysql-test/r/rename.result
+++ /dev/null
@@ -1,80 +0,0 @@
-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