Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_row_ignorable_event.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 # Test non-transaction
7 create table t1(a int, b int) engine= myisam;
8 insert into t1(a,b) values(1,1),(2,1);
9 update t1 set a = a + 5 where b = 1 LIMIT 1;
10 delete from t1 where a = 6;
11 # Test transaction
12 create table t2(a int, b int) engine=innodb;
13 begin;
14 insert into t2(a,b) values(2,1),(3,1);
15 update t2 set a = a + 5 where b = 1;
16 delete from t2 where a = 7;
17 commit;
18 # Test mixed transaction
19 begin;
20 insert into t1(a,b) values(1,5);
21 insert into t2(a,b) values(2,5);
22 insert into t2(a,b) values(2,6);
23 insert into t1(a,b) values(1,7);
24 commit;
25 drop table t1, t2;
26 create table t3(a int, b int) engine= myisam;
27 create table t4(a int, b int) engine= myisam;
28 create table t5(a int, b int) engine= myisam;
29 insert into t3(a, b) values(1,1);
30 # Test the Rows_query log event will be filtered out if slave applys
31 # '--replicate-ignore-table' option on the table
32 insert into t4(a, b) values(2,1);
33 # Test the Rows_query log event will be relayed if slave
34 # filters out part Rows event from a rows statement
35 update t3,t4 set t3.a=3, t4.a=4 where t3.b=t4.b;
36 # Test the Rows_query log event will be filtered out if slave applys
37 # '--replicate-wild-ignore-table' option on the table
38 insert into t5(a, b) values(3,1);
39 # Test the Rows_query log event will be filtered out if slave filters
40 # out all its related tables by replication filtering rules
41 update t4,t5 set t4.a=4, t5.a=5 where t4.b=t5.b;
42 FLUSH TABLES;
43 # Test load data infile
44 create table t6(a VARCHAR(60)) engine= myisam;
45 load data infile '../../std_data/words.dat' into table t6;
46 drop table t3, t6;
47 drop table t4, t5;
48 # SHOW BINLOG EVENTS ON MASTER before '--exec MYSQL_BINLOG'
49 include/show_binlog_events.inc
50 Log_name Pos Event_type Server_id End_log_pos Info
51 master-bin.000001 # Query # # use `test`; create table t1(a int, b int) engine= myisam
52 master-bin.000001 # Query # # BEGIN
53 master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,1),(2,1)
54 master-bin.000001 # Table_map # # table_id: # (test.t1)
55 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
56 master-bin.000001 # Query # # COMMIT
57 master-bin.000001 # Query # # BEGIN
58 master-bin.000001 # Rows_query # # # update t1 set a = a + 5 where b = 1 LIMIT 1
59 master-bin.000001 # Table_map # # table_id: # (test.t1)
60 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
61 master-bin.000001 # Query # # COMMIT
62 master-bin.000001 # Query # # BEGIN
63 master-bin.000001 # Rows_query # # # delete from t1 where a = 6
64 master-bin.000001 # Table_map # # table_id: # (test.t1)
65 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
66 master-bin.000001 # Query # # COMMIT
67 master-bin.000001 # Query # # use `test`; create table t2(a int, b int) engine=innodb
68 master-bin.000001 # Query # # BEGIN
69 master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,1),(3,1)
70 master-bin.000001 # Table_map # # table_id: # (test.t2)
71 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
72 master-bin.000001 # Rows_query # # # update t2 set a = a + 5 where b = 1
73 master-bin.000001 # Table_map # # table_id: # (test.t2)
74 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
75 master-bin.000001 # Rows_query # # # delete from t2 where a = 7
76 master-bin.000001 # Table_map # # table_id: # (test.t2)
77 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
78 master-bin.000001 # Xid # # COMMIT /* XID */
79 master-bin.000001 # Query # # BEGIN
80 master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,5)
81 master-bin.000001 # Table_map # # table_id: # (test.t1)
82 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
83 master-bin.000001 # Query # # COMMIT
84 master-bin.000001 # Query # # BEGIN
85 master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,7)
86 master-bin.000001 # Table_map # # table_id: # (test.t1)
87 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
88 master-bin.000001 # Query # # COMMIT
89 master-bin.000001 # Query # # BEGIN
90 master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,5)
91 master-bin.000001 # Table_map # # table_id: # (test.t2)
92 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
93 master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,6)
94 master-bin.000001 # Table_map # # table_id: # (test.t2)
95 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
96 master-bin.000001 # Xid # # COMMIT /* XID */
97 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
98 master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */
99 master-bin.000001 # Query # # use `test`; create table t3(a int, b int) engine= myisam
100 master-bin.000001 # Query # # use `test`; create table t4(a int, b int) engine= myisam
101 master-bin.000001 # Query # # use `test`; create table t5(a int, b int) engine= myisam
102 master-bin.000001 # Query # # BEGIN
103 master-bin.000001 # Rows_query # # # insert into t3(a, b) values(1,1)
104 master-bin.000001 # Table_map # # table_id: # (test.t3)
105 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
106 master-bin.000001 # Query # # COMMIT
107 master-bin.000001 # Query # # BEGIN
108 master-bin.000001 # Rows_query # # # insert into t4(a, b) values(2,1)
109 master-bin.000001 # Table_map # # table_id: # (test.t4)
110 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
111 master-bin.000001 # Query # # COMMIT
112 master-bin.000001 # Query # # BEGIN
113 master-bin.000001 # Rows_query # # # update t3,t4 set t3.a=3, t4.a=4 where t3.b=t4.b
114 master-bin.000001 # Table_map # # table_id: # (test.t3)
115 master-bin.000001 # Table_map # # table_id: # (test.t4)
116 master-bin.000001 # Update_rows # # table_id: #
117 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
118 master-bin.000001 # Query # # COMMIT
119 master-bin.000001 # Query # # BEGIN
120 master-bin.000001 # Rows_query # # # insert into t5(a, b) values(3,1)
121 master-bin.000001 # Table_map # # table_id: # (test.t5)
122 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
123 master-bin.000001 # Query # # COMMIT
124 master-bin.000001 # Query # # BEGIN
125 master-bin.000001 # Rows_query # # # update t4,t5 set t4.a=4, t5.a=5 where t4.b=t5.b
126 master-bin.000001 # Table_map # # table_id: # (test.t4)
127 master-bin.000001 # Table_map # # table_id: # (test.t5)
128 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
129 master-bin.000001 # Query # # COMMIT
130 master-bin.000001 # Query # # use `test`; FLUSH TABLES
131 master-bin.000001 # Query # # use `test`; create table t6(a VARCHAR(60)) engine= myisam
132 master-bin.000001 # Query # # BEGIN
133 master-bin.000001 # Rows_query # # # load data infile '../../std_data/words.dat' into table t6
134 master-bin.000001 # Table_map # # table_id: # (test.t6)
135 master-bin.000001 # Write_rows # # table_id: #
136 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
137 master-bin.000001 # Query # # COMMIT
138 master-bin.000001 # Query # # use `test`; DROP TABLE `t3` /* generated by server */
139 master-bin.000001 # Query # # use `test`; DROP TABLE `t6` /* generated by server */
140 master-bin.000001 # Query # # use `test`; DROP TABLE `t4` /* generated by server */
141 master-bin.000001 # Query # # use `test`; DROP TABLE `t5` /* generated by server */
142 FLUSH LOGS;
143 RESET MASTER;
144 # MYSQL_BINLOG output based on a saved copy of master-bin.000001
145 include/mysqlbinlog.inc
146 # The proper term is pseudo_replica_mode, but we use this compatibility alias
147 # to make the statement usable on server versions 8.0.24 and older.
148 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
149 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
150 DELIMITER /*!*/;
151 # at #
152 # # server id # end_log_pos # CRC32 # Start: binlog v #, server v # created # at startup
153 ROLLBACK/*!*/;
154 # at #
155 # # server id # end_log_pos # CRC32 # Previous-GTIDs
156 # [empty]
157 # at #
158 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
159 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
160 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
161 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
162 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
163 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
164 SET @@SESSION.GTID_NEXT= '#'/*!*/;
165 # at #
166 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
167 use `test`/*!*/;
168 SET TIMESTAMP=#/*!*/;
169 SET @@session.pseudo_thread_id=#/*!*/;
170 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
171 SET @@session.sql_mode=1168113696/*!*/;
172 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
173 /*!\C utf8mb4 *//*!*/;
174 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
175 SET @@session.lc_time_names=0/*!*/;
176 SET @@session.collation_database=DEFAULT/*!*/;
177 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
178 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
179 create table t1(a int, b int) engine= myisam
180 /*!*/;
181 # at #
182 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
183 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
184 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
185 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
186 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
187 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
188 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
189 SET @@SESSION.GTID_NEXT= '#'/*!*/;
190 # at #
191 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
192 SET TIMESTAMP=#/*!*/;
193 BEGIN
194 /*!*/;
195 # at #
196 # # server id # end_log_pos # CRC32 # Rows_query
197 # insert into t1(a,b) values(1,1),(2,1)
198 # at #
199 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
200 # has_generated_invisible_primary_key=0
201 # at #
202 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
203 ### INSERT INTO `test`.`t1`
204 ### SET
205 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
206 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
207 ### INSERT INTO `test`.`t1`
208 ### SET
209 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
210 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
211 # at #
212 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
213 SET TIMESTAMP=#/*!*/;
214 COMMIT
215 /*!*/;
216 # at #
217 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
218 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
219 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
220 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
221 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
222 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
223 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
224 SET @@SESSION.GTID_NEXT= '#'/*!*/;
225 # at #
226 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
227 SET TIMESTAMP=#/*!*/;
228 BEGIN
229 /*!*/;
230 # at #
231 # # server id # end_log_pos # CRC32 # Rows_query
232 # update t1 set a = a + 5 where b = 1 LIMIT 1
233 # at #
234 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
235 # has_generated_invisible_primary_key=0
236 # at #
237 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
238 ### UPDATE `test`.`t1`
239 ### WHERE
240 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
241 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
242 ### SET
243 ### @1=6 /* INT meta=0 nullable=1 is_null=0 */
244 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
245 # at #
246 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
247 SET TIMESTAMP=#/*!*/;
248 COMMIT
249 /*!*/;
250 # at #
251 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
252 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
253 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
254 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
255 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
256 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
257 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
258 SET @@SESSION.GTID_NEXT= '#'/*!*/;
259 # at #
260 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
261 SET TIMESTAMP=#/*!*/;
262 BEGIN
263 /*!*/;
264 # at #
265 # # server id # end_log_pos # CRC32 # Rows_query
266 # delete from t1 where a = 6
267 # at #
268 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
269 # has_generated_invisible_primary_key=0
270 # at #
271 # # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F
272 ### DELETE FROM `test`.`t1`
273 ### WHERE
274 ### @1=6 /* INT meta=0 nullable=1 is_null=0 */
275 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
276 # at #
277 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
278 SET TIMESTAMP=#/*!*/;
279 COMMIT
280 /*!*/;
281 # at #
282 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
283 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
284 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
285 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
286 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
287 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
288 SET @@SESSION.GTID_NEXT= '#'/*!*/;
289 # at #
290 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
291 SET TIMESTAMP=#/*!*/;
292 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
293 create table t2(a int, b int) engine=innodb
294 /*!*/;
295 # at #
296 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
297 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
298 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
299 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
300 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
301 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
302 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
303 SET @@SESSION.GTID_NEXT= '#'/*!*/;
304 # at #
305 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
306 SET TIMESTAMP=#/*!*/;
307 BEGIN
308 /*!*/;
309 # at #
310 # # server id # end_log_pos # CRC32 # Rows_query
311 # insert into t2(a,b) values(2,1),(3,1)
312 # at #
313 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
314 # has_generated_invisible_primary_key=0
315 # at #
316 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
317 ### INSERT INTO `test`.`t2`
318 ### SET
319 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
320 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
321 ### INSERT INTO `test`.`t2`
322 ### SET
323 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
324 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
325 # at #
326 # # server id # end_log_pos # CRC32 # Rows_query
327 # update t2 set a = a + 5 where b = 1
328 # at #
329 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
330 # has_generated_invisible_primary_key=0
331 # at #
332 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
333 ### UPDATE `test`.`t2`
334 ### WHERE
335 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
336 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
337 ### SET
338 ### @1=7 /* INT meta=0 nullable=1 is_null=0 */
339 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
340 ### UPDATE `test`.`t2`
341 ### WHERE
342 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
343 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
344 ### SET
345 ### @1=8 /* INT meta=0 nullable=1 is_null=0 */
346 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
347 # at #
348 # # server id # end_log_pos # CRC32 # Rows_query
349 # delete from t2 where a = 7
350 # at #
351 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
352 # has_generated_invisible_primary_key=0
353 # at #
354 # # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F
355 ### DELETE FROM `test`.`t2`
356 ### WHERE
357 ### @1=7 /* INT meta=0 nullable=1 is_null=0 */
358 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
359 # at #
360 # # server id # end_log_pos # CRC32 # Xid = #
361 COMMIT/*!*/;
362 # at #
363 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
364 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
365 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
366 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
367 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
368 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
369 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
370 SET @@SESSION.GTID_NEXT= '#'/*!*/;
371 # at #
372 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
373 SET TIMESTAMP=#/*!*/;
374 BEGIN
375 /*!*/;
376 # at #
377 # # server id # end_log_pos # CRC32 # Rows_query
378 # insert into t1(a,b) values(1,5)
379 # at #
380 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
381 # has_generated_invisible_primary_key=0
382 # at #
383 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
384 ### INSERT INTO `test`.`t1`
385 ### SET
386 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
387 ### @2=5 /* INT meta=0 nullable=1 is_null=0 */
388 # at #
389 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
390 SET TIMESTAMP=#/*!*/;
391 COMMIT
392 /*!*/;
393 # at #
394 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
395 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
396 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
397 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
398 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
399 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
400 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
401 SET @@SESSION.GTID_NEXT= '#'/*!*/;
402 # at #
403 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
404 SET TIMESTAMP=#/*!*/;
405 BEGIN
406 /*!*/;
407 # at #
408 # # server id # end_log_pos # CRC32 # Rows_query
409 # insert into t1(a,b) values(1,7)
410 # at #
411 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
412 # has_generated_invisible_primary_key=0
413 # at #
414 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
415 ### INSERT INTO `test`.`t1`
416 ### SET
417 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
418 ### @2=7 /* INT meta=0 nullable=1 is_null=0 */
419 # at #
420 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
421 SET TIMESTAMP=#/*!*/;
422 COMMIT
423 /*!*/;
424 # at #
425 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
426 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
427 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
428 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
429 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
430 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
431 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
432 SET @@SESSION.GTID_NEXT= '#'/*!*/;
433 # at #
434 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
435 SET TIMESTAMP=#/*!*/;
436 BEGIN
437 /*!*/;
438 # at #
439 # # server id # end_log_pos # CRC32 # Rows_query
440 # insert into t2(a,b) values(2,5)
441 # at #
442 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
443 # has_generated_invisible_primary_key=0
444 # at #
445 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
446 ### INSERT INTO `test`.`t2`
447 ### SET
448 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
449 ### @2=5 /* INT meta=0 nullable=1 is_null=0 */
450 # at #
451 # # server id # end_log_pos # CRC32 # Rows_query
452 # insert into t2(a,b) values(2,6)
453 # at #
454 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
455 # has_generated_invisible_primary_key=0
456 # at #
457 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
458 ### INSERT INTO `test`.`t2`
459 ### SET
460 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
461 ### @2=6 /* INT meta=0 nullable=1 is_null=0 */
462 # at #
463 # # server id # end_log_pos # CRC32 # Xid = #
464 COMMIT/*!*/;
465 # at #
466 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
467 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
468 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
469 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
470 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
471 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
472 SET @@SESSION.GTID_NEXT= '#'/*!*/;
473 # at #
474 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
475 SET TIMESTAMP=#/*!*/;
476 DROP TABLE `t1` /* generated by server */
477 /*!*/;
478 # at #
479 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
480 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
481 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
482 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
483 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
484 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
485 SET @@SESSION.GTID_NEXT= '#'/*!*/;
486 # at #
487 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
488 SET TIMESTAMP=#/*!*/;
489 DROP TABLE `t2` /* generated by server */
490 /*!*/;
491 # at #
492 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
493 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
494 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
495 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
496 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
497 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
498 SET @@SESSION.GTID_NEXT= '#'/*!*/;
499 # at #
500 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
501 SET TIMESTAMP=#/*!*/;
502 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
503 create table t3(a int, b int) engine= myisam
504 /*!*/;
505 # at #
506 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
507 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
508 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
509 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
510 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
511 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
512 SET @@SESSION.GTID_NEXT= '#'/*!*/;
513 # at #
514 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
515 SET TIMESTAMP=#/*!*/;
516 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
517 create table t4(a int, b int) engine= myisam
518 /*!*/;
519 # at #
520 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
521 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
522 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
523 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
524 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
525 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
526 SET @@SESSION.GTID_NEXT= '#'/*!*/;
527 # at #
528 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
529 SET TIMESTAMP=#/*!*/;
530 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
531 create table t5(a int, b int) engine= myisam
532 /*!*/;
533 # at #
534 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
535 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
536 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
537 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
538 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
539 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
540 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
541 SET @@SESSION.GTID_NEXT= '#'/*!*/;
542 # at #
543 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
544 SET TIMESTAMP=#/*!*/;
545 BEGIN
546 /*!*/;
547 # at #
548 # # server id # end_log_pos # CRC32 # Rows_query
549 # insert into t3(a, b) values(1,1)
550 # at #
551 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t3` mapped to number #
552 # has_generated_invisible_primary_key=0
553 # at #
554 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
555 ### INSERT INTO `test`.`t3`
556 ### SET
557 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
558 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
559 # at #
560 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
561 SET TIMESTAMP=#/*!*/;
562 COMMIT
563 /*!*/;
564 # at #
565 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
566 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
567 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
568 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
569 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
570 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
571 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
572 SET @@SESSION.GTID_NEXT= '#'/*!*/;
573 # at #
574 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
575 SET TIMESTAMP=#/*!*/;
576 BEGIN
577 /*!*/;
578 # at #
579 # # server id # end_log_pos # CRC32 # Rows_query
580 # insert into t4(a, b) values(2,1)
581 # at #
582 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t4` mapped to number #
583 # has_generated_invisible_primary_key=0
584 # at #
585 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
586 ### INSERT INTO `test`.`t4`
587 ### SET
588 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
589 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
590 # at #
591 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
592 SET TIMESTAMP=#/*!*/;
593 COMMIT
594 /*!*/;
595 # at #
596 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
597 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
598 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
599 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
600 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
601 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
602 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
603 SET @@SESSION.GTID_NEXT= '#'/*!*/;
604 # at #
605 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
606 SET TIMESTAMP=#/*!*/;
607 BEGIN
608 /*!*/;
609 # at #
610 # # server id # end_log_pos # CRC32 # Rows_query
611 # update t3,t4 set t3.a=3, t4.a=4 where t3.b=t4.b
612 # at #
613 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t3` mapped to number #
614 # has_generated_invisible_primary_key=0
615 # at #
616 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t4` mapped to number #
617 # has_generated_invisible_primary_key=0
618 # at #
619 # # server id # end_log_pos # CRC32 # Update_rows: table id #
620 # at #
621 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
622 ### UPDATE `test`.`t3`
623 ### WHERE
624 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
625 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
626 ### SET
627 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
628 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
629 ### UPDATE `test`.`t4`
630 ### WHERE
631 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
632 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
633 ### SET
634 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
635 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
636 # at #
637 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
638 SET TIMESTAMP=#/*!*/;
639 COMMIT
640 /*!*/;
641 # at #
642 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
643 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
644 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
645 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
646 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
647 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
648 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
649 SET @@SESSION.GTID_NEXT= '#'/*!*/;
650 # at #
651 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
652 SET TIMESTAMP=#/*!*/;
653 BEGIN
654 /*!*/;
655 # at #
656 # # server id # end_log_pos # CRC32 # Rows_query
657 # insert into t5(a, b) values(3,1)
658 # at #
659 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t5` mapped to number #
660 # has_generated_invisible_primary_key=0
661 # at #
662 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
663 ### INSERT INTO `test`.`t5`
664 ### SET
665 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
666 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
667 # at #
668 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
669 SET TIMESTAMP=#/*!*/;
670 COMMIT
671 /*!*/;
672 # at #
673 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
674 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
675 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
676 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
677 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
678 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
679 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
680 SET @@SESSION.GTID_NEXT= '#'/*!*/;
681 # at #
682 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
683 SET TIMESTAMP=#/*!*/;
684 BEGIN
685 /*!*/;
686 # at #
687 # # server id # end_log_pos # CRC32 # Rows_query
688 # update t4,t5 set t4.a=4, t5.a=5 where t4.b=t5.b
689 # at #
690 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t4` mapped to number #
691 # has_generated_invisible_primary_key=0
692 # at #
693 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t5` mapped to number #
694 # has_generated_invisible_primary_key=0
695 # at #
696 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
697 ### UPDATE `test`.`t5`
698 ### WHERE
699 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
700 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
701 ### SET
702 ### @1=5 /* INT meta=0 nullable=1 is_null=0 */
703 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
704 # at #
705 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
706 SET TIMESTAMP=#/*!*/;
707 COMMIT
708 /*!*/;
709 # at #
710 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
711 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
712 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
713 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
714 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
715 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
716 SET @@SESSION.GTID_NEXT= '#'/*!*/;
717 # at #
718 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
719 SET TIMESTAMP=#/*!*/;
720 FLUSH TABLES
721 /*!*/;
722 # at #
723 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
724 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
725 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
726 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
727 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
728 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
729 SET @@SESSION.GTID_NEXT= '#'/*!*/;
730 # at #
731 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
732 SET TIMESTAMP=#/*!*/;
733 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
734 create table t6(a VARCHAR(60)) engine= myisam
735 /*!*/;
736 # at #
737 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
738 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
739 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
740 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
741 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
742 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
743 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
744 SET @@SESSION.GTID_NEXT= '#'/*!*/;
745 # at #
746 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
747 SET TIMESTAMP=#/*!*/;
748 BEGIN
749 /*!*/;
750 # at #
751 # # server id # end_log_pos # CRC32 # Rows_query
752 # load data infile '../../std_data/words.dat' into table t6
753 # at #
754 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t6` mapped to number #
755 # has_generated_invisible_primary_key=0
756 # at #
757 # # server id # end_log_pos # CRC32 # Write_rows: table id #
758 # at #
759 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
760 ### INSERT INTO `test`.`t6`
761 ### SET
762 ### @1='Aarhus' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
763 ### INSERT INTO `test`.`t6`
764 ### SET
765 ### @1='Aaron' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
766 ### INSERT INTO `test`.`t6`
767 ### SET
768 ### @1='Ababa' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
769 ### INSERT INTO `test`.`t6`
770 ### SET
771 ### @1='aback' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
772 ### INSERT INTO `test`.`t6`
773 ### SET
774 ### @1='abaft' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
775 ### INSERT INTO `test`.`t6`
776 ### SET
777 ### @1='abandon' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
778 ### INSERT INTO `test`.`t6`
779 ### SET
780 ### @1='abandoned' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
781 ### INSERT INTO `test`.`t6`
782 ### SET
783 ### @1='abandoning' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
784 ### INSERT INTO `test`.`t6`
785 ### SET
786 ### @1='abandonment' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
787 ### INSERT INTO `test`.`t6`
788 ### SET
789 ### @1='abandons' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
790 ### INSERT INTO `test`.`t6`
791 ### SET
792 ### @1='Aarhus' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
793 ### INSERT INTO `test`.`t6`
794 ### SET
795 ### @1='Aaron' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
796 ### INSERT INTO `test`.`t6`
797 ### SET
798 ### @1='Ababa' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
799 ### INSERT INTO `test`.`t6`
800 ### SET
801 ### @1='aback' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
802 ### INSERT INTO `test`.`t6`
803 ### SET
804 ### @1='abaft' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
805 ### INSERT INTO `test`.`t6`
806 ### SET
807 ### @1='abandon' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
808 ### INSERT INTO `test`.`t6`
809 ### SET
810 ### @1='abandoned' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
811 ### INSERT INTO `test`.`t6`
812 ### SET
813 ### @1='abandoning' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
814 ### INSERT INTO `test`.`t6`
815 ### SET
816 ### @1='abandonment' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
817 ### INSERT INTO `test`.`t6`
818 ### SET
819 ### @1='abandons' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
820 ### INSERT INTO `test`.`t6`
821 ### SET
822 ### @1='abase' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
823 ### INSERT INTO `test`.`t6`
824 ### SET
825 ### @1='abased' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
826 ### INSERT INTO `test`.`t6`
827 ### SET
828 ### @1='abasement' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
829 ### INSERT INTO `test`.`t6`
830 ### SET
831 ### @1='abasements' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
832 ### INSERT INTO `test`.`t6`
833 ### SET
834 ### @1='abases' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
835 ### INSERT INTO `test`.`t6`
836 ### SET
837 ### @1='abash' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
838 ### INSERT INTO `test`.`t6`
839 ### SET
840 ### @1='abashed' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
841 ### INSERT INTO `test`.`t6`
842 ### SET
843 ### @1='abashes' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
844 ### INSERT INTO `test`.`t6`
845 ### SET
846 ### @1='abashing' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
847 ### INSERT INTO `test`.`t6`
848 ### SET
849 ### @1='abasing' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
850 ### INSERT INTO `test`.`t6`
851 ### SET
852 ### @1='abate' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
853 ### INSERT INTO `test`.`t6`
854 ### SET
855 ### @1='abated' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
856 ### INSERT INTO `test`.`t6`
857 ### SET
858 ### @1='abatement' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
859 ### INSERT INTO `test`.`t6`
860 ### SET
861 ### @1='abatements' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
862 ### INSERT INTO `test`.`t6`
863 ### SET
864 ### @1='abater' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
865 ### INSERT INTO `test`.`t6`
866 ### SET
867 ### @1='abates' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
868 ### INSERT INTO `test`.`t6`
869 ### SET
870 ### @1='abating' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
871 ### INSERT INTO `test`.`t6`
872 ### SET
873 ### @1='Abba' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
874 ### INSERT INTO `test`.`t6`
875 ### SET
876 ### @1='abbe' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
877 ### INSERT INTO `test`.`t6`
878 ### SET
879 ### @1='abbey' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
880 ### INSERT INTO `test`.`t6`
881 ### SET
882 ### @1='abbeys' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
883 ### INSERT INTO `test`.`t6`
884 ### SET
885 ### @1='abbot' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
886 ### INSERT INTO `test`.`t6`
887 ### SET
888 ### @1='abbots' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
889 ### INSERT INTO `test`.`t6`
890 ### SET
891 ### @1='Abbott' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
892 ### INSERT INTO `test`.`t6`
893 ### SET
894 ### @1='abbreviate' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
895 ### INSERT INTO `test`.`t6`
896 ### SET
897 ### @1='abbreviated' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
898 ### INSERT INTO `test`.`t6`
899 ### SET
900 ### @1='abbreviates' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
901 ### INSERT INTO `test`.`t6`
902 ### SET
903 ### @1='abbreviating' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
904 ### INSERT INTO `test`.`t6`
905 ### SET
906 ### @1='abbreviation' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
907 ### INSERT INTO `test`.`t6`
908 ### SET
909 ### @1='abbreviations' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
910 ### INSERT INTO `test`.`t6`
911 ### SET
912 ### @1='Abby' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
913 ### INSERT INTO `test`.`t6`
914 ### SET
915 ### @1='abdomen' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
916 ### INSERT INTO `test`.`t6`
917 ### SET
918 ### @1='abdomens' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
919 ### INSERT INTO `test`.`t6`
920 ### SET
921 ### @1='abdominal' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
922 ### INSERT INTO `test`.`t6`
923 ### SET
924 ### @1='abduct' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
925 ### INSERT INTO `test`.`t6`
926 ### SET
927 ### @1='abducted' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
928 ### INSERT INTO `test`.`t6`
929 ### SET
930 ### @1='abduction' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
931 ### INSERT INTO `test`.`t6`
932 ### SET
933 ### @1='abductions' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
934 ### INSERT INTO `test`.`t6`
935 ### SET
936 ### @1='abductor' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
937 ### INSERT INTO `test`.`t6`
938 ### SET
939 ### @1='abductors' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
940 ### INSERT INTO `test`.`t6`
941 ### SET
942 ### @1='abducts' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
943 ### INSERT INTO `test`.`t6`
944 ### SET
945 ### @1='Abe' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
946 ### INSERT INTO `test`.`t6`
947 ### SET
948 ### @1='abed' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
949 ### INSERT INTO `test`.`t6`
950 ### SET
951 ### @1='Abel' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
952 ### INSERT INTO `test`.`t6`
953 ### SET
954 ### @1='Abelian' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
955 ### INSERT INTO `test`.`t6`
956 ### SET
957 ### @1='Abelson' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
958 ### INSERT INTO `test`.`t6`
959 ### SET
960 ### @1='Aberdeen' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
961 ### INSERT INTO `test`.`t6`
962 ### SET
963 ### @1='Abernathy' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
964 ### INSERT INTO `test`.`t6`
965 ### SET
966 ### @1='aberrant' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
967 ### INSERT INTO `test`.`t6`
968 ### SET
969 ### @1='aberration' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */
970 # at #
971 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
972 SET TIMESTAMP=#/*!*/;
973 COMMIT
974 /*!*/;
975 # at #
976 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
977 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
978 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
979 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
980 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
981 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
982 SET @@SESSION.GTID_NEXT= '#'/*!*/;
983 # at #
984 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
985 SET TIMESTAMP=#/*!*/;
986 DROP TABLE `t3` /* generated by server */
987 /*!*/;
988 # at #
989 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
990 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
991 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
992 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
993 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
994 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
995 SET @@SESSION.GTID_NEXT= '#'/*!*/;
996 # at #
997 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
998 SET TIMESTAMP=#/*!*/;
999 DROP TABLE `t6` /* generated by server */
1000 /*!*/;
1001 # at #
1002 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
1003 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1004 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1005 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1006 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1007 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1008 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1009 # at #
1010 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
1011 SET TIMESTAMP=#/*!*/;
1012 DROP TABLE `t4` /* generated by server */
1013 /*!*/;
1014 # at #
1015 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
1016 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1017 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1018 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1019 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1020 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1021 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1022 # at #
1023 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
1024 SET TIMESTAMP=#/*!*/;
1025 DROP TABLE `t5` /* generated by server */
1026 /*!*/;
1027 # at #
1028 # # server id # end_log_pos # CRC32 # Rotate to master-bin.000002 pos: 4
1029 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1030 DELIMITER ;
1031 # End of log file
1032 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1033 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1034 # Test the Rows_query log event can be applied
1035 # SHOW BINLOG EVENTS ON MASTER after '--exec MYSQL_BINLOG'
1036 include/show_binlog_events.inc
1037 Log_name Pos Event_type Server_id End_log_pos Info
1038 master-bin.000001 # Query # # use `test`; create table t1(a int, b int) engine= myisam
1039 master-bin.000001 # Query # # BEGIN
1040 master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,1),(2,1)
1041 master-bin.000001 # Table_map # # table_id: # (test.t1)
1042 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1043 master-bin.000001 # Query # # COMMIT
1044 master-bin.000001 # Query # # BEGIN
1045 master-bin.000001 # Rows_query # # # update t1 set a = a + 5 where b = 1 LIMIT 1
1046 master-bin.000001 # Table_map # # table_id: # (test.t1)
1047 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
1048 master-bin.000001 # Query # # COMMIT
1049 master-bin.000001 # Query # # BEGIN
1050 master-bin.000001 # Rows_query # # # delete from t1 where a = 6
1051 master-bin.000001 # Table_map # # table_id: # (test.t1)
1052 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1053 master-bin.000001 # Query # # COMMIT
1054 master-bin.000001 # Query # # use `test`; create table t2(a int, b int) engine=innodb
1055 master-bin.000001 # Query # # BEGIN
1056 master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,1),(3,1)
1057 master-bin.000001 # Table_map # # table_id: # (test.t2)
1058 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1059 master-bin.000001 # Rows_query # # # update t2 set a = a + 5 where b = 1
1060 master-bin.000001 # Table_map # # table_id: # (test.t2)
1061 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
1062 master-bin.000001 # Rows_query # # # delete from t2 where a = 7
1063 master-bin.000001 # Table_map # # table_id: # (test.t2)
1064 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1065 master-bin.000001 # Xid # # COMMIT /* XID */
1066 master-bin.000001 # Query # # BEGIN
1067 master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,5)
1068 master-bin.000001 # Table_map # # table_id: # (test.t1)
1069 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1070 master-bin.000001 # Query # # COMMIT
1071 master-bin.000001 # Query # # BEGIN
1072 master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,7)
1073 master-bin.000001 # Table_map # # table_id: # (test.t1)
1074 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1075 master-bin.000001 # Query # # COMMIT
1076 master-bin.000001 # Query # # BEGIN
1077 master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,5)
1078 master-bin.000001 # Table_map # # table_id: # (test.t2)
1079 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1080 master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,6)
1081 master-bin.000001 # Table_map # # table_id: # (test.t2)
1082 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1083 master-bin.000001 # Xid # # COMMIT /* XID */
1084 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
1085 master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */
1086 # SHOW BINLOG EVENTS ON 2nd CONNECTION TO MASTE
1087 set @@session.binlog_rows_query_log_events= off;
1088 # Test statements from the 2nd connection have no comment event
1089 # when setting binlog_rows_query_log_events= off
1090 create table t7(a bigint) engine= myisam;
1091 insert into t7(a) values(1),(2);
1092 delete from t7 where a = 1;
1093 set session binlog_format=mixed;
1094 Warnings:
1095 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1096 set @@session.binlog_rows_query_log_events= on;
1097 # Test the comment event is sent in mixed mode for special
1098 # functions when setting binlog_rows_query_log_events= on
1099 insert into t7(a) values(UUID_SHORT());
1100 drop table t7;
1101 include/show_binlog_events.inc
1102 Log_name Pos Event_type Server_id End_log_pos Info
1103 master-bin.000001 # Query # # use `test`; create table t7(a bigint) engine= myisam
1104 master-bin.000001 # Query # # BEGIN
1105 master-bin.000001 # Table_map # # table_id: # (test.t7)
1106 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1107 master-bin.000001 # Query # # COMMIT
1108 master-bin.000001 # Query # # BEGIN
1109 master-bin.000001 # Table_map # # table_id: # (test.t7)
1110 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1111 master-bin.000001 # Query # # COMMIT
1112 master-bin.000001 # Query # # BEGIN
1113 master-bin.000001 # Rows_query # # # insert into t7(a) values(UUID_SHORT())
1114 master-bin.000001 # Table_map # # table_id: # (test.t7)
1115 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1116 master-bin.000001 # Query # # COMMIT
1117 master-bin.000001 # Query # # use `test`; DROP TABLE `t7` /* generated by server */
1118 include/start_slave.inc
1119 include/sync_slave_sql_with_master.inc
1120 # Test The Rows_query log event can be relayed.
1121 # SHOW BINLOG EVENTS ON SLAVE
1122 include/show_binlog_events.inc
1123 Log_name Pos Event_type Server_id End_log_pos Info
1124 slave-bin.000001 # Query # # use `test`; create table t1(a int, b int) engine= myisam
1125 slave-bin.000001 # Query # # BEGIN
1126 slave-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,1),(2,1)
1127 slave-bin.000001 # Table_map # # table_id: # (test.t1)
1128 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1129 slave-bin.000001 # Query # # COMMIT
1130 slave-bin.000001 # Query # # BEGIN
1131 slave-bin.000001 # Rows_query # # # update t1 set a = a + 5 where b = 1 LIMIT 1
1132 slave-bin.000001 # Table_map # # table_id: # (test.t1)
1133 slave-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
1134 slave-bin.000001 # Query # # COMMIT
1135 slave-bin.000001 # Query # # BEGIN
1136 slave-bin.000001 # Rows_query # # # delete from t1 where a = 6
1137 slave-bin.000001 # Table_map # # table_id: # (test.t1)
1138 slave-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1139 slave-bin.000001 # Query # # COMMIT
1140 slave-bin.000001 # Query # # use `test`; create table t2(a int, b int) engine=innodb
1141 slave-bin.000001 # Query # # BEGIN
1142 slave-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,1),(3,1)
1143 slave-bin.000001 # Table_map # # table_id: # (test.t2)
1144 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1145 slave-bin.000001 # Rows_query # # # update t2 set a = a + 5 where b = 1
1146 slave-bin.000001 # Table_map # # table_id: # (test.t2)
1147 slave-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
1148 slave-bin.000001 # Rows_query # # # delete from t2 where a = 7
1149 slave-bin.000001 # Table_map # # table_id: # (test.t2)
1150 slave-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1151 slave-bin.000001 # Xid # # COMMIT /* XID */
1152 slave-bin.000001 # Query # # BEGIN
1153 slave-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,5)
1154 slave-bin.000001 # Table_map # # table_id: # (test.t1)
1155 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1156 slave-bin.000001 # Query # # COMMIT
1157 slave-bin.000001 # Query # # BEGIN
1158 slave-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,7)
1159 slave-bin.000001 # Table_map # # table_id: # (test.t1)
1160 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1161 slave-bin.000001 # Query # # COMMIT
1162 slave-bin.000001 # Query # # BEGIN
1163 slave-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,5)
1164 slave-bin.000001 # Table_map # # table_id: # (test.t2)
1165 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1166 slave-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,6)
1167 slave-bin.000001 # Table_map # # table_id: # (test.t2)
1168 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1169 slave-bin.000001 # Xid # # COMMIT /* XID */
1170 slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
1171 slave-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */
1172 slave-bin.000001 # Query # # use `test`; create table t7(a bigint) engine= myisam
1173 slave-bin.000001 # Query # # BEGIN
1174 slave-bin.000001 # Table_map # # table_id: # (test.t7)
1175 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1176 slave-bin.000001 # Query # # COMMIT
1177 slave-bin.000001 # Query # # BEGIN
1178 slave-bin.000001 # Table_map # # table_id: # (test.t7)
1179 slave-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1180 slave-bin.000001 # Query # # COMMIT
1181 slave-bin.000001 # Query # # BEGIN
1182 slave-bin.000001 # Rows_query # # # insert into t7(a) values(UUID_SHORT())
1183 slave-bin.000001 # Table_map # # table_id: # (test.t7)
1184 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1185 slave-bin.000001 # Query # # COMMIT
1186 slave-bin.000001 # Query # # use `test`; DROP TABLE `t7` /* generated by server */
1187 include/rpl_end.inc