diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2004-04-03 01:39:45 +0500 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2004-04-03 01:39:45 +0500 |
| commit | 7a56a9a073477c8651b00f7597ba76ea4636c8cc (patch) | |
| tree | 6e2f37fa35bcae6e8d4a4edcb37a368ed3f31568 /mysql-test/t | |
| parent | 69942b1367f3199efa3286cc6cb794e3dce448f1 (diff) | |
| parent | 9be599fc3da6e6d9b7bf1aa4836af93ca30bbf5d (diff) | |
| download | mariadb-git-7a56a9a073477c8651b00f7597ba76ea4636c8cc.tar.gz | |
Merge eagle.mysql.r18.ru:/home/vva/work/mysql.orig/clear/mysql-4.1
into eagle.mysql.r18.ru:/home/vva/work/BUG_2397/mysql-4.1
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/rename.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/rename.test b/mysql-test/t/rename.test index 48a9cb401d9..bea0641ad23 100644 --- a/mysql-test/t/rename.test +++ b/mysql-test/t/rename.test @@ -35,3 +35,27 @@ select * from t3; # This should give a warning for t4 drop table if exists t1,t2,t3,t4; + +# +# Test-case for 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; +sleep 1; +show tables; +UNLOCK TABLES; +sleep 1; +show tables; + +drop table t2, t4; |