1include/master-slave.inc
2[connection master]
3connection master;
4create table t1(a int not null auto_increment, b int, primary key(a));
5create table t2(a int not null auto_increment, b int, primary key(a)) engine=innodb;
6load data infile '../../std_data/rpl_loaddata.dat' into table t1;
7start transaction;
8insert into t2(b) values (1);
9insert into t2(b) values (2);
10load data infile '../../std_data/rpl_loaddata.dat' into table t2;
11load data infile '../../std_data/rpl_loaddata.dat' into table t2;
12commit;
13connection slave;
14include/diff_tables.inc [master:t1, slave:t1]
15include/diff_tables.inc [master:t2, slave:t2]
16connection master;
17drop table t1;
18drop table t2;
19connection slave;
20include/rpl_end.inc
21