summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/r/locks-select-update-1.result
diff options
context:
space:
mode:
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.result22
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;