← Back to branch summary

~ubuntu-branches/ubuntu/natty/mysql-5.1/natty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_stm_until.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 08:30:45 UTC
  • mfrom: (1.4.1)
  • Revision ID: package-import@ubuntu.com-20120222083045-2rd53r4bnyx7qus4
Tags: 5.1.61-0ubuntu0.11.04.1
https://launchpad.net/bugs/937869
* SECURITY UPDATE: Update to 5.1.61 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2011-2262
  - CVE-2012-0075
  - CVE-2012-0112
  - CVE-2012-0113
  - CVE-2012-0114
  - CVE-2012-0115
  - CVE-2012-0116
  - CVE-2012-0117
  - CVE-2012-0118
  - CVE-2012-0119
  - CVE-2012-0120
  - CVE-2012-0484
  - CVE-2012-0485
  - CVE-2012-0486
  - CVE-2012-0487
  - CVE-2012-0488
  - CVE-2012-0489
  - CVE-2012-0490
  - CVE-2012-0491
  - CVE-2012-0492
  - CVE-2012-0493
  - CVE-2012-0494
  - CVE-2012-0495
  - CVE-2012-0496

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_stm_until.result
1
 
stop slave;
2
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3
 
reset master;
4
 
reset slave;
5
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6
 
start slave;
 
1
include/master-slave.inc
 
2
[connection master]
7
3
[on slave]
8
4
include/stop_slave.inc
9
5
==== Create some events on master ====
18
14
==== Replicate one event at a time on slave ====
19
15
[on slave]
20
16
start slave until master_log_file='MASTER_LOG_FILE', master_log_pos=MASTER_LOG_POS;
 
17
include/wait_for_slave_io_to_start.inc
 
18
include/wait_for_slave_sql_to_stop.inc
21
19
select * from t1;
22
20
n
23
21
1
24
22
2
25
23
3
26
24
4
 
25
include/check_slave_param.inc [Exec_Master_Log_Pos]
27
26
start slave until master_log_file='master-no-such-bin.000001', master_log_pos=MASTER_LOG_POS;
 
27
include/wait_for_slave_io_to_start.inc
 
28
include/wait_for_slave_sql_to_stop.inc
28
29
select * from t1;
29
30
n
30
31
1
31
32
2
32
33
3
33
34
4
34
 
start slave until relay_log_file='slave-relay-bin.000004', relay_log_pos=RELAY_LOG_POS;
 
35
include/check_slave_param.inc [Exec_Master_Log_Pos]
 
36
start slave until relay_log_file='slave-relay-bin.000003', relay_log_pos=RELAY_LOG_POS;
 
37
include/wait_for_slave_io_to_start.inc
 
38
include/wait_for_slave_sql_to_stop.inc
35
39
select * from t2;
36
40
n
37
41
1
38
42
2
 
43
include/check_slave_param.inc [Exec_Master_Log_Pos]
39
44
start slave;
40
45
[on master]
41
46
[on slave]
42
47
include/stop_slave.inc
43
48
start slave until master_log_file='MASTER_LOG_FILE', master_log_pos=MASTER_LOG_POS;
 
49
include/wait_for_slave_io_to_start.inc
 
50
include/wait_for_slave_sql_to_stop.inc
 
51
include/check_slave_param.inc [Exec_Master_Log_Pos]
44
52
==== Test various error conditions ====
45
53
start slave until master_log_file='master-bin', master_log_pos=MASTER_LOG_POS;
46
54
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
75
83
two
76
84
2
77
85
start slave until master_log_file='MASTER_LOG_FILE', master_log_pos= UNTIL_POS;;
 
86
include/wait_for_slave_sql_to_stop.inc
78
87
slave stopped at the prescribed position
79
88
select 0 as zero;
80
89
zero
84
93
1
85
94
drop table t1;
86
95
start slave;
87
 
stop slave;
88
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
89
 
reset master;
90
 
reset slave;
91
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
92
 
start slave;
93
 
drop table if exists t1;
94
 
Warnings:
95
 
Note    1051    Unknown table 't1'
 
96
include/rpl_reset.inc
96
97
flush logs;
97
98
stop slave;
98
99
reset slave;
99
100
start slave until master_log_file='master-bin.000001', master_log_pos=294 /* to stop right before DROP */;
 
101
include/wait_for_slave_sql_to_stop.inc
100
102
show tables /* t1 must exist */;
101
103
Tables_in_test
102
104
t1
103
105
drop table t1;
104
106
stop slave;
105
 
reset slave;
106
 
reset master;
 
107
include/rpl_end.inc