summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/r/locking-read-repeatable-read-1.result
blob: 433b5baf18b2e9b80bf586000b827b76aee798c8 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
create table t (a int primary key, b int) ENGINE=TokuDB;
insert into t values (1,0);
set session transaction isolation level repeatable read;
begin;
select * from t where a=1 lock in share mode;
a	b
1	0
connect conn1,localhost,root;
set session transaction isolation level repeatable read;
begin;
update t set b=b+1 where a=1;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
connection default;
commit;
disconnect conn1;
drop table t;