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/master-slave.inc;
15call mtr.add_suppression ("Slave I/O for channel '': 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= 13114;
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