← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl_ndb/r/rpl_ndb_stm_innodb.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl_ndb/r/rpl_ndb_stm_innodb.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]
 
3
SET binlog_format = STATEMENT;
7
4
 
8
5
*** Test 1 ***
9
6
 
26
23
# since insert is done with transactional engine, expect a BEGIN
27
24
# at <start_pos>
28
25
 
29
 
show binlog events from <start_pos> limit 1;
 
26
show binlog events from <binlog_start> limit 1;
30
27
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
31
 
master-bin.000001       <start_pos>     Query   1       #       BEGIN
 
28
master-bin.000001       #       Query   #       #       BEGIN
32
29
 
33
30
# Now the insert, one step after
34
31
 
35
 
show binlog events from <start_pos> limit 1,1;
 
32
show binlog events from <binlog_start> limit 1,1;
36
33
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
37
 
master-bin.000001       #       Query   1       #       use `test`; insert into t1 values (1,2)
 
34
master-bin.000001       #       Query   #       #       use `test`; insert into t1 values (1,2)
38
35
 
39
36
# and the COMMIT should be at <end_pos>
40
37
 
41
 
show binlog events from <start_pos> limit 2,1;
 
38
show binlog events from <binlog_start> limit 2,1;
42
39
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
43
 
master-bin.000001       #       Xid     1       <end_pos>       COMMIT /* XID */
 
40
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
44
41
 
45
42
begin;
46
43
insert into t1 values (2,3);
51
48
from mysql.ndb_apply_status;
52
49
@log_name:=log_name     @start_pos:=start_pos   @end_pos:=end_pos
53
50
<log_name>      <start_pos>     <end_pos>
54
 
show binlog events from <start_pos> limit 1;
 
51
show binlog events from <binlog_start> limit 1;
55
52
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
56
 
master-bin.000001       <start_pos>     Query   1       #       BEGIN
 
53
master-bin.000001       #       Query   #       #       BEGIN
57
54
 
58
 
show binlog events from <start_pos> limit 1,2;
 
55
show binlog events from <binlog_start> limit 1,2;
59
56
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
60
57
master-bin.000001       #       Query   #       #       use `test`; insert into t1 values (2,3)
61
58
master-bin.000001       #       Query   #       #       use `test`; insert into t2 values (3,4)
62
59
 
63
 
show binlog events from <start_pos> limit 3,1;
 
60
show binlog events from <binlog_start> limit 3,1;
64
61
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
65
 
master-bin.000001       #       Xid     1       <end_pos>       COMMIT /* XID */
 
62
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
66
63
 
67
64
DROP TABLE test.t1, test.t2;
68
65
SHOW TABLES;
122
119
 
123
120
** Test 4 **
124
121
 
125
 
stop slave;
126
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
127
 
reset master;
128
 
reset slave;
129
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
130
 
start slave;
 
122
include/rpl_reset.inc
131
123
 
132
124
select @log_name:=log_name, @start_pos:=start_pos, @end_pos:=end_pos
133
125
from mysql.ndb_apply_status;
141
133
*** DUMP MASTER & SLAVE FOR COMPARE ********
142
134
DROP DATABASE tpcb;
143
135
****** Do dumps compare ************
 
136
include/rpl_end.inc