########## # Change Author: JBM # Change Date: 2006-01-16 # Change: Added Order by for NDB ########## # # Testing of setting slave to wrong log position with master_log_pos # # Passes with rbr no problem, removed statement include [jbm] source include/master-slave.inc; --replace_column 3 <Binlog_Ignore_DB> show master status; sync_slave_with_master; source include/show_slave_status.inc; stop slave; change master to master_log_pos=75; start slave; sleep 5; stop slave; change master to master_log_pos=75; source include/show_slave_status.inc; start slave; sleep 5; source include/show_slave_status.inc; stop slave; change master to master_log_pos=178; start slave; sleep 2; source include/show_slave_status.inc; connection master; --replace_column 3 <Binlog_Ignore_DB> show master status; create table if not exists t1 (n int); drop table if exists t1; create table t1 (n int); insert into t1 values (1),(2),(3); save_master_pos; connection slave; stop slave; change master to master_log_pos=106; start slave; sync_with_master; select * from t1 ORDER BY n; connection master; drop table t1; sync_slave_with_master; # End of 4.1 tests