Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 SET timestamp=1000000000;
4 RESET MASTER;
5 connection slave;
6 SET timestamp=1000000000;
7 RESET MASTER;
8 connection master;
9 CREATE TABLE t1 (a INT, b INT, c INT);
10 CREATE TABLE t2 (a INT, b INT, c INT);
11 connection slave;
12 ALTER TABLE t1 ENGINE=BLACKHOLE;
13 connection master;
14 INSERT INTO t2 VALUES (1,9,1), (2,9,2), (3,9,3), (4,9,4);
15 connection slave;
16 connection master;
17 INSERT INTO t1 VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4);
18 connection slave;
19 # Expect 0
20 SELECT COUNT(*) FROM t1;
21 COUNT(*)
22 0
23 >>> Something was written to binary log <<<
24 connection master;
25 UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 1;
26 connection slave;
27 # Expect 0
28 SELECT COUNT(*) FROM t1;
29 COUNT(*)
30 0
31 >>> Something was written to binary log <<<
32 connection master;
33 DELETE FROM t1 WHERE a % 2 = 0 AND b = 1;
34 connection slave;
35 # Expect 0
36 SELECT COUNT(*) FROM t1;
37 COUNT(*)
38 0
39 >>> Something was written to binary log <<<
40 connection master;
41 INSERT INTO t1 SELECT * FROM t2;
42 connection slave;
43 # Expect 0
44 SELECT COUNT(*) FROM t1;
45 COUNT(*)
46 0
47 >>> Something was written to binary log <<<
48 connection master;
49 ALTER TABLE t1 ADD PRIMARY KEY pk_t1 (a,b);
50 Warnings:
51 Warning 1280 Name 'pk_t1' ignored for PRIMARY key.
52 connection slave;
53 connection master;
54 INSERT INTO t1 VALUES (1,2,1),(2,2,2),(3,2,3),(4,2,4);
55 connection slave;
56 # Expect 0
57 SELECT COUNT(*) FROM t1;
58 COUNT(*)
59 0
60 >>> Something was written to binary log <<<
61 connection master;
62 UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 2;
63 connection slave;
64 # Expect 0
65 SELECT COUNT(*) FROM t1;
66 COUNT(*)
67 0
68 >>> Something was written to binary log <<<
69 connection master;
70 DELETE FROM t1 WHERE a % 2 = 0 AND b = 2;
71 connection slave;
72 # Expect 0
73 SELECT COUNT(*) FROM t1;
74 COUNT(*)
75 0
76 >>> Something was written to binary log <<<
77 connection master;
78 ALTER TABLE t1 DROP PRIMARY KEY, ADD KEY key_t1 (a);
79 connection slave;
80 connection master;
81 INSERT INTO t1 VALUES (1,3,1),(2,3,2),(3,3,3),(4,3,4);
82 connection slave;
83 # Expect 0
84 SELECT COUNT(*) FROM t1;
85 COUNT(*)
86 0
87 >>> Something was written to binary log <<<
88 connection master;
89 UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 3;
90 connection slave;
91 # Expect 0
92 SELECT COUNT(*) FROM t1;
93 COUNT(*)
94 0
95 >>> Something was written to binary log <<<
96 connection master;
97 DELETE FROM t1 WHERE a % 2 = 0 AND b = 3;
98 connection slave;
99 # Expect 0
100 SELECT COUNT(*) FROM t1;
101 COUNT(*)
102 0
103 >>> Something was written to binary log <<<
104 connection master;
105 DROP TABLE t1,t2;
106 connection slave;
107 connection slave;
108 FLUSH LOGS;
109 show binlog events in 'slave-bin.000001' from <start_pos>;
110 Log_name Pos Event_type Server_id End_log_pos Info
111 slave-bin.000001 # Gtid_list 2 # []
112 slave-bin.000001 # Binlog_checkpoint 2 # slave-bin.000001
113 slave-bin.000001 # Gtid 1 # GTID 0-1-1
114 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE t1 (a INT, b INT, c INT)
115 slave-bin.000001 # Gtid 1 # GTID 0-1-2
116 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE t2 (a INT, b INT, c INT)
117 slave-bin.000001 # Gtid 2 # GTID 0-2-3
118 slave-bin.000001 # Query 2 # use `test`; ALTER TABLE t1 ENGINE=BLACKHOLE
119 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-3
120 slave-bin.000001 # Annotate_rows 1 # INSERT INTO t2 VALUES (1,9,1), (2,9,2), (3,9,3), (4,9,4)
121 slave-bin.000001 # Table_map 1 # table_id: # (test.t2)
122 slave-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
123 slave-bin.000001 # Query 1 # COMMIT
124 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-4
125 slave-bin.000001 # Annotate_rows 1 # INSERT INTO t1 VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4)
126 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
127 slave-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
128 slave-bin.000001 # Query 1 # COMMIT
129 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-5
130 slave-bin.000001 # Annotate_rows 1 # UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 1
131 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
132 slave-bin.000001 # Update_rows_v1 1 # table_id: # flags: STMT_END_F
133 slave-bin.000001 # Query 1 # COMMIT
134 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-6
135 slave-bin.000001 # Annotate_rows 1 # DELETE FROM t1 WHERE a % 2 = 0 AND b = 1
136 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
137 slave-bin.000001 # Delete_rows_v1 1 # table_id: # flags: STMT_END_F
138 slave-bin.000001 # Query 1 # COMMIT
139 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-7
140 slave-bin.000001 # Annotate_rows 1 # INSERT INTO t1 SELECT * FROM t2
141 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
142 slave-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
143 slave-bin.000001 # Query 1 # COMMIT
144 slave-bin.000001 # Gtid 1 # GTID 0-1-8
145 slave-bin.000001 # Query 1 # use `test`; ALTER TABLE t1 ADD PRIMARY KEY pk_t1 (a,b)
146 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-9
147 slave-bin.000001 # Annotate_rows 1 # INSERT INTO t1 VALUES (1,2,1),(2,2,2),(3,2,3),(4,2,4)
148 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
149 slave-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
150 slave-bin.000001 # Query 1 # COMMIT
151 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-10
152 slave-bin.000001 # Annotate_rows 1 # UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 2
153 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
154 slave-bin.000001 # Update_rows_v1 1 # table_id: # flags: STMT_END_F
155 slave-bin.000001 # Query 1 # COMMIT
156 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-11
157 slave-bin.000001 # Annotate_rows 1 # DELETE FROM t1 WHERE a % 2 = 0 AND b = 2
158 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
159 slave-bin.000001 # Delete_rows_v1 1 # table_id: # flags: STMT_END_F
160 slave-bin.000001 # Query 1 # COMMIT
161 slave-bin.000001 # Gtid 1 # GTID 0-1-12
162 slave-bin.000001 # Query 1 # use `test`; ALTER TABLE t1 DROP PRIMARY KEY, ADD KEY key_t1 (a)
163 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-13
164 slave-bin.000001 # Annotate_rows 1 # INSERT INTO t1 VALUES (1,3,1),(2,3,2),(3,3,3),(4,3,4)
165 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
166 slave-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
167 slave-bin.000001 # Query 1 # COMMIT
168 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-14
169 slave-bin.000001 # Annotate_rows 1 # UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 3
170 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
171 slave-bin.000001 # Update_rows_v1 1 # table_id: # flags: STMT_END_F
172 slave-bin.000001 # Query 1 # COMMIT
173 slave-bin.000001 # Gtid 1 # BEGIN GTID 0-1-15
174 slave-bin.000001 # Annotate_rows 1 # DELETE FROM t1 WHERE a % 2 = 0 AND b = 3
175 slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
176 slave-bin.000001 # Delete_rows_v1 1 # table_id: # flags: STMT_END_F
177 slave-bin.000001 # Query 1 # COMMIT
178 slave-bin.000001 # Gtid 1 # GTID 0-1-16
179 slave-bin.000001 # Query 1 # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by server */
180 slave-bin.000001 # Rotate 2 # slave-bin.000002;pos=4
181 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
182 /*!40019 SET @@session.max_delayed_threads=0*/;
183 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
184 DELIMITER /*!*/;
185 # at #
186 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
187 ROLLBACK/*!*/;
188 # at #
189 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Gtid list []
190 # at #
191 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Binlog checkpoint slave-bin.000001
192 # at #
193 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-1 ddl thread_id=#
194 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
195 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
196 /*M!100001 SET @@session.server_id=1*//*!*/;
197 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
198 # at #
199 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
200 use `test`/*!*/;
201 SET TIMESTAMP=1000000000/*!*/;
202 SET @@session.pseudo_thread_id=#/*!*/;
203 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/;
204 SET @@session.sql_mode=1411383296/*!*/;
205 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
206 /*!\C latin1 *//*!*/;
207 SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=2304/*!*/;
208 SET @@session.lc_time_names=0/*!*/;
209 SET @@session.collation_database=DEFAULT/*!*/;
210 CREATE TABLE t1 (a INT, b INT, c INT)
211 /*!*/;
212 # at #
213 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-2 ddl thread_id=#
214 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
215 # at #
216 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
217 SET TIMESTAMP=1000000000/*!*/;
218 CREATE TABLE t2 (a INT, b INT, c INT)
219 /*!*/;
220 # at #
221 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-2-3 ddl thread_id=#
222 /*M!100001 SET @@session.server_id=2*//*!*/;
223 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
224 # at #
225 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
226 SET TIMESTAMP=1000000000/*!*/;
227 ALTER TABLE t1 ENGINE=BLACKHOLE
228 /*!*/;
229 # at #
230 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-3 trans thread_id=#
231 /*M!100001 SET @@session.server_id=1*//*!*/;
232 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
233 START TRANSACTION
234 /*!*/;
235 # at #
236 # at #
237 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
238 #Q> INSERT INTO t2 VALUES (1,9,1), (2,9,2), (3,9,3), (4,9,4)
239 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t2` mapped to number #
240 # at #
241 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
242 # Number of rows: 4
243 # at #
244 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
245 SET TIMESTAMP=1000000000/*!*/;
246 COMMIT
247 /*!*/;
248 # at #
249 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-4 trans thread_id=#
250 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
251 START TRANSACTION
252 /*!*/;
253 # at #
254 # at #
255 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
256 #Q> INSERT INTO t1 VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4)
257 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
258 # at #
259 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
260 # Number of rows: 4
261 # at #
262 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
263 SET TIMESTAMP=1000000000/*!*/;
264 COMMIT
265 /*!*/;
266 # at #
267 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-5 trans thread_id=#
268 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
269 START TRANSACTION
270 /*!*/;
271 # at #
272 # at #
273 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
274 #Q> UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 1
275 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
276 # at #
277 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Update_rows: table id # flags: STMT_END_F
278 # Number of rows: 2
279 # at #
280 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
281 SET TIMESTAMP=1000000000/*!*/;
282 COMMIT
283 /*!*/;
284 # at #
285 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-6 trans thread_id=#
286 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
287 START TRANSACTION
288 /*!*/;
289 # at #
290 # at #
291 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
292 #Q> DELETE FROM t1 WHERE a % 2 = 0 AND b = 1
293 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
294 # at #
295 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Delete_rows: table id # flags: STMT_END_F
296 # Number of rows: 2
297 # at #
298 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
299 SET TIMESTAMP=1000000000/*!*/;
300 COMMIT
301 /*!*/;
302 # at #
303 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-7 trans thread_id=#
304 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
305 START TRANSACTION
306 /*!*/;
307 # at #
308 # at #
309 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
310 #Q> INSERT INTO t1 SELECT * FROM t2
311 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
312 # at #
313 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
314 # Number of rows: 4
315 # at #
316 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
317 SET TIMESTAMP=1000000000/*!*/;
318 COMMIT
319 /*!*/;
320 # at #
321 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-8 ddl thread_id=#
322 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
323 # at #
324 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
325 SET TIMESTAMP=1000000000/*!*/;
326 ALTER TABLE t1 ADD PRIMARY KEY pk_t1 (a,b)
327 /*!*/;
328 # at #
329 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-9 trans thread_id=#
330 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
331 START TRANSACTION
332 /*!*/;
333 # at #
334 # at #
335 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
336 #Q> INSERT INTO t1 VALUES (1,2,1),(2,2,2),(3,2,3),(4,2,4)
337 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
338 # at #
339 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
340 # Number of rows: 4
341 # at #
342 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
343 SET TIMESTAMP=1000000000/*!*/;
344 COMMIT
345 /*!*/;
346 # at #
347 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-10 trans thread_id=#
348 /*M!100001 SET @@session.gtid_seq_no=10*//*!*/;
349 START TRANSACTION
350 /*!*/;
351 # at #
352 # at #
353 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
354 #Q> UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 2
355 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
356 # at #
357 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Update_rows: table id # flags: STMT_END_F
358 # Number of rows: 2
359 # at #
360 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
361 SET TIMESTAMP=1000000000/*!*/;
362 COMMIT
363 /*!*/;
364 # at #
365 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-11 trans thread_id=#
366 /*M!100001 SET @@session.gtid_seq_no=11*//*!*/;
367 START TRANSACTION
368 /*!*/;
369 # at #
370 # at #
371 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
372 #Q> DELETE FROM t1 WHERE a % 2 = 0 AND b = 2
373 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
374 # at #
375 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Delete_rows: table id # flags: STMT_END_F
376 # Number of rows: 2
377 # at #
378 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
379 SET TIMESTAMP=1000000000/*!*/;
380 COMMIT
381 /*!*/;
382 # at #
383 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-12 ddl thread_id=#
384 /*M!100001 SET @@session.gtid_seq_no=12*//*!*/;
385 # at #
386 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
387 SET TIMESTAMP=1000000000/*!*/;
388 ALTER TABLE t1 DROP PRIMARY KEY, ADD KEY key_t1 (a)
389 /*!*/;
390 # at #
391 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-13 trans thread_id=#
392 /*M!100001 SET @@session.gtid_seq_no=13*//*!*/;
393 START TRANSACTION
394 /*!*/;
395 # at #
396 # at #
397 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
398 #Q> INSERT INTO t1 VALUES (1,3,1),(2,3,2),(3,3,3),(4,3,4)
399 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
400 # at #
401 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
402 # Number of rows: 4
403 # at #
404 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
405 SET TIMESTAMP=1000000000/*!*/;
406 COMMIT
407 /*!*/;
408 # at #
409 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-14 trans thread_id=#
410 /*M!100001 SET @@session.gtid_seq_no=14*//*!*/;
411 START TRANSACTION
412 /*!*/;
413 # at #
414 # at #
415 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
416 #Q> UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 3
417 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
418 # at #
419 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Update_rows: table id # flags: STMT_END_F
420 # Number of rows: 2
421 # at #
422 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
423 SET TIMESTAMP=1000000000/*!*/;
424 COMMIT
425 /*!*/;
426 # at #
427 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-15 trans thread_id=#
428 /*M!100001 SET @@session.gtid_seq_no=15*//*!*/;
429 START TRANSACTION
430 /*!*/;
431 # at #
432 # at #
433 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
434 #Q> DELETE FROM t1 WHERE a % 2 = 0 AND b = 3
435 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test`.`t1` mapped to number #
436 # at #
437 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Delete_rows: table id # flags: STMT_END_F
438 # Number of rows: 2
439 # at #
440 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
441 SET TIMESTAMP=1000000000/*!*/;
442 COMMIT
443 /*!*/;
444 # at #
445 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-16 ddl thread_id=#
446 /*M!100001 SET @@session.gtid_seq_no=16*//*!*/;
447 # at #
448 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
449 SET TIMESTAMP=1000000000/*!*/;
450 DROP TABLE IF EXISTS `t1`,`t2` /* generated by server */
451 /*!*/;
452 # at #
453 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Rotate to slave-bin.000002 pos: 4
454 DELIMITER ;
455 # End of log file
456 ROLLBACK /* added by mysqlbinlog */;
457 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
458 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
459 include/rpl_end.inc