diff options
Diffstat (limited to 'mysql-test/r/rename.result')
| -rw-r--r-- | mysql-test/r/rename.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/rename.result b/mysql-test/r/rename.result index 74370ba74dd..2b8c925b309 100644 --- a/mysql-test/r/rename.result +++ b/mysql-test/r/rename.result @@ -40,20 +40,31 @@ select * from t3; 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" |