EVOLUTION-MANAGER

Edit File: locks-select-update-3.result

create table t (a int primary key, b int) engine=tokudb; insert into t values (1,0); set session transaction isolation level read committed; begin; select * from t where a=1 for update; a b 1 0 update t set b=b+1 where a=1; connect conn1,localhost,root; set session tokudb_lock_timeout=60000; set session transaction isolation level read committed; begin; select * from t where a=1 for update; connection default; commit; connection conn1; a b 1 1 update t set b=b+1 where a=1; select * from t; a b 1 2 commit; connection default; disconnect conn1; drop table t;