diff options
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.result | 21 |
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; |