1set tokudb_enable_fast_upsert=1; 2set session sql_mode=(select replace(@@sql_mode,'STRICT_TRANS_TABLES','')); 3set session sql_mode=(select replace(@@sql_mode,'STRICT_ALL_TABLES','')); 4create table t (id bigint primary key, b bigint not null default 0) 5engine = tokudb; 6SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES','')); 7SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_ALL_TABLES','')); 8set tokudb_enable_fast_upsert=1; 9begin; 10insert into t (id) values (1) on duplicate key update b=b+1; 11begin; 12insert into t (id) values (2) on duplicate key update b=b-1; 13insert into t (id) values (2) on duplicate key update b=b+1; 14insert into t (id) values (1) on duplicate key update b=b-1; 15Got one of the listed errors 16rollback; 17commit; 18select * from t; 19id b 201 0 212 0 22drop table t; 23