diff options
Diffstat (limited to 'mysql-test/r/rpl000014.result')
| -rw-r--r-- | mysql-test/r/rpl000014.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/rpl000014.result b/mysql-test/r/rpl000014.result index cdafc7575ab..ec79c4c37e6 100644 --- a/mysql-test/r/rpl000014.result +++ b/mysql-test/r/rpl000014.result @@ -1,16 +1,39 @@ +slave stop; +reset master; +reset slave; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +slave start; +show master status; File Position Binlog_do_db Binlog_ignore_db master-bin.001 79 +show slave status; Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Last_log_seq 127.0.0.1 root 9999 1 master-bin.001 79 Yes 0 0 1 +change master to master_log_pos=73; +slave stop; +change master to master_log_pos=73; +show slave status; Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Last_log_seq 127.0.0.1 root 9999 1 master-bin.001 73 No 0 0 1 +slave start; +show slave status; Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Last_log_seq 127.0.0.1 root 9999 1 master-bin.001 73 Yes 0 0 1 +change master to master_log_pos=173; +show slave status; Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Last_log_seq 127.0.0.1 root 9999 1 master-bin.001 173 Yes 0 0 1 +show master status; File Position Binlog_do_db Binlog_ignore_db master-bin.001 79 +create table if not exists foo(n int); +drop table if exists foo; +create table foo (n int); +insert into foo values (1),(2),(3); +change master to master_log_pos=79; +select * from foo; n 1 2 3 +drop table foo; |