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 int primary key, x int not null) engine = tokudb; 5insert into t values (1,0); 6insert into t values (1,0) on duplicate key update x=42; 7insert into t values (1,0) on duplicate key update x=x+1; 8insert into t values (1,0) on duplicate key update x=x-1; 9set session sql_mode="NO_ENGINE_SUBSTITUTION,traditional"; 10insert into t values (1,0) on duplicate key update x=42; 11ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 12insert into t values (1,0) on duplicate key update x=x+1; 13ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 14insert into t values (1,0) on duplicate key update x=x-1; 15ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 16drop table t; 17