long uniques don't work with spider

--disable_warnings

--disable_query_log

--disable_result_log

--source test_init.inc

--enable_result_log

--enable_query_log

--connection child2_1

create database auto_test_remote;

use auto_test_remote;

create table ta_r (

  f1 bigint(20) not null auto_increment primary key,

  f2 varchar(30) default null,

  f3 varchar(30) default null,

  f4 varchar(25) default null,

  f5 varchar(30) default null,

  f6 varchar(25) default null,

  f7 varchar(25) default null,

  unique problem_key (f3,f5,f6,f2,f4,f7) using hash

) engine=myisam;

--connection master_1

create database auto_test_local;

use auto_test_local;

eval create table t1 (

  f1 bigint(20) not null auto_increment primary key,

  f2 varchar(30) default null,

  f3 varchar(30) default null,

  f4 varchar(25) default null,

  f5 varchar(30) default null,

  f6 varchar(25) default null,

  f7 varchar(25) default null,

  unique problem_key (f3,f5,f6,f2,f4,f7) using hash

) engine=spider

  $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT_2_1;

insert  t1 (f2, f3, f4, f5, f6, f7) values ('00004', '0001009089999', '', 'netstes', 'psit', 'd');

replace t1 (f2, f3, f4, f5, f6, f7) values ('00004', '0001009089999', '', 'netstes', 'psit', 'd');

insert  t1 (f2, f3, f4, f5, f6, f7) values ('00004', '0001009089999', '', 'netstes', 'psit', 'e');

replace t1 (f2, f3, f4, f5, f6, f7) values ('00004', '0001009089999', '', 'netstes', 'psit', 'e');

select * from t1;

drop database auto_test_local;

--connection child2_1

drop database auto_test_remote;

--disable_warnings

--disable_query_log

--disable_result_log

--source test_deinit.inc

--enable_result_log

--enable_query_log