5.6.26-74.0

1 files changed, 54 insertions, 0 deletions

diff --git a/mysql-test/suite/tokudb/r/fast_update_char.result b/mysql-test/suite/tokudb/r/fast_update_char.result
new file mode 100644
index 00000000000..4121d5d72eb
--- /dev/null
+++ b/mysql-test/suite/tokudb/r/fast_update_char.result
@@ -0,0 +1,54 @@
+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));
+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;
+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;
+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 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';
+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';
+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 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';
+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';
+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 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';
+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';
+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;
+include/diff_tables.inc [test.tt, test.ti]
+drop table tt, ti;