diff options
| author | unknown <sasha@mysql.sashanet.com> | 2001-07-13 17:45:14 -0600 |
|---|---|---|
| committer | unknown <sasha@mysql.sashanet.com> | 2001-07-13 17:45:14 -0600 |
| commit | 1ce9f19b1f5dd8fe7dfe2946fbe1d0213203a084 (patch) | |
| tree | a053473c0bde78403409eae409203907dbc8edc4 /mysql-test | |
| parent | 959c180b5acbdc16d48a4da62ebb66225a215556 (diff) | |
| download | mariadb-git-1ce9f19b1f5dd8fe7dfe2946fbe1d0213203a084.tar.gz | |
updated lock test
mysql-test/r/lock.result:
updated result
mysql-test/t/lock.test:
updated test
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/lock.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/lock.test | 16 |
2 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/lock.result b/mysql-test/r/lock.result index eb49d03a17b..24a40321f13 100644 --- a/mysql-test/r/lock.result +++ b/mysql-test/r/lock.result @@ -6,3 +6,5 @@ Table Op Msg_type Msg_text test.t2 check error Table 't2' was not locked with LOCK TABLES n 1 +n +1 diff --git a/mysql-test/t/lock.test b/mysql-test/t/lock.test index 677a5a19f6b..1eed6bb91e9 100644 --- a/mysql-test/t/lock.test +++ b/mysql-test/t/lock.test @@ -75,3 +75,19 @@ connection reader; reap; drop table t1; +connection locker; +create table t1(n int); +insert into t1 values (1); +lock tables t1 read; +connection writer; +send update low_priority t1 set n = 4; +connection reader; +send select n from t1; +connection locker; +unlock tables; +connection writer; +reap; +connection reader; +reap; +drop table t1; + |