summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/r/fast_update_sqlmode.result
blob: b92b339692865cea3ed926165df0bee82ceb8072 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
set tokudb_enable_fast_update=1;
set session sql_mode=(select replace(@@sql_mode,'STRICT_TRANS_TABLES',''));
set session sql_mode=(select replace(@@sql_mode,'STRICT_ALL_TABLES',''));
create table t (id int primary key, x int not null) engine = tokudb;
insert into t values (1,0);
update t set x=42 where id=1;
update t set x=x+1 where id=1;
update t set x=x-1 where id=1;
set session sql_mode="NO_ENGINE_SUBSTITUTION,traditional";
update t set x=42 where id=1;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
update t set x=x+1 where id=1;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
update t set x=x-1 where id=1;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
drop table t;