1
by brian
clean slate |
1 |
# This test checks that a slave DOES execute queries originating |
2 |
# from itself, if running with --replicate-same-server-id. |
|
3 |
||
4 |
source include/master-slave.inc; |
|
5 |
connection slave; |
|
6 |
create table t1 (n int); |
|
7 |
reset master; |
|
8 |
# replicate ourselves |
|
9 |
stop slave; |
|
10 |
--replace_result $SLAVE_MYPORT SLAVE_PORT
|
|
11 |
eval change master to master_port=$SLAVE_MYPORT; |
|
12 |
--replace_result $SLAVE_MYPORT SLAVE_PORT
|
|
13 |
--replace_column 18 # 35 # 36 #
|
|
14 |
query_vertical show slave status; |
|
15 |
start slave; |
|
16 |
insert into t1 values (1); |
|
17 |
save_master_pos; |
|
18 |
sync_with_master; |
|
19 |
select * from t1; # check that indeed 2 were inserted |
|
20 |
# We stop the slave before cleaning up otherwise we'll get |
|
21 |
# 'drop table t1' executed twice, so an error in the slave.err |
|
22 |
# (not critical). |
|
23 |
stop slave; |
|
24 |
drop table t1; |
|
25 |
||
26 |
# End of 4.1 tests |