← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/r/binlog_row_blackhole.result

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/binlog_row_blackhole.result
104
104
a
105
105
select * from t3;
106
106
a
107
 
show binlog events;
 
107
show binlog events from <binlog_start>;
108
108
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
109
 
master-bin.000001       #       Format_desc     1       #       Server ver: VERSION, Binlog ver: 4
110
 
master-bin.000001       #       Query   1       #       use `test`; drop table t1,t2
111
 
master-bin.000001       #       Query   1       #       use `test`; create table t1 (a int) engine=blackhole
112
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
113
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
114
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
115
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
116
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
117
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
118
 
master-bin.000001       #       Query   1       #       use `test`; create table t2 (a varchar(200)) engine=blackhole
119
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t2)
120
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
121
 
master-bin.000001       #       Query   1       #       use `test`; alter table t1 add b int
122
 
master-bin.000001       #       Query   1       #       use `test`; alter table t1 drop b
123
 
master-bin.000001       #       Query   1       #       use `test`; create table t3 like t1
 
109
master-bin.000001       #       Query   #       #       use `test`; drop table t1,t2
 
110
master-bin.000001       #       Query   #       #       use `test`; create table t1 (a int) engine=blackhole
 
111
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
112
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
113
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
114
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
115
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
116
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
117
master-bin.000001       #       Query   #       #       use `test`; create table t2 (a varchar(200)) engine=blackhole
 
118
master-bin.000001       #       Table_map       #       #       table_id: # (test.t2)
 
119
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
120
master-bin.000001       #       Query   #       #       use `test`; alter table t1 add b int
 
121
master-bin.000001       #       Query   #       #       use `test`; alter table t1 drop b
 
122
master-bin.000001       #       Query   #       #       use `test`; create table t3 like t1
124
123
drop table t1,t2,t3;
125
124
CREATE TABLE t1(a INT, b INT) ENGINE=BLACKHOLE;
126
125
DELETE FROM t1 WHERE a=10;
143
142
insert into t1 values(2);
144
143
rollback;
145
144
set autocommit=1;
146
 
show binlog events;
 
145
show binlog events from <binlog_start>;
147
146
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
148
 
master-bin.000001       #       Format_desc     1       #       Server ver: VERSION, Binlog ver: 4
149
 
master-bin.000001       #       Query   1       #       use `test`; create table t1 (a int) engine=blackhole
150
 
master-bin.000001       #       Query   1       #       use `test`; BEGIN
151
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
152
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
153
 
master-bin.000001       #       Query   1       #       use `test`; COMMIT
 
147
master-bin.000001       #       Query   #       #       use `test`; create table t1 (a int) engine=blackhole
 
148
master-bin.000001       #       Query   #       #       use `test`; BEGIN
 
149
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
150
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
151
master-bin.000001       #       Query   #       #       use `test`; COMMIT
154
152
drop table if exists t1;