diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/fast_upsert_bin_pad.test')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/t/fast_upsert_bin_pad.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/fast_upsert_bin_pad.test b/storage/tokudb/mysql-test/tokudb/t/fast_upsert_bin_pad.test new file mode 100644 index 00000000000..d1eb8500c55 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/t/fast_upsert_bin_pad.test @@ -0,0 +1,25 @@ +source include/have_tokudb.inc; + +set default_storage_engine='tokudb'; + +disable_warnings; +drop table if exists t0, t1; +enable_warnings; + +set tokudb_disable_slow_upsert=1; + +create table t0 (id int primary key, b binary(32)); +create table t1 like t0; + +insert noar into t0 values (1,'hi'),(2,'there'); +select * from t0; +insert noar into t1 values (1,null),(2,null); +insert noar into t1 values (1,null) on duplicate key update b='hi'; +insert noar 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; + |