1 # Verify that after CHANGE MASTER, replication (I/O thread and SQL
2 # thread) restart from where SQL thread left, not from where
3 # I/O thread left (some old bug fixed in 4.0.17)
5 source include/master-slave.inc;
8 # Make SQL slave thread advance a bit
9 create table t1(n int);
10 sync_slave_with_master;
12 # Now stop it and make I/O slave thread be ahead
13 stop slave sql_thread;
15 insert into t1 values(1);
16 insert into t1 values(2);
19 --real_sleep 3 # wait for I/O thread to have read updates
21 --replace_result $MASTER_MYPORT MASTER_MYPORT
22 --replace_column 1 # 7 # 8 # 9 # 23 # 33 #
24 change master to master_user='root';
25 --replace_result $MASTER_MYPORT MASTER_MYPORT
26 --replace_column 1 # 7 # 8 # 9 # 23 # 33 #