EVOLUTION-MANAGER

Edit File: fast_update_deadlock.result

set tokudb_enable_fast_update=1; set session sql_mode=(select replace(@@sql_mode,'STRICT_TRANS_TABLES','')); set session sql_mode=(select replace(@@sql_mode,'STRICT_ALL_TABLES','')); create table t (id bigint primary key, b bigint not null default 0) engine = tokudb; insert into t (id) values (1),(2); set tokudb_enable_fast_update=1; set session sql_mode=(select replace(@@sql_mode,'STRICT_TRANS_TABLES','')); set session sql_mode=(select replace(@@sql_mode,'STRICT_ALL_TABLES','')); begin; update t set b=b+1 where id=1; begin; update t set b=b-1 where id=2; update t set b=b+1 where id=2; update t set b=b-1 where id=1; Got one of the listed errors rollback; commit; select * from t; id b 1 1 2 1 drop table t;