EVOLUTION-MANAGER

Edit File: fast_upsert_key.test

source include/have_tokudb.inc;

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

# must have primary key
create table t (a int, b char(32), c varchar(32), d blob) engine = tokudb;
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
error ER_UNSUPPORTED_EXTENSION;
insert into t values (1,null,null,null) on duplicate key update a=42;
drop table t;

# must have no clustering keys
create table t (id int primary key,
                a int, b char(32),
                c varchar(32),
                d blob,
                clustering key(a)) engine = tokudb;
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
error ER_UNSUPPORTED_EXTENSION;
insert into t values (1,null,null,null,null) on duplicate key update a=42;
drop table t;

# must have no secondary keys
create table t (id int primary key,
                a int,
                b char(32),
                c varchar(32),
                d blob,
                key(c)) engine = tokudb ;
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
error ER_UNSUPPORTED_EXTENSION;
insert into t values (1,null,null,null,null) on duplicate key update a=42;
drop table t;

# update field must not be part of any key
create table t (id int,
                a int, b char(32),
                c varchar(32),
                d blob,
                primary key(id, a)) engine = tokudb;
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
error ER_UNSUPPORTED_EXTENSION;
insert into t values (1,2,null,null,null) on duplicate key update a=42;
drop table t;

create table t (id int,
                a int, b char(32),
                c varchar(32),
                d blob,
                primary key(a, id)) engine = tokudb;
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
error ER_UNSUPPORTED_EXTENSION;
insert into t values (1,2,null,null,null) on duplicate key update a=42;
drop table t;