summaryrefslogtreecommitdiff
path: root/mysql-test/r/rename.result
diff options
context:
space:
mode:
authorsasha@mysql.sashanet.com <>2001-09-27 23:05:54 -0600
committersasha@mysql.sashanet.com <>2001-09-27 23:05:54 -0600
commitbb66c80aeba0e7ffeb4781d8570644b10479f9a6 (patch)
tree57e877bfc39c6dc5d9340ff9c84c6652d67724b0 /mysql-test/r/rename.result
parent043deed839271cf10bd3af31d2e109694952be0c (diff)
downloadmariadb-git-bb66c80aeba0e7ffeb4781d8570644b10479f9a6.tar.gz
client/mysqlmanagerc.c
added support for quiet increased line buffer size client/mysqltest.c fixed memory leak added query logging to result file added error message logging to result file added enable_query_log/disable_query_log mysql-test/mysql-test-run.sh converted tests to use mysqlmanager Updated test results
Diffstat (limited to 'mysql-test/r/rename.result')
-rw-r--r--mysql-test/r/rename.result25
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/rename.result b/mysql-test/r/rename.result
index 57ef20e41b1..6128e630978 100644
--- a/mysql-test/r/rename.result
+++ b/mysql-test/r/rename.result
@@ -1,14 +1,39 @@
+drop table if exists t0,t1,t2,t3,t4;
+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;
+Table './test/t2.frm' already exists
+rename table t1 to t1;
+Table './test/t1.frm' already exists
+rename table t3 to t4, t2 to t3, t1 to t2, t4 to t2;
+Table './test/t2.frm' 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;
+Table './test/t1.frm' already exists
+rename table t3 to t4, t5 to t3, t1 to t2, t4 to t1;
+Can't find file: './test/t5.frm' (errno: 2)
+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;