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 13source include/not_gtid_enabled.inc; 14source include/master-slave.inc; 15call mtr.add_suppression ("Slave I/O: Got fatal error 1236 from master when reading data from binary"); 16source include/show_master_status.inc; 17--source include/sync_slave_sql_with_master.inc 18source include/stop_slave.inc; 19 20--replace_result 75 MASTER_LOG_POS 21change master to master_log_pos=75; 22let $status_items= Read_Master_Log_Pos; 23source include/show_slave_status.inc; 24start slave; 25let $slave_io_errno= 1236; 26--let $show_slave_io_error= 1 27# Mask line numbers 28--let $slave_io_error_replace= / at [0-9]*/ at XXX/ 29source include/wait_for_slave_io_error.inc; 30source include/stop_slave_sql.inc; 31 32connection master; 33source include/show_master_status.inc; 34create table if not exists t1 (n int); 35drop table if exists t1; 36create table t1 (n int); 37insert into t1 values (1),(2),(3); 38save_master_pos; 39connection slave; 40--replace_result 4 MASTER_LOG_POS 41change master to master_log_pos=4; 42start slave; 43sync_with_master; 44select * from t1 ORDER BY n; 45connection master; 46drop table t1; 47--source include/sync_slave_sql_with_master.inc 48 49--echo End of 5.0 tests 50--source include/rpl_end.inc 51