summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/t/fast_upsert_bin_pad.test
blob: 5673c9d1542be248f7eef6523aef690924abf05d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
source include/have_tokudb.inc;

set tokudb_enable_fast_upsert=1;
source ../include/setup_fast_update_upsert.inc;

create table t0 (id int primary key, b binary(32)) engine = tokudb;
create table t1 like t0;

insert into t0 values (1,'hi'),(2,'there');
select * from t0;
insert into t1 values (1,null),(2,null);
insert into t1 values (1,null) on duplicate key update b='hi';
insert into t1 values (2,null) on duplicate key update b='there';
select * from t1;

let $diff_tables = test.t0, test.t1;
source include/diff_tables.inc;

drop table t0, t1;