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