← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/rpl_server_id2.test

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-05-11 18:47:32 UTC
  • mto: (2.1.2 sid) (1.2.1 upstream)
  • mto: This revision was merged to the branch mainline in revision 4.
  • Revision ID: james.westby@ubuntu.com-20100511184732-jhn055kfhxze24kt
Tags: upstream-5.1.46
Import upstream version 5.1.46

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/rpl_server_id2.test
 
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 #
 
14
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