diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/fast_update_sqlmode.test')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/t/fast_update_sqlmode.test | 25 |
1 files changed, 9 insertions, 16 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/fast_update_sqlmode.test b/storage/tokudb/mysql-test/tokudb/t/fast_update_sqlmode.test index 9eb7721b538..2740cd6c316 100644 --- a/storage/tokudb/mysql-test/tokudb/t/fast_update_sqlmode.test +++ b/storage/tokudb/mysql-test/tokudb/t/fast_update_sqlmode.test @@ -1,36 +1,29 @@ source include/have_tokudb.inc; -set default_storage_engine='tokudb'; - -disable_warnings; -drop table if exists t; -enable_warnings; - -set tokudb_disable_slow_update=1; +set tokudb_enable_fast_update=1; +source ../include/setup_fast_update_upsert.inc; let $default_sql_mode = `select @@session.sql_mode`; -create table t (id int primary key, x int not null); +create table t (id int primary key, x int not null) engine = tokudb; insert into t values (1,0); -update noar t set x=42 where id=1; -update noar t set x=x+1 where id=1; -update noar t set x=x-1 where id=1; +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; eval set session sql_mode="$default_sql_mode,traditional"; replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; error ER_UNSUPPORTED_EXTENSION; -update noar t set x=42 where id=1; +update t set x=42 where id=1; replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x+1 where id=1; +update t set x=x+1 where id=1; replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; error ER_UNSUPPORTED_EXTENSION; -update noar t set x=x-1 where id=1; - -eval set session sql_mode="$default_sql_mode"; +update t set x=x-1 where id=1; drop table t; |