summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--mysql-test/r/lock.result2
-rw-r--r--mysql-test/t/lock.test4
2 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/r/lock.result b/mysql-test/r/lock.result
index 24a40321f13..ccd3c02558d 100644
--- a/mysql-test/r/lock.result
+++ b/mysql-test/r/lock.result
@@ -5,6 +5,6 @@ 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
+4
n
1
diff --git a/mysql-test/t/lock.test b/mysql-test/t/lock.test
index 1eed6bb91e9..77354e63252 100644
--- a/mysql-test/t/lock.test
+++ b/mysql-test/t/lock.test
@@ -66,8 +66,10 @@ lock tables t1 write;
connection writer;
send update low_priority t1 set n = 4;
connection reader;
+--sleep 2
send select n from t1;
connection locker;
+--sleep 2
unlock tables;
connection writer;
reap;
@@ -82,8 +84,10 @@ lock tables t1 read;
connection writer;
send update low_priority t1 set n = 4;
connection reader;
+--sleep 2
send select n from t1;
connection locker;
+--sleep 2
unlock tables;
connection writer;
reap;