← 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_stm_insert_delayed.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_stm_insert_delayed.result
52
52
INSERT DELAYED IGNORE INTO t1 VALUES(1);
53
53
INSERT DELAYED IGNORE INTO t1 VALUES(1);
54
54
flush table t1;
55
 
show binlog events in 'master-bin.000002' LIMIT 2,2;
 
55
show binlog events in 'master-bin.000002' from <binlog_start> limit 1,2;
56
56
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
57
 
x       x       x       x       x       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
58
 
x       x       x       x       x       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
 
57
master-bin.000002       #       Query   #       #       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
 
58
master-bin.000002       #       Query   #       #       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
59
59
select * from t1;
60
60
a
61
61
1
62
62
On slave
63
 
show binlog events in 'slave-bin.000002' LIMIT 2,2;
 
63
show binlog events in 'slave-bin.000002' from <binlog_start> limit 1,2;
64
64
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
65
 
x       x       x       x       x       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
66
 
x       x       x       x       x       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
 
65
slave-bin.000002        #       Query   #       #       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
 
66
slave-bin.000002        #       Query   #       #       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
67
67
select * from t1;
68
68
a
69
69
1
112
112
USE test;
113
113
DROP SCHEMA mysqlslap;
114
114
use test;
115
 
FLUSH LOGS;
116
 
FLUSH LOGS;
117
115
CREATE TABLE t1(a int, UNIQUE(a));
118
116
INSERT DELAYED IGNORE INTO t1 VALUES(1);
119
117
INSERT DELAYED IGNORE INTO t1 VALUES(1);
120
118
flush table t1;
121
 
show binlog events in 'master-bin.000002' LIMIT 2,2;
122
 
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
123
 
x       x       x       x       x       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
124
 
x       x       x       x       x       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
125
119
select * from t1;
126
120
a
127
121
1
128
122
On slave
129
 
show binlog events in 'slave-bin.000002' LIMIT 2,2;
130
 
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
131
 
x       x       x       x       x       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
132
 
x       x       x       x       x       use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
133
123
select * from t1;
134
124
a
135
125
1