1source include/have_tokudb.inc; 2 3set tokudb_enable_fast_upsert=1; 4source ../include/setup_fast_update_upsert.inc; 5 6let $default_sql_mode = `select @@session.sql_mode`; 7 8create table t (id int primary key, x int not null) engine = tokudb; 9insert into t values (1,0); 10insert into t values (1,0) on duplicate key update x=42; 11insert into t values (1,0) on duplicate key update x=x+1; 12insert into t values (1,0) on duplicate key update x=x-1; 13 14eval set session sql_mode="$default_sql_mode,traditional"; 15 16replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; 17error ER_UNSUPPORTED_EXTENSION; 18insert into t values (1,0) on duplicate key update x=42; 19 20replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; 21error ER_UNSUPPORTED_EXTENSION; 22insert into t values (1,0) on duplicate key update x=x+1; 23 24replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; 25error ER_UNSUPPORTED_EXTENSION; 26insert into t values (1,0) on duplicate key update x=x-1; 27 28drop table t; 29 30 31