--source include/master-slave.inc
#--source include/have_innodb.inc

--connect(con1,localhost,root,,)
--connect(con2,localhost,root,,)
--connect(con3,localhost,root,,)
--connect(con4,localhost,root,,)

DROP DATABASE IF EXISTS test;
create database if not exists test;
use test;

drop table if exists test1;
drop table if exists test2;

create table test1(
   a int not null,
   b char(2) not null,
   primary key(a, b)
) ENGINE=INNODB;

create table test2(
   a int not null,
   b char(2) not null,
   primary key(a, b)
) ENGINE=INNODB;

insert into test1 values(1, 'en'), (2, 'ca');

drop table if exists test3, test4;
create table test3 (
  id int not null primary key,
  name varchar(255)
);
create table test4 (
  id int not null primary key,
  name varchar(255)
);
insert into test3(id, name) values(15034, '51707'),(1, '001');
insert into test4(id, name) values(15034, '051707'),(1, '1');

--connection con1
LOCK TABLES `test`.`test1` WRITE;

--connection con3
LOCK TABLES `test`.`test2` WRITE;

--connection con1
ALTER TABLE `test`.`test1` RENAME `test`.`test1_tmp_16810`;

--connection con3
ALTER TABLE `test`.`test2` RENAME `test`.`test1`;

unlock tables;
--connection con1
unlock tables;

drop table if exists test1;
drop table if exists test2;
drop table if exists test3;
drop table if exists test4;
--sync_slave_with_master