|
1
by brian
clean slate |
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/master-slave.inc; |
|
14 |
source include/show_master_status.inc; |
|
15 |
sync_slave_with_master; |
|
16 |
stop slave; |
|
17 |
--source include/wait_for_slave_to_stop.inc |
|
18 |
||
19 |
change master to master_log_pos=75; |
|
20 |
source include/show_slave_status2.inc; |
|
21 |
start slave; |
|
22 |
let $slave_param= Slave_SQL_Running; |
|
23 |
let $slave_param_value= Yes; |
|
24 |
--source include/wait_for_slave_param.inc |
|
25 |
let $slave_param= Slave_IO_Running; |
|
26 |
let $slave_param_value= No; |
|
27 |
--source include/wait_for_slave_param.inc |
|
28 |
stop slave; |
|
29 |
--source include/wait_for_slave_to_stop.inc |
|
30 |
||
31 |
source include/show_slave_status.inc; |
|
32 |
connection master; |
|
33 |
source include/show_master_status.inc; |
|
34 |
create table if not exists t1 (n int); |
|
35 |
drop table if exists t1; |
|
36 |
create table t1 (n int); |
|
37 |
insert into t1 values (1),(2),(3); |
|
38 |
save_master_pos; |
|
39 |
connection slave; |
|
40 |
change master to master_log_pos=4; |
|
41 |
start slave; |
|
42 |
sync_with_master; |
|
43 |
select * from t1 ORDER BY n; |
|
44 |
connection master; |
|
45 |
drop table t1; |
|
46 |
sync_slave_with_master; |
|
47 |
||
48 |
--echo End of 5.0 tests
|