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