← 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/binlog/r/binlog_stm_blackhole.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/binlog/r/binlog_stm_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     #       #       Server ver: VERSION, Binlog ver: 4
110
109
master-bin.000001       #       Query   #       #       use `test`; drop table t1,t2
111
110
master-bin.000001       #       Query   #       #       use `test`; create table t1 (a int) engine=blackhole
112
111
master-bin.000001       #       Query   #       #       BEGIN
126
125
master-bin.000001       #       Query   #       #       COMMIT
127
126
master-bin.000001       #       Query   #       #       use `test`; create table t2 (a varchar(200)) engine=blackhole
128
127
master-bin.000001       #       Query   #       #       BEGIN
129
 
master-bin.000001       #       Begin_load_query        #       #       ;file_id=#;block_len=581
 
128
master-bin.000001       #       Begin_load_query        #       #       ;file_id=#;block_len=#
130
129
master-bin.000001       #       Execute_load_query      #       #       use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t2` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`) ;file_id=#
131
130
master-bin.000001       #       Query   #       #       COMMIT
132
131
master-bin.000001       #       Query   #       #       use `test`; alter table t1 add b int
163
162
insert into t1 values(2);
164
163
rollback;
165
164
set autocommit=1;
166
 
show binlog events;
167
 
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
168
 
master-bin.000001       #       Format_desc     #       #       Server ver: VERSION, Binlog ver: 4
169
 
master-bin.000001       #       Query   #       #       use `test`; create table t1 (a int) engine=blackhole
170
 
master-bin.000001       #       Query   #       #       BEGIN
171
 
master-bin.000001       #       Query   #       #       use `test`; insert into t1 values(1)
172
 
master-bin.000001       #       Query   #       #       COMMIT
173
165
drop table if exists t1;
174
166
reset master;
175
167
create table t1 (a int auto_increment, primary key (a)) engine=blackhole;