← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/t/rpl_server_id2.test

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/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 # 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