diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/locks-select-update-1.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/locks-select-update-1.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/locks-select-update-1.result b/storage/tokudb/mysql-test/tokudb/r/locks-select-update-1.result new file mode 100644 index 00000000000..a816808a2d5 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/r/locks-select-update-1.result @@ -0,0 +1,22 @@ +SET DEFAULT_STORAGE_ENGINE='tokudb'; +drop table if exists t; +create table t (a int primary key, b int); +insert into t values (1,0); +set session transaction isolation level repeatable read; +begin; +select * from t where a=1 for update; +a b +1 0 +update t set b=b+1 where a=1; +set session transaction isolation level repeatable read; +begin; +select * from t where a=1 for update; +commit; +a b +1 1 +update t set b=b+1 where a=1; +select * from t; +a b +1 2 +commit; +drop table t; |