← 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/rpl/r/rpl_dual_pos_advance.result

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
Import upstream version 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_dual_pos_advance.result
6
6
start slave;
7
7
reset master;
8
8
change master to master_host="127.0.0.1",master_port=SLAVE_PORT,master_user="root";
9
 
start slave;
 
9
include/start_slave.inc
10
10
create table t1 (n int);
11
 
stop slave;
 
11
include/stop_slave.inc
12
12
create table t2 (n int);
13
13
show tables;
14
14
Tables_in_test
22
22
insert into t3 values(3);
23
23
commit;
24
24
insert into t3 values(4);
25
 
start slave until master_log_file="slave-bin.000001",master_log_pos=195;
 
25
start slave until master_log_file="MASTER_LOG_FILE",master_log_pos=MASTER_LOG_POS;
26
26
Warnings:
27
27
Note    1278    It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart
28
28
show tables;
29
29
Tables_in_test
30
30
t1
31
31
t2
32
 
start slave until master_log_file="slave-bin.000001",master_log_pos=438;
 
32
start slave until master_log_file="MASTER_LOG_FILE",master_log_pos=MASTER_LOG_POS;
33
33
Warnings:
34
34
Note    1278    It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart
35
35
select * from t3;
36
36
n
37
37
1
38
 
start slave until master_log_file="slave-bin.000001",master_log_pos=663;
 
38
start slave until master_log_file="MASTER_LOG_FILE",master_log_pos=MASTER_LOG_POS;
39
39
Warnings:
40
40
Note    1278    It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart
41
41
select * from t3;
43
43
1
44
44
2
45
45
3
46
 
start slave;
 
46
include/start_slave.inc
47
47
create table t4 (n int);
48
48
create table t5 (n int);
49
49
create table t6 (n int);
55
55
t4
56
56
t5
57
57
t6
58
 
stop slave;
 
58
include/stop_slave.inc
59
59
reset slave;
60
60
drop table t1,t2,t3,t4,t5,t6;