summaryrefslogtreecommitdiff
path: root/mysql-test/t/drop.test
diff options
context:
space:
mode:
authorunknown <gluh@gluh.mysql.r18.ru>2003-08-27 18:03:39 +0500
committerunknown <gluh@gluh.mysql.r18.ru>2003-08-27 18:03:39 +0500
commit5f8cc0998f6366c46cc20e42e4989f8f3f468f03 (patch)
treef67788457623bbbf382374756ab4f3f6833bc25e /mysql-test/t/drop.test
parent91dc31d38334cddc0b47c9ac0c0be338fc8cfd20 (diff)
downloadmariadb-git-5f8cc0998f6366c46cc20e42e4989f8f3f468f03.tar.gz
Fix for bug #799 FLUSH TABLES WITH READ LOCK does not block CREATE TABLE
Diffstat (limited to 'mysql-test/t/drop.test')
-rw-r--r--mysql-test/t/drop.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/drop.test b/mysql-test/t/drop.test
index a55cbb45fd9..78311a9dd52 100644
--- a/mysql-test/t/drop.test
+++ b/mysql-test/t/drop.test
@@ -43,3 +43,13 @@ drop database mysqltest;
show databases;
--error 1008
drop database mysqltest;
+
+# test create table and FLUSH TABLES WITH READ LOCK
+drop table t1;
+flush tables with read lock;
+--error 1099;
+create table t1(n int);
+unlock tables;
+create table t1(n int);
+show tables;
+drop table t1;