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