summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/rpl/r/rpl_server_id2.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_server_id2.result')
-rw-r--r--mysql-test/suite/rpl/r/rpl_server_id2.result41
1 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_server_id2.result b/mysql-test/suite/rpl/r/rpl_server_id2.result
new file mode 100644
index 00000000..3d8eeb02
--- /dev/null
+++ b/mysql-test/suite/rpl/r/rpl_server_id2.result
@@ -0,0 +1,41 @@
+include/master-slave.inc
+[connection master]
+connection slave;
+include/stop_slave.inc
+CHANGE MASTER TO MASTER_USE_GTID=NO;
+include/start_slave.inc
+create table t1 (n int);
+reset master;
+stop slave;
+include/wait_for_slave_to_stop.inc
+change master to master_port=SLAVE_PORT;
+start slave;
+include/wait_for_slave_to_start.inc
+insert into t1 values (1);
+select * from t1;
+n
+1
+1
+stop slave;
+include/wait_for_slave_to_stop.inc
+drop table t1;
+connection master;
+reset master;
+create table t1(n int);
+create table t2(n int);
+connection slave;
+change master to master_port=MASTER_PORT;
+start slave until master_log_file='master-bin.000001', master_log_pos=UNTIL_POS;
+include/wait_for_slave_io_to_start.inc
+include/wait_for_slave_sql_to_stop.inc
+*** checking until position execution: must be only t1 in the list ***
+show tables;
+Tables_in_test
+t1
+connection slave;
+start slave sql_thread;
+connection master;
+drop table t1;
+drop table t2;
+connection slave;
+include/rpl_end.inc