summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/r/fast_update_sqlmode.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/fast_update_sqlmode.result')
-rw-r--r--storage/tokudb/mysql-test/tokudb/r/fast_update_sqlmode.result21
1 files changed, 10 insertions, 11 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/fast_update_sqlmode.result b/storage/tokudb/mysql-test/tokudb/r/fast_update_sqlmode.result
index 262b242fbec..b92b3396928 100644
--- a/storage/tokudb/mysql-test/tokudb/r/fast_update_sqlmode.result
+++ b/storage/tokudb/mysql-test/tokudb/r/fast_update_sqlmode.result
@@ -1,17 +1,16 @@
-set default_storage_engine='tokudb';
-drop table if exists t;
-set tokudb_disable_slow_update=1;
-create table t (id int primary key, x int not null);
+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 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;
set session sql_mode="NO_ENGINE_SUBSTITUTION,traditional";
-update noar t set x=42 where id=1;
+update t set x=42 where id=1;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
-update noar t set x=x+1 where id=1;
+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 noar t set x=x-1 where id=1;
+update t set x=x-1 where id=1;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
-set session sql_mode="NO_ENGINE_SUBSTITUTION";
drop table t;