← 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_ndb/r/rpl_ndb_stm_innodb.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_ndb/r/rpl_ndb_stm_innodb.result
4
4
reset slave;
5
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6
6
start slave;
 
7
SET binlog_format = STATEMENT;
7
8
 
8
9
*** Test 1 ***
9
10
 
26
27
# since insert is done with transactional engine, expect a BEGIN
27
28
# at <start_pos>
28
29
 
29
 
show binlog events from <start_pos> limit 1;
 
30
show binlog events from <binlog_start> limit 1;
30
31
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
31
 
master-bin.000001       <start_pos>     Query   1       #       BEGIN
 
32
master-bin.000001       #       Query   #       #       BEGIN
32
33
 
33
34
# Now the insert, one step after
34
35
 
35
 
show binlog events from <start_pos> limit 1,1;
 
36
show binlog events from <binlog_start> limit 1,1;
36
37
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)
 
38
master-bin.000001       #       Query   #       #       use `test`; insert into t1 values (1,2)
38
39
 
39
40
# and the COMMIT should be at <end_pos>
40
41
 
41
 
show binlog events from <start_pos> limit 2,1;
 
42
show binlog events from <binlog_start> limit 2,1;
42
43
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
43
 
master-bin.000001       #       Xid     1       <end_pos>       COMMIT /* XID */
 
44
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
44
45
 
45
46
begin;
46
47
insert into t1 values (2,3);
51
52
from mysql.ndb_apply_status;
52
53
@log_name:=log_name     @start_pos:=start_pos   @end_pos:=end_pos
53
54
<log_name>      <start_pos>     <end_pos>
54
 
show binlog events from <start_pos> limit 1;
 
55
show binlog events from <binlog_start> limit 1;
55
56
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
56
 
master-bin.000001       <start_pos>     Query   1       #       BEGIN
 
57
master-bin.000001       #       Query   #       #       BEGIN
57
58
 
58
 
show binlog events from <start_pos> limit 1,2;
 
59
show binlog events from <binlog_start> limit 1,2;
59
60
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
60
61
master-bin.000001       #       Query   #       #       use `test`; insert into t1 values (2,3)
61
62
master-bin.000001       #       Query   #       #       use `test`; insert into t2 values (3,4)
62
63
 
63
 
show binlog events from <start_pos> limit 3,1;
 
64
show binlog events from <binlog_start> limit 3,1;
64
65
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
65
 
master-bin.000001       #       Xid     1       <end_pos>       COMMIT /* XID */
 
66
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
66
67
 
67
68
DROP TABLE test.t1, test.t2;
68
69
SHOW TABLES;