diff options
Diffstat (limited to 'mysql-test/t/drop.test')
| -rw-r--r-- | mysql-test/t/drop.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/drop.test b/mysql-test/t/drop.test index 54fd8ae2167..8d9a5be7cbf 100644 --- a/mysql-test/t/drop.test +++ b/mysql-test/t/drop.test @@ -24,3 +24,18 @@ select * from foo.foo; drop database if exists foo; create database foo; drop database foo; + +# test drop/create database and FLUSH TABLES WITH READ LOCK +drop database if exists foo; +flush tables with read lock; +--error 1209 +create database foo; +unlock tables; +create database foo; +show databases; +flush tables with read lock; +--error 1208 +drop database foo; +unlock tables; +drop database foo; +show databases; |