diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/fast_update_char.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/fast_update_char.result | 60 |
1 files changed, 35 insertions, 25 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/fast_update_char.result b/storage/tokudb/mysql-test/tokudb/r/fast_update_char.result index 4121d5d72eb..598458262d9 100644 --- a/storage/tokudb/mysql-test/tokudb/r/fast_update_char.result +++ b/storage/tokudb/mysql-test/tokudb/r/fast_update_char.result @@ -1,54 +1,64 @@ -set default_storage_engine='tokudb'; -drop table if exists tt, ti; -set tokudb_disable_slow_update=1; -create table tt (id int primary key, c char(32), b binary(32)); +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 tt (id int primary key, c char(32), b binary(32)) engine = tokudb; create table ti like tt; alter table ti engine=innodb; insert into tt values (1,null,null); insert into ti values (1,null,null); -update noar tt set c='hi' where id=1; -update noar ti set c='hi' where id=1; +update tt set c='hi' where id=1; +update ti set c='hi' where id=1; include/diff_tables.inc [test.tt, test.ti] -update noar tt set c='there' where id=1; -update noar ti set c='there' where id=1; +update tt set c='there' where id=1; +update ti set c='there' where id=1; include/diff_tables.inc [test.tt, test.ti] drop table tt, ti; -create table tt (id char(8) primary key, c char(32), b binary(32)); +create table tt (id char(8) primary key, +c char(32), +b binary(32)) engine = tokudb; create table ti like tt; alter table ti engine=innodb; insert into tt values ('1',null,null); insert into ti values ('1',null,null); -update noar tt set c='hi' where id='1'; -update noar ti set c='hi' where id='1'; +update tt set c='hi' where id='1'; +update ti set c='hi' where id='1'; include/diff_tables.inc [test.tt, test.ti] -update noar tt set c='there' where id='1'; -update noar ti set c='there' where id='1'; +update tt set c='there' where id='1'; +update ti set c='there' where id='1'; include/diff_tables.inc [test.tt, test.ti] drop table tt, ti; -create table tt (id varchar(8) primary key, a int, b char(32), c char(32), d binary(32)); +create table tt (id varchar(8) primary key, +a int, +b char(32), +c char(32), +d binary(32)) engine = tokudb; create table ti like tt; alter table ti engine=innodb; insert into tt values ('1',null,null,null,null); insert into ti values ('1',null,null,null,null); -update noar tt set b='hi' where id='1'; -update noar ti set b='hi' where id='1'; +update tt set b='hi' where id='1'; +update ti set b='hi' where id='1'; include/diff_tables.inc [test.tt, test.ti] -update noar tt set c='there' where id='1'; -update noar ti set c='there' where id='1'; +update tt set c='there' where id='1'; +update ti set c='there' where id='1'; include/diff_tables.inc [test.tt, test.ti] drop table tt, ti; -create table tt (id varchar(8) primary key, a int, b char(32), c char(32), d binary(32)); +create table tt (id varchar(8) primary key, +a int, +b char(32), +c char(32), +d binary(32)) engine = tokudb; create table ti like tt; alter table ti engine=innodb; insert into tt values ('1',null,null,null,null); insert into ti values ('1',null,null,null,null); -update noar tt set b='123' where id='1'; -update noar ti set b='123' where id='1'; +update tt set b='123' where id='1'; +update ti set b='123' where id='1'; include/diff_tables.inc [test.tt, test.ti] -update noar tt set c=456 where id='1'; -update noar ti set c=456 where id='1'; +update tt set c=456 where id='1'; +update ti set c=456 where id='1'; include/diff_tables.inc [test.tt, test.ti] -update noar tt set c=789 where id=1; -update noar ti set c=789 where id=1; +update tt set c=789 where id=1; +update ti set c=789 where id=1; include/diff_tables.inc [test.tt, test.ti] drop table tt, ti; |