Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_log.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 include/stop_slave.inc
5 include/wait_for_slave_to_stop.inc
6 reset master;
7 reset slave;
8 start slave;
9 include/wait_for_slave_to_start.inc
10 connection slave;
11 set @save_slave_ddl_exec_mode=@@global.slave_ddl_exec_mode;
12 set @@global.slave_ddl_exec_mode=STRICT;
13 connection master;
14 create table t1(n int not null auto_increment primary key)ENGINE=MyISAM;
15 insert into t1 values (NULL);
16 drop table t1;
17 create table t1 (word char(20) not null)ENGINE=MyISAM;
18 load data infile 'LOAD_FILE' into table t1 ignore 1 lines;
19 select count(*) from t1;
20 count(*)
21 69
22 include/show_binlog_events.inc
23 Log_name Pos Event_type Server_id End_log_pos Info
24 master-bin.000001 # Gtid # # GTID #-#-#
25 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
26 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
27 master-bin.000001 # Annotate_rows # # insert into t1 values (NULL)
28 master-bin.000001 # Table_map # # table_id: # (test.t1)
29 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
30 master-bin.000001 # Query # # COMMIT
31 master-bin.000001 # Gtid # # GTID #-#-#
32 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
33 master-bin.000001 # Gtid # # GTID #-#-#
34 master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
35 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
36 master-bin.000001 # Annotate_rows # # load data infile '../../std_data/words.dat' into table t1 ignore 1 lines
37 master-bin.000001 # Table_map # # table_id: # (test.t1)
38 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
39 master-bin.000001 # Query # # COMMIT
40 include/show_binlog_events.inc
41 Log_name Pos Event_type Server_id End_log_pos Info
42 master-bin.000001 # Gtid # # GTID #-#-#
43 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
44 include/show_binlog_events.inc
45 Log_name Pos Event_type Server_id End_log_pos Info
46 master-bin.000001 # Gtid # # GTID #-#-#
47 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
48 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
49 include/show_binlog_events.inc
50 Log_name Pos Event_type Server_id End_log_pos Info
51 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
52 master-bin.000001 # Annotate_rows # # insert into t1 values (NULL)
53 master-bin.000001 # Table_map # # table_id: # (test.t1)
54 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
55 master-bin.000001 # Query # # COMMIT
56 flush logs;
57 create table t3 (a int)ENGINE=MyISAM;
58 connection master;
59 select * from t1 order by 1 asc;
60 word
61 Aarhus
62 Aaron
63 Aaron
64 Ababa
65 Ababa
66 aback
67 aback
68 abaft
69 abaft
70 abandon
71 abandon
72 abandoned
73 abandoned
74 abandoning
75 abandoning
76 abandonment
77 abandonment
78 abandons
79 abandons
80 abase
81 abased
82 abasement
83 abasements
84 abases
85 abash
86 abashed
87 abashes
88 abashing
89 abasing
90 abate
91 abated
92 abatement
93 abatements
94 abater
95 abates
96 abating
97 Abba
98 abbe
99 abbey
100 abbeys
101 abbot
102 abbots
103 Abbott
104 abbreviate
105 abbreviated
106 abbreviates
107 abbreviating
108 abbreviation
109 abbreviations
110 Abby
111 abdomen
112 abdomens
113 abdominal
114 abduct
115 abducted
116 abduction
117 abductions
118 abductor
119 abductors
120 abducts
121 Abe
122 abed
123 Abel
124 Abelian
125 Abelson
126 Aberdeen
127 Abernathy
128 aberrant
129 aberration
130 connection slave;
131 select * from t1 order by 1 asc;
132 word
133 Aarhus
134 Aaron
135 Aaron
136 Ababa
137 Ababa
138 aback
139 aback
140 abaft
141 abaft
142 abandon
143 abandon
144 abandoned
145 abandoned
146 abandoning
147 abandoning
148 abandonment
149 abandonment
150 abandons
151 abandons
152 abase
153 abased
154 abasement
155 abasements
156 abases
157 abash
158 abashed
159 abashes
160 abashing
161 abasing
162 abate
163 abated
164 abatement
165 abatements
166 abater
167 abates
168 abating
169 Abba
170 abbe
171 abbey
172 abbeys
173 abbot
174 abbots
175 Abbott
176 abbreviate
177 abbreviated
178 abbreviates
179 abbreviating
180 abbreviation
181 abbreviations
182 Abby
183 abdomen
184 abdomens
185 abdominal
186 abduct
187 abducted
188 abduction
189 abductions
190 abductor
191 abductors
192 abducts
193 Abe
194 abed
195 Abel
196 Abelian
197 Abelson
198 Aberdeen
199 Abernathy
200 aberrant
201 aberration
202 flush logs;
203 include/stop_slave.inc
204 include/start_slave.inc
205 connection master;
206 create table t2 (n int)ENGINE=MyISAM;
207 insert into t2 values (1);
208 include/show_binlog_events.inc
209 Log_name Pos Event_type Server_id End_log_pos Info
210 master-bin.000001 # Gtid # # GTID #-#-#
211 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
212 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
213 master-bin.000001 # Annotate_rows # # insert into t1 values (NULL)
214 master-bin.000001 # Table_map # # table_id: # (test.t1)
215 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
216 master-bin.000001 # Query # # COMMIT
217 master-bin.000001 # Gtid # # GTID #-#-#
218 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
219 master-bin.000001 # Gtid # # GTID #-#-#
220 master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
221 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
222 master-bin.000001 # Annotate_rows # # load data infile '../../std_data/words.dat' into table t1 ignore 1 lines
223 master-bin.000001 # Table_map # # table_id: # (test.t1)
224 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
225 master-bin.000001 # Query # # COMMIT
226 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
227 include/show_binlog_events.inc
228 Log_name Pos Event_type Server_id End_log_pos Info
229 master-bin.000002 # Gtid # # GTID #-#-#
230 master-bin.000002 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
231 master-bin.000002 # Gtid # # GTID #-#-#
232 master-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
233 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
234 master-bin.000002 # Annotate_rows # # insert into t2 values (1)
235 master-bin.000002 # Table_map # # table_id: # (test.t2)
236 master-bin.000002 # Write_rows_v1 # # table_id: # flags: STMT_END_F
237 master-bin.000002 # Query # # COMMIT
238 show binary logs;
239 Log_name File_size
240 master-bin.000001 #
241 master-bin.000002 #
242 connection slave;
243 show binary logs;
244 Log_name File_size
245 slave-bin.000001 #
246 slave-bin.000002 #
247 include/show_binlog_events.inc
248 Log_name Pos Event_type Server_id End_log_pos Info
249 slave-bin.000001 # Gtid # # GTID #-#-#
250 slave-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
251 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
252 slave-bin.000001 # Annotate_rows # # insert into t1 values (NULL)
253 slave-bin.000001 # Table_map # # table_id: # (test.t1)
254 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
255 slave-bin.000001 # Query # # COMMIT
256 slave-bin.000001 # Gtid # # GTID #-#-#
257 slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
258 slave-bin.000001 # Gtid # # GTID #-#-#
259 slave-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
260 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
261 slave-bin.000001 # Annotate_rows # # load data infile '../../std_data/words.dat' into table t1 ignore 1 lines
262 slave-bin.000001 # Table_map # # table_id: # (test.t1)
263 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
264 slave-bin.000001 # Query # # COMMIT
265 slave-bin.000001 # Gtid # # GTID #-#-#
266 slave-bin.000001 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
267 slave-bin.000001 # Rotate # # slave-bin.000002;pos=POS
268 include/show_binlog_events.inc
269 Log_name Pos Event_type Server_id End_log_pos Info
270 slave-bin.000002 # Gtid # # GTID #-#-#
271 slave-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
272 slave-bin.000002 # Gtid # # BEGIN GTID #-#-#
273 slave-bin.000002 # Annotate_rows # # insert into t2 values (1)
274 slave-bin.000002 # Table_map # # table_id: # (test.t2)
275 slave-bin.000002 # Write_rows_v1 # # table_id: # flags: STMT_END_F
276 slave-bin.000002 # Query # # COMMIT
277 include/check_slave_is_running.inc
278 show binlog events in 'slave-bin.000005' from 4;
279 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
280 connection master;
281 DROP TABLE t1;
282 DROP TABLE t2;
283 DROP TABLE t3;
284 include/rpl_reset.inc
285 connection master;
286 create table t1(a int auto_increment primary key, b int);
287 insert into t1 values (NULL, 1);
288 set insert_id=5;
289 insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
290 include/show_binlog_events.inc
291 Log_name Pos Event_type Server_id End_log_pos Info
292 master-bin.000001 # Gtid # # GTID #-#-#
293 master-bin.000001 # Query # # use `test`; create table t1(a int auto_increment primary key, b int)
294 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
295 master-bin.000001 # Annotate_rows # # insert into t1 values (NULL, 1)
296 master-bin.000001 # Table_map # # table_id: # (test.t1)
297 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
298 master-bin.000001 # Query # # COMMIT
299 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
300 master-bin.000001 # Annotate_rows # # insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id())
301 master-bin.000001 # Table_map # # table_id: # (test.t1)
302 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
303 master-bin.000001 # Query # # COMMIT
304 select * from t1;
305 a b
306 1 1
307 5 1
308 6 1
309 drop table t1;
310 connection slave;
311 set @@global.slave_ddl_exec_mode=@save_slave_ddl_exec_mode;
312 connection master;
313 include/rpl_end.inc