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