diff options
| author | unknown <serg@serg.mylan> | 2005-04-12 17:15:54 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2005-04-12 17:15:54 +0200 |
| commit | 859b3e16ac0af20950bb2e0ac4d1fc7c6fb96fe0 (patch) | |
| tree | 73e0b22a9dedccda629cfc39b6956be783637c88 /mysql-test/t/flush_block_commit.test | |
| parent | 0ec06cabbd41ac5a5c13a7cb26074dc938e1b735 (diff) | |
| download | mariadb-git-859b3e16ac0af20950bb2e0ac4d1fc7c6fb96fe0.tar.gz | |
FLUSH TABLES WITH READ LOCK should block writes to binlog too
mysql-test/r/flush_block_commit.result:
FLUSH TABLES WITH READ LOCK should block writes to binlog too
it does not yet
mysql-test/t/flush_block_commit.test:
FLUSH TABLES WITH READ LOCK should block writes to binlog too
it does not yet
Diffstat (limited to 'mysql-test/t/flush_block_commit.test')
| -rw-r--r-- | mysql-test/t/flush_block_commit.test | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/flush_block_commit.test b/mysql-test/t/flush_block_commit.test index 49d68d05fb6..29ef7b8a0b9 100644 --- a/mysql-test/t/flush_block_commit.test +++ b/mysql-test/t/flush_block_commit.test @@ -76,3 +76,24 @@ select * from t1; show create database test; drop table t1; + +# FLUSH TABLES WITH READ LOCK should block writes to binlog too +connection con1; +create table t1 (a int) engine=innodb; +reset master; +set autocommit=0; +insert t1 values (1); +connection con2; +flush tables with read lock; +show master status; +connection con1; +send commit; +connection con2; +sleep 1; +show master status; +unlock tables; +connection con1; +reap; +drop table t1; +set autocommit=1; + |