diff options
| author | unknown <sasha@mysql.sashanet.com> | 2001-07-13 17:25:37 -0600 |
|---|---|---|
| committer | unknown <sasha@mysql.sashanet.com> | 2001-07-13 17:25:37 -0600 |
| commit | 959c180b5acbdc16d48a4da62ebb66225a215556 (patch) | |
| tree | c2e43b7377bb97377b1228cf76368d22c8b2da69 /mysql-test | |
| parent | 13448d108957e59875cb35bddb6e7816b13316c9 (diff) | |
| download | mariadb-git-959c180b5acbdc16d48a4da62ebb66225a215556.tar.gz | |
test case for low priority updates race bug
not yet fixed
mysql-test/r/lock.result:
updated result
mysql-test/t/lock.test:
test case for low prior updates bug
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/lock.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/lock.test | 22 |
2 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/lock.result b/mysql-test/r/lock.result index 7b1be604024..eb49d03a17b 100644 --- a/mysql-test/r/lock.result +++ b/mysql-test/r/lock.result @@ -4,3 +4,5 @@ Table Op Msg_type Msg_text test.t1 check status OK Table Op Msg_type Msg_text test.t2 check error Table 't2' was not locked with LOCK TABLES +n +1 diff --git a/mysql-test/t/lock.test b/mysql-test/t/lock.test index 385713174d2..677a5a19f6b 100644 --- a/mysql-test/t/lock.test +++ b/mysql-test/t/lock.test @@ -53,3 +53,25 @@ lock tables t1 write; check table t2; unlock tables; drop table t1,t2; + +#test to see if select will get the lock ahead of low priority update +connect (locker,localhost,root,,); +connect (reader,localhost,root,,); +connect (writer,localhost,root,,); + +connection locker; +create table t1(n int); +insert into t1 values (1); +lock tables t1 write; +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; + |