summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/t/fast_update_sqlmode.test
diff options
context:
space:
mode:
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.test25
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;