diff options
Diffstat (limited to 'mysql-test/r/lock_multi.result')
| -rw-r--r-- | mysql-test/r/lock_multi.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/lock_multi.result b/mysql-test/r/lock_multi.result index d75d9aa0216..6fe8cc71185 100644 --- a/mysql-test/r/lock_multi.result +++ b/mysql-test/r/lock_multi.result @@ -1,4 +1,18 @@ +create table t1(n int); +insert into t1 values (1); +lock tables t1 write; + update low_priority t1 set n = 4; + select n from t1; +unlock tables; n 4 +drop table t1; +create table t1(n int); +insert into t1 values (1); +lock tables t1 read; + update low_priority t1 set n = 4; + select n from t1; +unlock tables; n 1 +drop table t1; |