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/r/rename.result | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-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.result | 80 |
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 |