diff options
Diffstat (limited to 'mysql-test/r/tablelock.result')
| -rw-r--r-- | mysql-test/r/tablelock.result | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/r/tablelock.result b/mysql-test/r/tablelock.result index 4fbeac979b1..2ffd8f928a9 100644 --- a/mysql-test/r/tablelock.result +++ b/mysql-test/r/tablelock.result @@ -1,12 +1,48 @@ +drop table if exists t1,t2; +create table t1 ( n int auto_increment primary key); +lock tables t1 write; +insert into t1 values(NULL); +unlock tables; +check table t1; Table Op Msg_type Msg_text test.t1 check status OK +lock tables t1 write, t1 as t0 read; +insert into t1 values(NULL); +unlock tables; +check table t1; Table Op Msg_type Msg_text test.t1 check status OK +lock tables t1 write, t1 as t0 read, t1 as t2 read; +insert into t1 values(NULL); +unlock tables; +check table t1; Table Op Msg_type Msg_text test.t1 check status OK +lock tables t1 write, t1 as t0 write, t1 as t2 read; +insert into t1 values(NULL); +unlock tables; +check table t1; Table Op Msg_type Msg_text test.t1 check status OK +lock tables t1 write, t1 as t0 write, t1 as t2 read, t1 as t3 read; +insert into t1 values(NULL); +unlock tables; +check table t1; Table Op Msg_type Msg_text test.t1 check status OK +lock tables t1 write, t1 as t0 write, t1 as t2 write; +insert into t1 values(NULL); +unlock tables; +check table t1; Table Op Msg_type Msg_text test.t1 check status OK +drop table t1; +CREATE TABLE t1 (a int); +CREATE TABLE t2 (a int); +lock tables t1 write,t1 as b write, t2 write, t2 as c read; +drop table t1,t2; +CREATE TABLE t1 (a int); +CREATE TABLE t2 (a int); +lock tables t1 write,t1 as b write, t2 write, t2 as c read; +drop table t2,t1; +unlock tables; |