1 #############################################################
2 # 2006-02-07 By JBM added order by
3 #############################################################
4 # test to see if replication can continue when master sporadically fails on
5 # COM_BINLOG_DUMP and additionally limits the number of events per dump
7 source include/master-slave.inc;
9 create table t2(n int);
10 create table t1(n int not null auto_increment primary key);
11 insert into t1 values (NULL),(NULL);
13 # We have to use 4 in the following to make this test work with all table types
14 insert into t1 values (4),(NULL);
15 sync_slave_with_master;
19 insert into t1 values (NULL),(NULL);
22 insert into t1 values (10),(NULL),(NULL),(NULL),(NULL),(NULL);
23 sync_slave_with_master;
24 select * from t1 ORDER BY n;
27 sync_slave_with_master;
30 --source include/rpl_end.inc