1########## 2# Change Author: JBM 3# Change Date: 2006-01-16 4# Change: Added Order by for NDB 5########## 6 7# 8# Testing of setting slave to wrong log position with master_log_pos 9# 10 11# Passes with rbr no problem, removed statement include [jbm] 12 13--source include/not_group_replication_plugin.inc 14source include/not_gtid_enabled.inc; 15source include/master-slave.inc; 16call mtr.add_suppression ("Slave I/O for channel '': Got fatal error 1236 from master when reading data from binary"); 17source include/show_master_status.inc; 18--source include/sync_slave_sql_with_master.inc 19source include/stop_slave.inc; 20 21--replace_result 75 MASTER_LOG_POS 22change master to master_log_pos=75; 23let $status_items= Read_Master_Log_Pos; 24source include/show_slave_status.inc; 25start slave; 26let $slave_io_errno= 1236; 27--let $show_slave_io_error= 1 28# Mask line numbers 29--let $slave_io_error_replace= / at [0-9]*/ at XXX/ 30source include/wait_for_slave_io_error.inc; 31source include/stop_slave_sql.inc; 32 33connection master; 34source include/show_master_status.inc; 35create table if not exists t1 (n int); 36drop table if exists t1; 37create table t1 (n int); 38insert into t1 values (1),(2),(3); 39save_master_pos; 40connection slave; 41--replace_result 4 MASTER_LOG_POS 42change master to master_log_pos=4; 43start slave; 44sync_with_master; 45select * from t1 ORDER BY n; 46connection master; 47drop table t1; 48--source include/sync_slave_sql_with_master.inc 49 50--echo End of 5.0 tests 51--source include/rpl_end.inc 52