diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2003-08-28 18:09:00 +0500 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2003-08-28 18:09:00 +0500 |
| commit | 241ed6b81caf0248200aacbd7e945a24ce835baa (patch) | |
| tree | d0c13f66f3fb6662f823e9eff89889816d5b1925 /mysql-test/t/innodb.test | |
| parent | 5f8cc0998f6366c46cc20e42e4989f8f3f468f03 (diff) | |
| download | mariadb-git-241ed6b81caf0248200aacbd7e945a24ce835baa.tar.gz | |
Fix for bug #799 FLUSH TABLES WITH READ LOCK does not block CREATE TABLE
This commit is related to my previos one(ChangeSet 1.1583 03/08/27 18:03:39).
Note about COMMIT&ROLLBACK:
Only 'COMMIT' statement updates the binary log.
'ROLLBACK' statement doesn't update the binlog.
mysql-test/r/drop.result:
Fix for bug #799 FLUSH TABLES WITH READ LOCK does not block CREATE TABLE
mysql-test/r/innodb.result:
Fix for bug #799 FLUSH TABLES WITH READ LOCK does not block CREATE TABLE
mysql-test/t/drop.test:
Fix for bug #799 FLUSH TABLES WITH READ LOCK does not block CREATE TABLE
mysql-test/t/innodb.test:
Fix for bug #799 FLUSH TABLES WITH READ LOCK does not block CREATE TABLE
sql/handler.cc:
Fix for bug #799 FLUSH TABLES WITH READ LOCK does not block CREATE TABLE
sql/sql_table.cc:
Fix for bug #799 FLUSH TABLES WITH READ LOCK does not block CREATE TABLE
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index 6e7eb0ea06f..870fc8cc2b0 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -134,6 +134,21 @@ rollback; drop table t1; # +# Test for commit and FLUSH TABLES WITH READ LOCK +# + +create table t1 (n int not null primary key) type=innodb; +start transaction; +insert into t1 values (4); +flush tables with read lock; +--error 1223; +commit; +unlock tables; +commit; +select * from t1; +drop table t1; + +# # Testing transactions # |