Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_mysqlbinlog_start_stop.result

raw
1 CREATE TABLE t1 (a INT);
2 RESET MASTER;
3 SET TIMESTAMP= UNIX_TIMESTAMP("2031-01-01 12:00:00");
4 INSERT INTO t1 VALUES(1);
5 SET TIMESTAMP= UNIX_TIMESTAMP("2032-01-01 12:00:00");
6 INSERT INTO t1 VALUES(2);
7 SET TIMESTAMP= UNIX_TIMESTAMP("2033-01-01 12:00:00");
8 INSERT INTO t1 VALUES(3);
9 FLUSH LOGS;
10 SET TIMESTAMP= UNIX_TIMESTAMP("2034-01-01 12:00:00");
11 INSERT INTO t1 VALUES(4);
12 SET TIMESTAMP= UNIX_TIMESTAMP("2035-01-01 12:00:00");
13 INSERT INTO t1 VALUES(5);
14 FLUSH LOGS;
15
16 ==== Local ====
17
18 ---- base64-output ----
19 include/mysqlbinlog.inc
20 # The proper term is pseudo_replica_mode, but we use this compatibility alias
21 # to make the statement usable on server versions 8.0.24 and older.
22 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
23 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
24 DELIMITER /*!*/;
25 ROLLBACK/*!*/;
26 # [empty]
27 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
28 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
29 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
30 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
31 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
32 SET @@SESSION.GTID_NEXT= '#'/*!*/;
33 SET TIMESTAMP=#/*!*/;
34 SET @@session.pseudo_thread_id=#/*!*/;
35 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
36 SET @@session.sql_mode=1168113696/*!*/;
37 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
38 /*!\C utf8mb4 *//*!*/;
39 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
40 SET @@session.lc_time_names=0/*!*/;
41 SET @@session.collation_database=DEFAULT/*!*/;
42 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
43 BEGIN
44 /*!*/;
45 use `test`/*!*/;
46 SET TIMESTAMP=#/*!*/;
47 INSERT INTO t1 VALUES(1)
48 /*!*/;
49 COMMIT/*!*/;
50 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
51 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
52 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
53 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
54 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
55 SET @@SESSION.GTID_NEXT= '#'/*!*/;
56 SET TIMESTAMP=#/*!*/;
57 BEGIN
58 /*!*/;
59 SET TIMESTAMP=#/*!*/;
60 INSERT INTO t1 VALUES(2)
61 /*!*/;
62 COMMIT/*!*/;
63 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
64 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
65 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
66 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
67 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
68 SET @@SESSION.GTID_NEXT= '#'/*!*/;
69 SET TIMESTAMP=#/*!*/;
70 BEGIN
71 /*!*/;
72 SET TIMESTAMP=#/*!*/;
73 INSERT INTO t1 VALUES(3)
74 /*!*/;
75 COMMIT/*!*/;
76 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
77 DELIMITER ;
78 # End of log file
79 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
80 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
81
82 ---- offset ----
83 include/mysqlbinlog.inc
84 # The proper term is pseudo_replica_mode, but we use this compatibility alias
85 # to make the statement usable on server versions 8.0.24 and older.
86 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
87 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
88 DELIMITER /*!*/;
89 ROLLBACK/*!*/;
90 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
91 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
92 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
93 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
94 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
95 SET @@SESSION.GTID_NEXT= '#'/*!*/;
96 SET TIMESTAMP=#/*!*/;
97 SET @@session.pseudo_thread_id=#/*!*/;
98 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
99 SET @@session.sql_mode=1168113696/*!*/;
100 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
101 /*!\C utf8mb4 *//*!*/;
102 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
103 SET @@session.lc_time_names=0/*!*/;
104 SET @@session.collation_database=DEFAULT/*!*/;
105 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
106 BEGIN
107 /*!*/;
108 use `test`/*!*/;
109 SET TIMESTAMP=#/*!*/;
110 INSERT INTO t1 VALUES(1)
111 /*!*/;
112 COMMIT/*!*/;
113 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
114 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
115 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
116 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
117 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
118 SET @@SESSION.GTID_NEXT= '#'/*!*/;
119 SET TIMESTAMP=#/*!*/;
120 BEGIN
121 /*!*/;
122 SET TIMESTAMP=#/*!*/;
123 INSERT INTO t1 VALUES(2)
124 /*!*/;
125 COMMIT/*!*/;
126 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
127 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
128 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
129 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
130 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
131 SET @@SESSION.GTID_NEXT= '#'/*!*/;
132 SET TIMESTAMP=#/*!*/;
133 BEGIN
134 /*!*/;
135 SET TIMESTAMP=#/*!*/;
136 INSERT INTO t1 VALUES(3)
137 /*!*/;
138 COMMIT/*!*/;
139 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
140 DELIMITER ;
141 # End of log file
142 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
143 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
144
145 ---- start-position ----
146 include/mysqlbinlog.inc
147 # The proper term is pseudo_replica_mode, but we use this compatibility alias
148 # to make the statement usable on server versions 8.0.24 and older.
149 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
150 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
151 DELIMITER /*!*/;
152 ROLLBACK/*!*/;
153 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
154 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
155 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
156 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
157 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
158 SET @@SESSION.GTID_NEXT= '#'/*!*/;
159 SET TIMESTAMP=#/*!*/;
160 SET @@session.pseudo_thread_id=#/*!*/;
161 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
162 SET @@session.sql_mode=1168113696/*!*/;
163 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
164 /*!\C utf8mb4 *//*!*/;
165 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
166 SET @@session.lc_time_names=0/*!*/;
167 SET @@session.collation_database=DEFAULT/*!*/;
168 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
169 BEGIN
170 /*!*/;
171 use `test`/*!*/;
172 SET TIMESTAMP=#/*!*/;
173 INSERT INTO t1 VALUES(2)
174 /*!*/;
175 COMMIT/*!*/;
176 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
177 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
178 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
179 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
180 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
181 SET @@SESSION.GTID_NEXT= '#'/*!*/;
182 SET TIMESTAMP=#/*!*/;
183 BEGIN
184 /*!*/;
185 SET TIMESTAMP=#/*!*/;
186 INSERT INTO t1 VALUES(3)
187 /*!*/;
188 COMMIT/*!*/;
189 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
190 DELIMITER ;
191 # End of log file
192 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
193 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
194
195 ---- stop-position ----
196 include/mysqlbinlog.inc
197 # The proper term is pseudo_replica_mode, but we use this compatibility alias
198 # to make the statement usable on server versions 8.0.24 and older.
199 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
200 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
201 DELIMITER /*!*/;
202 ROLLBACK/*!*/;
203 # [empty]
204 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
205 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
206 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
207 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
208 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
209 SET @@SESSION.GTID_NEXT= '#'/*!*/;
210 SET TIMESTAMP=#/*!*/;
211 SET @@session.pseudo_thread_id=#/*!*/;
212 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
213 SET @@session.sql_mode=1168113696/*!*/;
214 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
215 /*!\C utf8mb4 *//*!*/;
216 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
217 SET @@session.lc_time_names=0/*!*/;
218 SET @@session.collation_database=DEFAULT/*!*/;
219 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
220 BEGIN
221 /*!*/;
222 use `test`/*!*/;
223 SET TIMESTAMP=#/*!*/;
224 INSERT INTO t1 VALUES(1)
225 /*!*/;
226 COMMIT/*!*/;
227 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
228 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
229 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
230 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
231 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
232 SET @@SESSION.GTID_NEXT= '#'/*!*/;
233 SET TIMESTAMP=#/*!*/;
234 BEGIN
235 /*!*/;
236 SET TIMESTAMP=#/*!*/;
237 INSERT INTO t1 VALUES(2)
238 /*!*/;
239 COMMIT/*!*/;
240 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
241 DELIMITER ;
242 # End of log file
243 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
244 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
245
246 ---- start-position stop-position ----
247 include/mysqlbinlog.inc
248 # The proper term is pseudo_replica_mode, but we use this compatibility alias
249 # to make the statement usable on server versions 8.0.24 and older.
250 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
251 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
252 DELIMITER /*!*/;
253 ROLLBACK/*!*/;
254 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
255 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
256 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
257 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
258 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
259 SET @@SESSION.GTID_NEXT= '#'/*!*/;
260 SET TIMESTAMP=#/*!*/;
261 SET @@session.pseudo_thread_id=#/*!*/;
262 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
263 SET @@session.sql_mode=1168113696/*!*/;
264 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
265 /*!\C utf8mb4 *//*!*/;
266 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
267 SET @@session.lc_time_names=0/*!*/;
268 SET @@session.collation_database=DEFAULT/*!*/;
269 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
270 BEGIN
271 /*!*/;
272 use `test`/*!*/;
273 SET TIMESTAMP=#/*!*/;
274 INSERT INTO t1 VALUES(2)
275 /*!*/;
276 COMMIT/*!*/;
277 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
278 DELIMITER ;
279 # End of log file
280 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
281 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
282
283 ---- start-datetime ----
284 include/mysqlbinlog.inc
285 # The proper term is pseudo_replica_mode, but we use this compatibility alias
286 # to make the statement usable on server versions 8.0.24 and older.
287 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
288 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
289 DELIMITER /*!*/;
290 ROLLBACK/*!*/;
291 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
292 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
293 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
294 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
295 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
296 SET @@SESSION.GTID_NEXT= '#'/*!*/;
297 SET TIMESTAMP=#/*!*/;
298 SET @@session.pseudo_thread_id=#/*!*/;
299 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
300 SET @@session.sql_mode=1168113696/*!*/;
301 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
302 /*!\C utf8mb4 *//*!*/;
303 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
304 SET @@session.lc_time_names=0/*!*/;
305 SET @@session.collation_database=DEFAULT/*!*/;
306 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
307 BEGIN
308 /*!*/;
309 use `test`/*!*/;
310 SET TIMESTAMP=#/*!*/;
311 INSERT INTO t1 VALUES(1)
312 /*!*/;
313 COMMIT/*!*/;
314 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
315 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
316 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
317 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
318 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
319 SET @@SESSION.GTID_NEXT= '#'/*!*/;
320 SET TIMESTAMP=#/*!*/;
321 BEGIN
322 /*!*/;
323 SET TIMESTAMP=#/*!*/;
324 INSERT INTO t1 VALUES(2)
325 /*!*/;
326 COMMIT/*!*/;
327 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
328 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
329 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
330 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
331 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
332 SET @@SESSION.GTID_NEXT= '#'/*!*/;
333 SET TIMESTAMP=#/*!*/;
334 BEGIN
335 /*!*/;
336 SET TIMESTAMP=#/*!*/;
337 INSERT INTO t1 VALUES(3)
338 /*!*/;
339 COMMIT/*!*/;
340 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
341 DELIMITER ;
342 # End of log file
343 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
344 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
345
346 ---- stop-datetime ----
347 include/mysqlbinlog.inc
348 # The proper term is pseudo_replica_mode, but we use this compatibility alias
349 # to make the statement usable on server versions 8.0.24 and older.
350 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
351 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
352 DELIMITER /*!*/;
353 ROLLBACK/*!*/;
354 # [empty]
355 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
356 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
357 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
358 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
359 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
360 SET @@SESSION.GTID_NEXT= '#'/*!*/;
361 SET TIMESTAMP=#/*!*/;
362 SET @@session.pseudo_thread_id=#/*!*/;
363 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
364 SET @@session.sql_mode=1168113696/*!*/;
365 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
366 /*!\C utf8mb4 *//*!*/;
367 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
368 SET @@session.lc_time_names=0/*!*/;
369 SET @@session.collation_database=DEFAULT/*!*/;
370 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
371 BEGIN
372 /*!*/;
373 use `test`/*!*/;
374 SET TIMESTAMP=#/*!*/;
375 INSERT INTO t1 VALUES(1)
376 /*!*/;
377 COMMIT/*!*/;
378 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
379 DELIMITER ;
380 # End of log file
381 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
382 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
383
384 ---- start-datetime stop-datetime ----
385 include/mysqlbinlog.inc
386 # The proper term is pseudo_replica_mode, but we use this compatibility alias
387 # to make the statement usable on server versions 8.0.24 and older.
388 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
389 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
390 DELIMITER /*!*/;
391 ROLLBACK/*!*/;
392 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
393 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
394 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
395 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
396 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
397 SET @@SESSION.GTID_NEXT= '#'/*!*/;
398 SET TIMESTAMP=#/*!*/;
399 SET @@session.pseudo_thread_id=#/*!*/;
400 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
401 SET @@session.sql_mode=1168113696/*!*/;
402 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
403 /*!\C utf8mb4 *//*!*/;
404 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
405 SET @@session.lc_time_names=0/*!*/;
406 SET @@session.collation_database=DEFAULT/*!*/;
407 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
408 BEGIN
409 /*!*/;
410 use `test`/*!*/;
411 SET TIMESTAMP=#/*!*/;
412 INSERT INTO t1 VALUES(1)
413 /*!*/;
414 COMMIT/*!*/;
415 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
416 DELIMITER ;
417 # End of log file
418 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
419 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
420
421 ==== Local with 2 binlogs on command line ====
422
423 ---- base64-output ----
424 include/mysqlbinlog.inc
425 # The proper term is pseudo_replica_mode, but we use this compatibility alias
426 # to make the statement usable on server versions 8.0.24 and older.
427 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
428 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
429 DELIMITER /*!*/;
430 ROLLBACK/*!*/;
431 # [empty]
432 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
433 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
434 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
435 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
436 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
437 SET @@SESSION.GTID_NEXT= '#'/*!*/;
438 SET TIMESTAMP=#/*!*/;
439 SET @@session.pseudo_thread_id=#/*!*/;
440 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
441 SET @@session.sql_mode=1168113696/*!*/;
442 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
443 /*!\C utf8mb4 *//*!*/;
444 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
445 SET @@session.lc_time_names=0/*!*/;
446 SET @@session.collation_database=DEFAULT/*!*/;
447 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
448 BEGIN
449 /*!*/;
450 use `test`/*!*/;
451 SET TIMESTAMP=#/*!*/;
452 INSERT INTO t1 VALUES(1)
453 /*!*/;
454 COMMIT/*!*/;
455 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
456 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
457 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
458 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
459 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
460 SET @@SESSION.GTID_NEXT= '#'/*!*/;
461 SET TIMESTAMP=#/*!*/;
462 BEGIN
463 /*!*/;
464 SET TIMESTAMP=#/*!*/;
465 INSERT INTO t1 VALUES(2)
466 /*!*/;
467 COMMIT/*!*/;
468 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
469 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
470 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
471 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
472 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
473 SET @@SESSION.GTID_NEXT= '#'/*!*/;
474 SET TIMESTAMP=#/*!*/;
475 BEGIN
476 /*!*/;
477 SET TIMESTAMP=#/*!*/;
478 INSERT INTO t1 VALUES(3)
479 /*!*/;
480 COMMIT/*!*/;
481 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
482 # [empty]
483 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
484 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
485 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
486 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
487 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
488 SET @@SESSION.GTID_NEXT= '#'/*!*/;
489 SET TIMESTAMP=#/*!*/;
490 BEGIN
491 /*!*/;
492 SET TIMESTAMP=#/*!*/;
493 INSERT INTO t1 VALUES(4)
494 /*!*/;
495 COMMIT/*!*/;
496 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
497 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
498 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
499 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
500 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
501 SET @@SESSION.GTID_NEXT= '#'/*!*/;
502 SET TIMESTAMP=#/*!*/;
503 BEGIN
504 /*!*/;
505 SET TIMESTAMP=#/*!*/;
506 INSERT INTO t1 VALUES(5)
507 /*!*/;
508 COMMIT/*!*/;
509 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
510 DELIMITER ;
511 # End of log file
512 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
513 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
514
515 ---- offset ----
516 include/mysqlbinlog.inc
517 # The proper term is pseudo_replica_mode, but we use this compatibility alias
518 # to make the statement usable on server versions 8.0.24 and older.
519 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
520 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
521 DELIMITER /*!*/;
522 ROLLBACK/*!*/;
523 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
524 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
525 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
526 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
527 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
528 SET @@SESSION.GTID_NEXT= '#'/*!*/;
529 SET TIMESTAMP=#/*!*/;
530 SET @@session.pseudo_thread_id=#/*!*/;
531 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
532 SET @@session.sql_mode=1168113696/*!*/;
533 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
534 /*!\C utf8mb4 *//*!*/;
535 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
536 SET @@session.lc_time_names=0/*!*/;
537 SET @@session.collation_database=DEFAULT/*!*/;
538 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
539 BEGIN
540 /*!*/;
541 use `test`/*!*/;
542 SET TIMESTAMP=#/*!*/;
543 INSERT INTO t1 VALUES(1)
544 /*!*/;
545 COMMIT/*!*/;
546 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
547 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
548 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
549 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
550 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
551 SET @@SESSION.GTID_NEXT= '#'/*!*/;
552 SET TIMESTAMP=#/*!*/;
553 BEGIN
554 /*!*/;
555 SET TIMESTAMP=#/*!*/;
556 INSERT INTO t1 VALUES(2)
557 /*!*/;
558 COMMIT/*!*/;
559 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
560 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
561 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
562 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
563 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
564 SET @@SESSION.GTID_NEXT= '#'/*!*/;
565 SET TIMESTAMP=#/*!*/;
566 BEGIN
567 /*!*/;
568 SET TIMESTAMP=#/*!*/;
569 INSERT INTO t1 VALUES(3)
570 /*!*/;
571 COMMIT/*!*/;
572 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
573 # [empty]
574 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
575 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
576 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
577 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
578 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
579 SET @@SESSION.GTID_NEXT= '#'/*!*/;
580 SET TIMESTAMP=#/*!*/;
581 BEGIN
582 /*!*/;
583 SET TIMESTAMP=#/*!*/;
584 INSERT INTO t1 VALUES(4)
585 /*!*/;
586 COMMIT/*!*/;
587 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
588 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
589 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
590 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
591 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
592 SET @@SESSION.GTID_NEXT= '#'/*!*/;
593 SET TIMESTAMP=#/*!*/;
594 BEGIN
595 /*!*/;
596 SET TIMESTAMP=#/*!*/;
597 INSERT INTO t1 VALUES(5)
598 /*!*/;
599 COMMIT/*!*/;
600 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
601 DELIMITER ;
602 # End of log file
603 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
604 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
605
606 ---- start-position ----
607 include/mysqlbinlog.inc
608 # The proper term is pseudo_replica_mode, but we use this compatibility alias
609 # to make the statement usable on server versions 8.0.24 and older.
610 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
611 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
612 DELIMITER /*!*/;
613 ROLLBACK/*!*/;
614 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
615 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
616 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
617 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
618 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
619 SET @@SESSION.GTID_NEXT= '#'/*!*/;
620 SET TIMESTAMP=#/*!*/;
621 SET @@session.pseudo_thread_id=#/*!*/;
622 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
623 SET @@session.sql_mode=1168113696/*!*/;
624 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
625 /*!\C utf8mb4 *//*!*/;
626 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
627 SET @@session.lc_time_names=0/*!*/;
628 SET @@session.collation_database=DEFAULT/*!*/;
629 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
630 BEGIN
631 /*!*/;
632 use `test`/*!*/;
633 SET TIMESTAMP=#/*!*/;
634 INSERT INTO t1 VALUES(2)
635 /*!*/;
636 COMMIT/*!*/;
637 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
638 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
639 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
640 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
641 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
642 SET @@SESSION.GTID_NEXT= '#'/*!*/;
643 SET TIMESTAMP=#/*!*/;
644 BEGIN
645 /*!*/;
646 SET TIMESTAMP=#/*!*/;
647 INSERT INTO t1 VALUES(3)
648 /*!*/;
649 COMMIT/*!*/;
650 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
651 # [empty]
652 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
653 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
654 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
655 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
656 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
657 SET @@SESSION.GTID_NEXT= '#'/*!*/;
658 SET TIMESTAMP=#/*!*/;
659 BEGIN
660 /*!*/;
661 SET TIMESTAMP=#/*!*/;
662 INSERT INTO t1 VALUES(4)
663 /*!*/;
664 COMMIT/*!*/;
665 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
666 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
667 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
668 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
669 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
670 SET @@SESSION.GTID_NEXT= '#'/*!*/;
671 SET TIMESTAMP=#/*!*/;
672 BEGIN
673 /*!*/;
674 SET TIMESTAMP=#/*!*/;
675 INSERT INTO t1 VALUES(5)
676 /*!*/;
677 COMMIT/*!*/;
678 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
679 DELIMITER ;
680 # End of log file
681 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
682 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
683
684 ---- stop-position ----
685 include/mysqlbinlog.inc
686 # The proper term is pseudo_replica_mode, but we use this compatibility alias
687 # to make the statement usable on server versions 8.0.24 and older.
688 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
689 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
690 DELIMITER /*!*/;
691 ROLLBACK/*!*/;
692 # [empty]
693 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
694 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
695 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
696 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
697 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
698 SET @@SESSION.GTID_NEXT= '#'/*!*/;
699 SET TIMESTAMP=#/*!*/;
700 SET @@session.pseudo_thread_id=#/*!*/;
701 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
702 SET @@session.sql_mode=1168113696/*!*/;
703 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
704 /*!\C utf8mb4 *//*!*/;
705 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
706 SET @@session.lc_time_names=0/*!*/;
707 SET @@session.collation_database=DEFAULT/*!*/;
708 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
709 BEGIN
710 /*!*/;
711 use `test`/*!*/;
712 SET TIMESTAMP=#/*!*/;
713 INSERT INTO t1 VALUES(1)
714 /*!*/;
715 COMMIT/*!*/;
716 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
717 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
718 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
719 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
720 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
721 SET @@SESSION.GTID_NEXT= '#'/*!*/;
722 SET TIMESTAMP=#/*!*/;
723 BEGIN
724 /*!*/;
725 SET TIMESTAMP=#/*!*/;
726 INSERT INTO t1 VALUES(2)
727 /*!*/;
728 COMMIT/*!*/;
729 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
730 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
731 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
732 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
733 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
734 SET @@SESSION.GTID_NEXT= '#'/*!*/;
735 SET TIMESTAMP=#/*!*/;
736 BEGIN
737 /*!*/;
738 SET TIMESTAMP=#/*!*/;
739 INSERT INTO t1 VALUES(3)
740 /*!*/;
741 COMMIT/*!*/;
742 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
743 # [empty]
744 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
745 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
746 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
747 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
748 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
749 SET @@SESSION.GTID_NEXT= '#'/*!*/;
750 SET TIMESTAMP=#/*!*/;
751 BEGIN
752 /*!*/;
753 SET TIMESTAMP=#/*!*/;
754 INSERT INTO t1 VALUES(4)
755 /*!*/;
756 COMMIT/*!*/;
757 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
758 DELIMITER ;
759 # End of log file
760 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
761 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
762
763 ---- start-position stop-position ----
764 include/mysqlbinlog.inc
765 # The proper term is pseudo_replica_mode, but we use this compatibility alias
766 # to make the statement usable on server versions 8.0.24 and older.
767 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
768 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
769 DELIMITER /*!*/;
770 ROLLBACK/*!*/;
771 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
772 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
773 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
774 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
775 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
776 SET @@SESSION.GTID_NEXT= '#'/*!*/;
777 SET TIMESTAMP=#/*!*/;
778 SET @@session.pseudo_thread_id=#/*!*/;
779 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
780 SET @@session.sql_mode=1168113696/*!*/;
781 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
782 /*!\C utf8mb4 *//*!*/;
783 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
784 SET @@session.lc_time_names=0/*!*/;
785 SET @@session.collation_database=DEFAULT/*!*/;
786 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
787 BEGIN
788 /*!*/;
789 use `test`/*!*/;
790 SET TIMESTAMP=#/*!*/;
791 INSERT INTO t1 VALUES(2)
792 /*!*/;
793 COMMIT/*!*/;
794 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
795 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
796 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
797 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
798 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
799 SET @@SESSION.GTID_NEXT= '#'/*!*/;
800 SET TIMESTAMP=#/*!*/;
801 BEGIN
802 /*!*/;
803 SET TIMESTAMP=#/*!*/;
804 INSERT INTO t1 VALUES(3)
805 /*!*/;
806 COMMIT/*!*/;
807 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
808 # [empty]
809 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
810 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
811 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
812 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
813 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
814 SET @@SESSION.GTID_NEXT= '#'/*!*/;
815 SET TIMESTAMP=#/*!*/;
816 BEGIN
817 /*!*/;
818 SET TIMESTAMP=#/*!*/;
819 INSERT INTO t1 VALUES(4)
820 /*!*/;
821 COMMIT/*!*/;
822 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
823 DELIMITER ;
824 # End of log file
825 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
826 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
827
828 ---- start-datetime ----
829 include/mysqlbinlog.inc
830 # The proper term is pseudo_replica_mode, but we use this compatibility alias
831 # to make the statement usable on server versions 8.0.24 and older.
832 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
833 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
834 DELIMITER /*!*/;
835 ROLLBACK/*!*/;
836 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
837 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
838 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
839 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
840 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
841 SET @@SESSION.GTID_NEXT= '#'/*!*/;
842 SET TIMESTAMP=#/*!*/;
843 SET @@session.pseudo_thread_id=#/*!*/;
844 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
845 SET @@session.sql_mode=1168113696/*!*/;
846 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
847 /*!\C utf8mb4 *//*!*/;
848 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
849 SET @@session.lc_time_names=0/*!*/;
850 SET @@session.collation_database=DEFAULT/*!*/;
851 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
852 BEGIN
853 /*!*/;
854 use `test`/*!*/;
855 SET TIMESTAMP=#/*!*/;
856 INSERT INTO t1 VALUES(1)
857 /*!*/;
858 COMMIT/*!*/;
859 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
860 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
861 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
862 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
863 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
864 SET @@SESSION.GTID_NEXT= '#'/*!*/;
865 SET TIMESTAMP=#/*!*/;
866 BEGIN
867 /*!*/;
868 SET TIMESTAMP=#/*!*/;
869 INSERT INTO t1 VALUES(2)
870 /*!*/;
871 COMMIT/*!*/;
872 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
873 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
874 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
875 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
876 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
877 SET @@SESSION.GTID_NEXT= '#'/*!*/;
878 SET TIMESTAMP=#/*!*/;
879 BEGIN
880 /*!*/;
881 SET TIMESTAMP=#/*!*/;
882 INSERT INTO t1 VALUES(3)
883 /*!*/;
884 COMMIT/*!*/;
885 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
886 # [empty]
887 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
888 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
889 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
890 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
891 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
892 SET @@SESSION.GTID_NEXT= '#'/*!*/;
893 SET TIMESTAMP=#/*!*/;
894 BEGIN
895 /*!*/;
896 SET TIMESTAMP=#/*!*/;
897 INSERT INTO t1 VALUES(4)
898 /*!*/;
899 COMMIT/*!*/;
900 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
901 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
902 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
903 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
904 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
905 SET @@SESSION.GTID_NEXT= '#'/*!*/;
906 SET TIMESTAMP=#/*!*/;
907 BEGIN
908 /*!*/;
909 SET TIMESTAMP=#/*!*/;
910 INSERT INTO t1 VALUES(5)
911 /*!*/;
912 COMMIT/*!*/;
913 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
914 DELIMITER ;
915 # End of log file
916 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
917 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
918
919 ---- stop-datetime ----
920 include/mysqlbinlog.inc
921 # The proper term is pseudo_replica_mode, but we use this compatibility alias
922 # to make the statement usable on server versions 8.0.24 and older.
923 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
924 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
925 DELIMITER /*!*/;
926 ROLLBACK/*!*/;
927 # [empty]
928 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
929 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
930 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
931 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
932 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
933 SET @@SESSION.GTID_NEXT= '#'/*!*/;
934 SET TIMESTAMP=#/*!*/;
935 SET @@session.pseudo_thread_id=#/*!*/;
936 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
937 SET @@session.sql_mode=1168113696/*!*/;
938 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
939 /*!\C utf8mb4 *//*!*/;
940 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
941 SET @@session.lc_time_names=0/*!*/;
942 SET @@session.collation_database=DEFAULT/*!*/;
943 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
944 BEGIN
945 /*!*/;
946 use `test`/*!*/;
947 SET TIMESTAMP=#/*!*/;
948 INSERT INTO t1 VALUES(1)
949 /*!*/;
950 COMMIT/*!*/;
951 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
952 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
953 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
954 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
955 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
956 SET @@SESSION.GTID_NEXT= '#'/*!*/;
957 SET TIMESTAMP=#/*!*/;
958 BEGIN
959 /*!*/;
960 SET TIMESTAMP=#/*!*/;
961 INSERT INTO t1 VALUES(2)
962 /*!*/;
963 COMMIT/*!*/;
964 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
965 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
966 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
967 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
968 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
969 SET @@SESSION.GTID_NEXT= '#'/*!*/;
970 SET TIMESTAMP=#/*!*/;
971 BEGIN
972 /*!*/;
973 SET TIMESTAMP=#/*!*/;
974 INSERT INTO t1 VALUES(3)
975 /*!*/;
976 COMMIT/*!*/;
977 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
978 # [empty]
979 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
980 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
981 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
982 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
983 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
984 SET @@SESSION.GTID_NEXT= '#'/*!*/;
985 SET TIMESTAMP=#/*!*/;
986 BEGIN
987 /*!*/;
988 SET TIMESTAMP=#/*!*/;
989 INSERT INTO t1 VALUES(4)
990 /*!*/;
991 COMMIT/*!*/;
992 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
993 DELIMITER ;
994 # End of log file
995 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
996 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
997
998 ---- start-datetime stop-datetime ----
999 include/mysqlbinlog.inc
1000 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1001 # to make the statement usable on server versions 8.0.24 and older.
1002 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1003 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1004 DELIMITER /*!*/;
1005 ROLLBACK/*!*/;
1006 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1007 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1008 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1009 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1010 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1011 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1012 SET TIMESTAMP=#/*!*/;
1013 SET @@session.pseudo_thread_id=#/*!*/;
1014 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1015 SET @@session.sql_mode=1168113696/*!*/;
1016 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1017 /*!\C utf8mb4 *//*!*/;
1018 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1019 SET @@session.lc_time_names=0/*!*/;
1020 SET @@session.collation_database=DEFAULT/*!*/;
1021 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1022 BEGIN
1023 /*!*/;
1024 use `test`/*!*/;
1025 SET TIMESTAMP=#/*!*/;
1026 INSERT INTO t1 VALUES(1)
1027 /*!*/;
1028 COMMIT/*!*/;
1029 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1030 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1031 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1032 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1033 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1034 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1035 SET TIMESTAMP=#/*!*/;
1036 BEGIN
1037 /*!*/;
1038 SET TIMESTAMP=#/*!*/;
1039 INSERT INTO t1 VALUES(2)
1040 /*!*/;
1041 COMMIT/*!*/;
1042 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1043 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1044 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1045 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1046 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1047 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1048 SET TIMESTAMP=#/*!*/;
1049 BEGIN
1050 /*!*/;
1051 SET TIMESTAMP=#/*!*/;
1052 INSERT INTO t1 VALUES(3)
1053 /*!*/;
1054 COMMIT/*!*/;
1055 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1056 # [empty]
1057 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1058 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1059 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1060 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1061 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1062 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1063 SET TIMESTAMP=#/*!*/;
1064 BEGIN
1065 /*!*/;
1066 SET TIMESTAMP=#/*!*/;
1067 INSERT INTO t1 VALUES(4)
1068 /*!*/;
1069 COMMIT/*!*/;
1070 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1071 DELIMITER ;
1072 # End of log file
1073 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1074 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1075
1076 ==== Remote ====
1077
1078 ---- base64-output ----
1079 include/mysqlbinlog.inc
1080 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1081 # to make the statement usable on server versions 8.0.24 and older.
1082 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1083 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1084 DELIMITER /*!*/;
1085 ROLLBACK/*!*/;
1086 # [empty]
1087 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1088 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1089 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1090 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1091 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1092 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1093 SET TIMESTAMP=#/*!*/;
1094 SET @@session.pseudo_thread_id=#/*!*/;
1095 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1096 SET @@session.sql_mode=1168113696/*!*/;
1097 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1098 /*!\C utf8mb4 *//*!*/;
1099 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1100 SET @@session.lc_time_names=0/*!*/;
1101 SET @@session.collation_database=DEFAULT/*!*/;
1102 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1103 BEGIN
1104 /*!*/;
1105 use `test`/*!*/;
1106 SET TIMESTAMP=#/*!*/;
1107 INSERT INTO t1 VALUES(1)
1108 /*!*/;
1109 COMMIT/*!*/;
1110 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1111 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1112 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1113 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1114 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1115 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1116 SET TIMESTAMP=#/*!*/;
1117 BEGIN
1118 /*!*/;
1119 SET TIMESTAMP=#/*!*/;
1120 INSERT INTO t1 VALUES(2)
1121 /*!*/;
1122 COMMIT/*!*/;
1123 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1124 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1125 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1126 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1127 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1128 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1129 SET TIMESTAMP=#/*!*/;
1130 BEGIN
1131 /*!*/;
1132 SET TIMESTAMP=#/*!*/;
1133 INSERT INTO t1 VALUES(3)
1134 /*!*/;
1135 COMMIT/*!*/;
1136 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1137 DELIMITER ;
1138 # End of log file
1139 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1140 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1141
1142 ---- offset ----
1143 include/mysqlbinlog.inc
1144 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1145 # to make the statement usable on server versions 8.0.24 and older.
1146 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1147 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1148 DELIMITER /*!*/;
1149 ROLLBACK/*!*/;
1150 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1151 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1152 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1153 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1154 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1155 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1156 SET TIMESTAMP=#/*!*/;
1157 SET @@session.pseudo_thread_id=#/*!*/;
1158 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1159 SET @@session.sql_mode=1168113696/*!*/;
1160 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1161 /*!\C utf8mb4 *//*!*/;
1162 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1163 SET @@session.lc_time_names=0/*!*/;
1164 SET @@session.collation_database=DEFAULT/*!*/;
1165 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1166 BEGIN
1167 /*!*/;
1168 use `test`/*!*/;
1169 SET TIMESTAMP=#/*!*/;
1170 INSERT INTO t1 VALUES(1)
1171 /*!*/;
1172 COMMIT/*!*/;
1173 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1174 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1175 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1176 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1177 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1178 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1179 SET TIMESTAMP=#/*!*/;
1180 BEGIN
1181 /*!*/;
1182 SET TIMESTAMP=#/*!*/;
1183 INSERT INTO t1 VALUES(2)
1184 /*!*/;
1185 COMMIT/*!*/;
1186 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1187 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1188 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1189 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1190 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1191 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1192 SET TIMESTAMP=#/*!*/;
1193 BEGIN
1194 /*!*/;
1195 SET TIMESTAMP=#/*!*/;
1196 INSERT INTO t1 VALUES(3)
1197 /*!*/;
1198 COMMIT/*!*/;
1199 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1200 DELIMITER ;
1201 # End of log file
1202 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1203 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1204
1205 ---- start-position ----
1206 include/mysqlbinlog.inc
1207 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1208 # to make the statement usable on server versions 8.0.24 and older.
1209 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1210 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1211 DELIMITER /*!*/;
1212 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1213 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1214 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1215 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1216 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1217 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1218 SET TIMESTAMP=#/*!*/;
1219 SET @@session.pseudo_thread_id=#/*!*/;
1220 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1221 SET @@session.sql_mode=1168113696/*!*/;
1222 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1223 /*!\C utf8mb4 *//*!*/;
1224 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1225 SET @@session.lc_time_names=0/*!*/;
1226 SET @@session.collation_database=DEFAULT/*!*/;
1227 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1228 BEGIN
1229 /*!*/;
1230 use `test`/*!*/;
1231 SET TIMESTAMP=#/*!*/;
1232 INSERT INTO t1 VALUES(2)
1233 /*!*/;
1234 COMMIT/*!*/;
1235 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1236 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1237 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1238 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1239 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1240 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1241 SET TIMESTAMP=#/*!*/;
1242 BEGIN
1243 /*!*/;
1244 SET TIMESTAMP=#/*!*/;
1245 INSERT INTO t1 VALUES(3)
1246 /*!*/;
1247 COMMIT/*!*/;
1248 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1249 DELIMITER ;
1250 # End of log file
1251 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1252 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1253
1254 ---- stop-position ----
1255 include/mysqlbinlog.inc
1256 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1257 # to make the statement usable on server versions 8.0.24 and older.
1258 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1259 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1260 DELIMITER /*!*/;
1261 ROLLBACK/*!*/;
1262 # [empty]
1263 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1264 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1265 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1266 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1267 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1268 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1269 SET TIMESTAMP=#/*!*/;
1270 SET @@session.pseudo_thread_id=#/*!*/;
1271 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1272 SET @@session.sql_mode=1168113696/*!*/;
1273 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1274 /*!\C utf8mb4 *//*!*/;
1275 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1276 SET @@session.lc_time_names=0/*!*/;
1277 SET @@session.collation_database=DEFAULT/*!*/;
1278 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1279 BEGIN
1280 /*!*/;
1281 use `test`/*!*/;
1282 SET TIMESTAMP=#/*!*/;
1283 INSERT INTO t1 VALUES(1)
1284 /*!*/;
1285 COMMIT/*!*/;
1286 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1287 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1288 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1289 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1290 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1291 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1292 SET TIMESTAMP=#/*!*/;
1293 BEGIN
1294 /*!*/;
1295 SET TIMESTAMP=#/*!*/;
1296 INSERT INTO t1 VALUES(2)
1297 /*!*/;
1298 COMMIT/*!*/;
1299 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1300 DELIMITER ;
1301 # End of log file
1302 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1303 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1304
1305 ---- start-position stop-position ----
1306 include/mysqlbinlog.inc
1307 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1308 # to make the statement usable on server versions 8.0.24 and older.
1309 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1310 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1311 DELIMITER /*!*/;
1312 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1313 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1314 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1315 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1316 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1317 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1318 SET TIMESTAMP=#/*!*/;
1319 SET @@session.pseudo_thread_id=#/*!*/;
1320 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1321 SET @@session.sql_mode=1168113696/*!*/;
1322 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1323 /*!\C utf8mb4 *//*!*/;
1324 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1325 SET @@session.lc_time_names=0/*!*/;
1326 SET @@session.collation_database=DEFAULT/*!*/;
1327 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1328 BEGIN
1329 /*!*/;
1330 use `test`/*!*/;
1331 SET TIMESTAMP=#/*!*/;
1332 INSERT INTO t1 VALUES(2)
1333 /*!*/;
1334 COMMIT/*!*/;
1335 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1336 DELIMITER ;
1337 # End of log file
1338 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1339 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1340
1341 ---- start-datetime ----
1342 include/mysqlbinlog.inc
1343 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1344 # to make the statement usable on server versions 8.0.24 and older.
1345 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1346 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1347 DELIMITER /*!*/;
1348 ROLLBACK/*!*/;
1349 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1350 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1351 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1352 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1353 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1354 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1355 SET TIMESTAMP=#/*!*/;
1356 SET @@session.pseudo_thread_id=#/*!*/;
1357 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1358 SET @@session.sql_mode=1168113696/*!*/;
1359 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1360 /*!\C utf8mb4 *//*!*/;
1361 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1362 SET @@session.lc_time_names=0/*!*/;
1363 SET @@session.collation_database=DEFAULT/*!*/;
1364 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1365 BEGIN
1366 /*!*/;
1367 use `test`/*!*/;
1368 SET TIMESTAMP=#/*!*/;
1369 INSERT INTO t1 VALUES(1)
1370 /*!*/;
1371 COMMIT/*!*/;
1372 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1373 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1374 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1375 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1376 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1377 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1378 SET TIMESTAMP=#/*!*/;
1379 BEGIN
1380 /*!*/;
1381 SET TIMESTAMP=#/*!*/;
1382 INSERT INTO t1 VALUES(2)
1383 /*!*/;
1384 COMMIT/*!*/;
1385 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1386 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1387 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1388 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1389 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1390 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1391 SET TIMESTAMP=#/*!*/;
1392 BEGIN
1393 /*!*/;
1394 SET TIMESTAMP=#/*!*/;
1395 INSERT INTO t1 VALUES(3)
1396 /*!*/;
1397 COMMIT/*!*/;
1398 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1399 DELIMITER ;
1400 # End of log file
1401 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1402 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1403
1404 ---- stop-datetime ----
1405 include/mysqlbinlog.inc
1406 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1407 # to make the statement usable on server versions 8.0.24 and older.
1408 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1409 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1410 DELIMITER /*!*/;
1411 ROLLBACK/*!*/;
1412 # [empty]
1413 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1414 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1415 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1416 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1417 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1418 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1419 SET TIMESTAMP=#/*!*/;
1420 SET @@session.pseudo_thread_id=#/*!*/;
1421 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1422 SET @@session.sql_mode=1168113696/*!*/;
1423 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1424 /*!\C utf8mb4 *//*!*/;
1425 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1426 SET @@session.lc_time_names=0/*!*/;
1427 SET @@session.collation_database=DEFAULT/*!*/;
1428 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1429 BEGIN
1430 /*!*/;
1431 use `test`/*!*/;
1432 SET TIMESTAMP=#/*!*/;
1433 INSERT INTO t1 VALUES(1)
1434 /*!*/;
1435 COMMIT/*!*/;
1436 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1437 DELIMITER ;
1438 # End of log file
1439 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1440 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1441
1442 ---- start-datetime stop-datetime ----
1443 include/mysqlbinlog.inc
1444 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1445 # to make the statement usable on server versions 8.0.24 and older.
1446 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1447 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1448 DELIMITER /*!*/;
1449 ROLLBACK/*!*/;
1450 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1451 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1452 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1453 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1454 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1455 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1456 SET TIMESTAMP=#/*!*/;
1457 SET @@session.pseudo_thread_id=#/*!*/;
1458 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1459 SET @@session.sql_mode=1168113696/*!*/;
1460 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1461 /*!\C utf8mb4 *//*!*/;
1462 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1463 SET @@session.lc_time_names=0/*!*/;
1464 SET @@session.collation_database=DEFAULT/*!*/;
1465 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1466 BEGIN
1467 /*!*/;
1468 use `test`/*!*/;
1469 SET TIMESTAMP=#/*!*/;
1470 INSERT INTO t1 VALUES(1)
1471 /*!*/;
1472 COMMIT/*!*/;
1473 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1474 DELIMITER ;
1475 # End of log file
1476 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1477 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1478
1479 ==== Remote with 2 binlogs on command line ====
1480
1481 ---- base64-output ----
1482 include/mysqlbinlog.inc
1483 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1484 # to make the statement usable on server versions 8.0.24 and older.
1485 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1486 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1487 DELIMITER /*!*/;
1488 ROLLBACK/*!*/;
1489 # [empty]
1490 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1491 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1492 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1493 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1494 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1495 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1496 SET TIMESTAMP=#/*!*/;
1497 SET @@session.pseudo_thread_id=#/*!*/;
1498 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1499 SET @@session.sql_mode=1168113696/*!*/;
1500 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1501 /*!\C utf8mb4 *//*!*/;
1502 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1503 SET @@session.lc_time_names=0/*!*/;
1504 SET @@session.collation_database=DEFAULT/*!*/;
1505 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1506 BEGIN
1507 /*!*/;
1508 use `test`/*!*/;
1509 SET TIMESTAMP=#/*!*/;
1510 INSERT INTO t1 VALUES(1)
1511 /*!*/;
1512 COMMIT/*!*/;
1513 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1514 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1515 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1516 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1517 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1518 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1519 SET TIMESTAMP=#/*!*/;
1520 BEGIN
1521 /*!*/;
1522 SET TIMESTAMP=#/*!*/;
1523 INSERT INTO t1 VALUES(2)
1524 /*!*/;
1525 COMMIT/*!*/;
1526 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1527 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1528 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1529 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1530 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1531 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1532 SET TIMESTAMP=#/*!*/;
1533 BEGIN
1534 /*!*/;
1535 SET TIMESTAMP=#/*!*/;
1536 INSERT INTO t1 VALUES(3)
1537 /*!*/;
1538 COMMIT/*!*/;
1539 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1540 # [empty]
1541 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1542 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1543 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1544 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1545 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1546 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1547 SET TIMESTAMP=#/*!*/;
1548 BEGIN
1549 /*!*/;
1550 SET TIMESTAMP=#/*!*/;
1551 INSERT INTO t1 VALUES(4)
1552 /*!*/;
1553 COMMIT/*!*/;
1554 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1555 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1556 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1557 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1558 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1559 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1560 SET TIMESTAMP=#/*!*/;
1561 BEGIN
1562 /*!*/;
1563 SET TIMESTAMP=#/*!*/;
1564 INSERT INTO t1 VALUES(5)
1565 /*!*/;
1566 COMMIT/*!*/;
1567 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1568 DELIMITER ;
1569 # End of log file
1570 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1571 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1572
1573 ---- offset ----
1574 include/mysqlbinlog.inc
1575 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1576 # to make the statement usable on server versions 8.0.24 and older.
1577 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1578 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1579 DELIMITER /*!*/;
1580 ROLLBACK/*!*/;
1581 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1582 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1583 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1584 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1585 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1586 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1587 SET TIMESTAMP=#/*!*/;
1588 SET @@session.pseudo_thread_id=#/*!*/;
1589 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1590 SET @@session.sql_mode=1168113696/*!*/;
1591 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1592 /*!\C utf8mb4 *//*!*/;
1593 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1594 SET @@session.lc_time_names=0/*!*/;
1595 SET @@session.collation_database=DEFAULT/*!*/;
1596 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1597 BEGIN
1598 /*!*/;
1599 use `test`/*!*/;
1600 SET TIMESTAMP=#/*!*/;
1601 INSERT INTO t1 VALUES(1)
1602 /*!*/;
1603 COMMIT/*!*/;
1604 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1605 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1606 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1607 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1608 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1609 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1610 SET TIMESTAMP=#/*!*/;
1611 BEGIN
1612 /*!*/;
1613 SET TIMESTAMP=#/*!*/;
1614 INSERT INTO t1 VALUES(2)
1615 /*!*/;
1616 COMMIT/*!*/;
1617 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1618 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1619 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1620 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1621 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1622 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1623 SET TIMESTAMP=#/*!*/;
1624 BEGIN
1625 /*!*/;
1626 SET TIMESTAMP=#/*!*/;
1627 INSERT INTO t1 VALUES(3)
1628 /*!*/;
1629 COMMIT/*!*/;
1630 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1631 # [empty]
1632 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1633 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1634 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1635 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1636 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1637 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1638 SET TIMESTAMP=#/*!*/;
1639 BEGIN
1640 /*!*/;
1641 SET TIMESTAMP=#/*!*/;
1642 INSERT INTO t1 VALUES(4)
1643 /*!*/;
1644 COMMIT/*!*/;
1645 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1646 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1647 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1648 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1649 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1650 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1651 SET TIMESTAMP=#/*!*/;
1652 BEGIN
1653 /*!*/;
1654 SET TIMESTAMP=#/*!*/;
1655 INSERT INTO t1 VALUES(5)
1656 /*!*/;
1657 COMMIT/*!*/;
1658 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1659 DELIMITER ;
1660 # End of log file
1661 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1662 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1663
1664 ---- start-position ----
1665 include/mysqlbinlog.inc
1666 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1667 # to make the statement usable on server versions 8.0.24 and older.
1668 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1669 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1670 DELIMITER /*!*/;
1671 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1672 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1673 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1674 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1675 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1676 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1677 SET TIMESTAMP=#/*!*/;
1678 SET @@session.pseudo_thread_id=#/*!*/;
1679 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1680 SET @@session.sql_mode=1168113696/*!*/;
1681 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1682 /*!\C utf8mb4 *//*!*/;
1683 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1684 SET @@session.lc_time_names=0/*!*/;
1685 SET @@session.collation_database=DEFAULT/*!*/;
1686 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1687 BEGIN
1688 /*!*/;
1689 use `test`/*!*/;
1690 SET TIMESTAMP=#/*!*/;
1691 INSERT INTO t1 VALUES(2)
1692 /*!*/;
1693 COMMIT/*!*/;
1694 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1695 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1696 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1697 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1698 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1699 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1700 SET TIMESTAMP=#/*!*/;
1701 BEGIN
1702 /*!*/;
1703 SET TIMESTAMP=#/*!*/;
1704 INSERT INTO t1 VALUES(3)
1705 /*!*/;
1706 COMMIT/*!*/;
1707 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1708 # [empty]
1709 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1710 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1711 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1712 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1713 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1714 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1715 SET TIMESTAMP=#/*!*/;
1716 BEGIN
1717 /*!*/;
1718 SET TIMESTAMP=#/*!*/;
1719 INSERT INTO t1 VALUES(4)
1720 /*!*/;
1721 COMMIT/*!*/;
1722 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1723 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1724 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1725 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1726 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1727 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1728 SET TIMESTAMP=#/*!*/;
1729 BEGIN
1730 /*!*/;
1731 SET TIMESTAMP=#/*!*/;
1732 INSERT INTO t1 VALUES(5)
1733 /*!*/;
1734 COMMIT/*!*/;
1735 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1736 DELIMITER ;
1737 # End of log file
1738 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1739 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1740
1741 ---- stop-position ----
1742 include/mysqlbinlog.inc
1743 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1744 # to make the statement usable on server versions 8.0.24 and older.
1745 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1746 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1747 DELIMITER /*!*/;
1748 ROLLBACK/*!*/;
1749 # [empty]
1750 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1751 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1752 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1753 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1754 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1755 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1756 SET TIMESTAMP=#/*!*/;
1757 SET @@session.pseudo_thread_id=#/*!*/;
1758 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1759 SET @@session.sql_mode=1168113696/*!*/;
1760 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1761 /*!\C utf8mb4 *//*!*/;
1762 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1763 SET @@session.lc_time_names=0/*!*/;
1764 SET @@session.collation_database=DEFAULT/*!*/;
1765 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1766 BEGIN
1767 /*!*/;
1768 use `test`/*!*/;
1769 SET TIMESTAMP=#/*!*/;
1770 INSERT INTO t1 VALUES(1)
1771 /*!*/;
1772 COMMIT/*!*/;
1773 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1774 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1775 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1776 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1777 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1778 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1779 SET TIMESTAMP=#/*!*/;
1780 BEGIN
1781 /*!*/;
1782 SET TIMESTAMP=#/*!*/;
1783 INSERT INTO t1 VALUES(2)
1784 /*!*/;
1785 COMMIT/*!*/;
1786 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1787 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1788 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1789 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1790 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1791 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1792 SET TIMESTAMP=#/*!*/;
1793 BEGIN
1794 /*!*/;
1795 SET TIMESTAMP=#/*!*/;
1796 INSERT INTO t1 VALUES(3)
1797 /*!*/;
1798 COMMIT/*!*/;
1799 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1800 # [empty]
1801 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1802 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1803 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1804 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1805 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1806 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1807 SET TIMESTAMP=#/*!*/;
1808 BEGIN
1809 /*!*/;
1810 SET TIMESTAMP=#/*!*/;
1811 INSERT INTO t1 VALUES(4)
1812 /*!*/;
1813 COMMIT/*!*/;
1814 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1815 DELIMITER ;
1816 # End of log file
1817 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1818 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1819
1820 ---- start-position stop-position ----
1821 include/mysqlbinlog.inc
1822 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1823 # to make the statement usable on server versions 8.0.24 and older.
1824 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1825 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1826 DELIMITER /*!*/;
1827 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1828 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1829 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1830 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1831 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1832 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1833 SET TIMESTAMP=#/*!*/;
1834 SET @@session.pseudo_thread_id=#/*!*/;
1835 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1836 SET @@session.sql_mode=1168113696/*!*/;
1837 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1838 /*!\C utf8mb4 *//*!*/;
1839 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1840 SET @@session.lc_time_names=0/*!*/;
1841 SET @@session.collation_database=DEFAULT/*!*/;
1842 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1843 BEGIN
1844 /*!*/;
1845 use `test`/*!*/;
1846 SET TIMESTAMP=#/*!*/;
1847 INSERT INTO t1 VALUES(2)
1848 /*!*/;
1849 COMMIT/*!*/;
1850 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1851 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1852 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1853 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1854 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1855 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1856 SET TIMESTAMP=#/*!*/;
1857 BEGIN
1858 /*!*/;
1859 SET TIMESTAMP=#/*!*/;
1860 INSERT INTO t1 VALUES(3)
1861 /*!*/;
1862 COMMIT/*!*/;
1863 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1864 # [empty]
1865 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1866 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1867 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1868 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1869 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1870 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1871 SET TIMESTAMP=#/*!*/;
1872 BEGIN
1873 /*!*/;
1874 SET TIMESTAMP=#/*!*/;
1875 INSERT INTO t1 VALUES(4)
1876 /*!*/;
1877 COMMIT/*!*/;
1878 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1879 DELIMITER ;
1880 # End of log file
1881 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1882 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1883
1884 ---- start-datetime ----
1885 include/mysqlbinlog.inc
1886 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1887 # to make the statement usable on server versions 8.0.24 and older.
1888 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1889 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1890 DELIMITER /*!*/;
1891 ROLLBACK/*!*/;
1892 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1893 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1894 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1895 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1896 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1897 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1898 SET TIMESTAMP=#/*!*/;
1899 SET @@session.pseudo_thread_id=#/*!*/;
1900 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1901 SET @@session.sql_mode=1168113696/*!*/;
1902 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1903 /*!\C utf8mb4 *//*!*/;
1904 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1905 SET @@session.lc_time_names=0/*!*/;
1906 SET @@session.collation_database=DEFAULT/*!*/;
1907 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
1908 BEGIN
1909 /*!*/;
1910 use `test`/*!*/;
1911 SET TIMESTAMP=#/*!*/;
1912 INSERT INTO t1 VALUES(1)
1913 /*!*/;
1914 COMMIT/*!*/;
1915 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1916 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1917 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1918 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1919 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1920 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1921 SET TIMESTAMP=#/*!*/;
1922 BEGIN
1923 /*!*/;
1924 SET TIMESTAMP=#/*!*/;
1925 INSERT INTO t1 VALUES(2)
1926 /*!*/;
1927 COMMIT/*!*/;
1928 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1929 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1930 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1931 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1932 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1933 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1934 SET TIMESTAMP=#/*!*/;
1935 BEGIN
1936 /*!*/;
1937 SET TIMESTAMP=#/*!*/;
1938 INSERT INTO t1 VALUES(3)
1939 /*!*/;
1940 COMMIT/*!*/;
1941 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1942 # [empty]
1943 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1944 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1945 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1946 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1947 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1948 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1949 SET TIMESTAMP=#/*!*/;
1950 BEGIN
1951 /*!*/;
1952 SET TIMESTAMP=#/*!*/;
1953 INSERT INTO t1 VALUES(4)
1954 /*!*/;
1955 COMMIT/*!*/;
1956 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1957 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1958 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1959 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1960 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1961 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1962 SET TIMESTAMP=#/*!*/;
1963 BEGIN
1964 /*!*/;
1965 SET TIMESTAMP=#/*!*/;
1966 INSERT INTO t1 VALUES(5)
1967 /*!*/;
1968 COMMIT/*!*/;
1969 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1970 DELIMITER ;
1971 # End of log file
1972 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1973 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1974
1975 ---- stop-datetime ----
1976 include/mysqlbinlog.inc
1977 # The proper term is pseudo_replica_mode, but we use this compatibility alias
1978 # to make the statement usable on server versions 8.0.24 and older.
1979 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1980 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1981 DELIMITER /*!*/;
1982 ROLLBACK/*!*/;
1983 # [empty]
1984 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1985 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1986 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1987 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1988 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1989 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1990 SET TIMESTAMP=#/*!*/;
1991 SET @@session.pseudo_thread_id=#/*!*/;
1992 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
1993 SET @@session.sql_mode=1168113696/*!*/;
1994 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1995 /*!\C utf8mb4 *//*!*/;
1996 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
1997 SET @@session.lc_time_names=0/*!*/;
1998 SET @@session.collation_database=DEFAULT/*!*/;
1999 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
2000 BEGIN
2001 /*!*/;
2002 use `test`/*!*/;
2003 SET TIMESTAMP=#/*!*/;
2004 INSERT INTO t1 VALUES(1)
2005 /*!*/;
2006 COMMIT/*!*/;
2007 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2008 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2009 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2010 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2011 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2012 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2013 SET TIMESTAMP=#/*!*/;
2014 BEGIN
2015 /*!*/;
2016 SET TIMESTAMP=#/*!*/;
2017 INSERT INTO t1 VALUES(2)
2018 /*!*/;
2019 COMMIT/*!*/;
2020 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2021 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2022 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2023 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2024 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2025 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2026 SET TIMESTAMP=#/*!*/;
2027 BEGIN
2028 /*!*/;
2029 SET TIMESTAMP=#/*!*/;
2030 INSERT INTO t1 VALUES(3)
2031 /*!*/;
2032 COMMIT/*!*/;
2033 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
2034 # [empty]
2035 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2036 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2037 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2038 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2039 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2040 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2041 SET TIMESTAMP=#/*!*/;
2042 BEGIN
2043 /*!*/;
2044 SET TIMESTAMP=#/*!*/;
2045 INSERT INTO t1 VALUES(4)
2046 /*!*/;
2047 COMMIT/*!*/;
2048 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
2049 DELIMITER ;
2050 # End of log file
2051 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
2052 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
2053
2054 ---- start-datetime stop-datetime ----
2055 include/mysqlbinlog.inc
2056 # The proper term is pseudo_replica_mode, but we use this compatibility alias
2057 # to make the statement usable on server versions 8.0.24 and older.
2058 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
2059 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
2060 DELIMITER /*!*/;
2061 ROLLBACK/*!*/;
2062 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2063 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2064 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2065 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2066 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2067 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2068 SET TIMESTAMP=#/*!*/;
2069 SET @@session.pseudo_thread_id=#/*!*/;
2070 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
2071 SET @@session.sql_mode=1168113696/*!*/;
2072 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
2073 /*!\C utf8mb4 *//*!*/;
2074 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
2075 SET @@session.lc_time_names=0/*!*/;
2076 SET @@session.collation_database=DEFAULT/*!*/;
2077 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
2078 BEGIN
2079 /*!*/;
2080 use `test`/*!*/;
2081 SET TIMESTAMP=#/*!*/;
2082 INSERT INTO t1 VALUES(1)
2083 /*!*/;
2084 COMMIT/*!*/;
2085 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2086 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2087 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2088 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2089 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2090 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2091 SET TIMESTAMP=#/*!*/;
2092 BEGIN
2093 /*!*/;
2094 SET TIMESTAMP=#/*!*/;
2095 INSERT INTO t1 VALUES(2)
2096 /*!*/;
2097 COMMIT/*!*/;
2098 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2099 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2100 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2101 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2102 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2103 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2104 SET TIMESTAMP=#/*!*/;
2105 BEGIN
2106 /*!*/;
2107 SET TIMESTAMP=#/*!*/;
2108 INSERT INTO t1 VALUES(3)
2109 /*!*/;
2110 COMMIT/*!*/;
2111 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
2112 # [empty]
2113 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2114 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2115 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2116 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2117 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2118 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2119 SET TIMESTAMP=#/*!*/;
2120 BEGIN
2121 /*!*/;
2122 SET TIMESTAMP=#/*!*/;
2123 INSERT INTO t1 VALUES(4)
2124 /*!*/;
2125 COMMIT/*!*/;
2126 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
2127 DELIMITER ;
2128 # End of log file
2129 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
2130 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
2131
2132 ---- to-last-log ----
2133 include/mysqlbinlog.inc
2134 # The proper term is pseudo_replica_mode, but we use this compatibility alias
2135 # to make the statement usable on server versions 8.0.24 and older.
2136 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
2137 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
2138 DELIMITER /*!*/;
2139 ROLLBACK/*!*/;
2140 # [empty]
2141 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2142 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2143 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2144 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2145 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2146 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2147 SET TIMESTAMP=#/*!*/;
2148 SET @@session.pseudo_thread_id=#/*!*/;
2149 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
2150 SET @@session.sql_mode=1168113696/*!*/;
2151 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
2152 /*!\C utf8mb4 *//*!*/;
2153 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
2154 SET @@session.lc_time_names=0/*!*/;
2155 SET @@session.collation_database=DEFAULT/*!*/;
2156 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
2157 BEGIN
2158 /*!*/;
2159 use `test`/*!*/;
2160 SET TIMESTAMP=#/*!*/;
2161 INSERT INTO t1 VALUES(1)
2162 /*!*/;
2163 COMMIT/*!*/;
2164 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2165 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2166 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2167 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2168 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2169 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2170 SET TIMESTAMP=#/*!*/;
2171 BEGIN
2172 /*!*/;
2173 SET TIMESTAMP=#/*!*/;
2174 INSERT INTO t1 VALUES(2)
2175 /*!*/;
2176 COMMIT/*!*/;
2177 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2178 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2179 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2180 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2181 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2182 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2183 SET TIMESTAMP=#/*!*/;
2184 BEGIN
2185 /*!*/;
2186 SET TIMESTAMP=#/*!*/;
2187 INSERT INTO t1 VALUES(3)
2188 /*!*/;
2189 COMMIT/*!*/;
2190 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
2191 # [empty]
2192 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2193 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2194 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2195 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2196 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2197 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2198 SET TIMESTAMP=#/*!*/;
2199 BEGIN
2200 /*!*/;
2201 SET TIMESTAMP=#/*!*/;
2202 INSERT INTO t1 VALUES(4)
2203 /*!*/;
2204 COMMIT/*!*/;
2205 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2206 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
2207 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
2208 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
2209 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
2210 SET @@SESSION.GTID_NEXT= '#'/*!*/;
2211 SET TIMESTAMP=#/*!*/;
2212 BEGIN
2213 /*!*/;
2214 SET TIMESTAMP=#/*!*/;
2215 INSERT INTO t1 VALUES(5)
2216 /*!*/;
2217 COMMIT/*!*/;
2218 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
2219 # [empty]
2220 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
2221 DELIMITER ;
2222 # End of log file
2223 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
2224 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
2225
2226 ==== clean up ====
2227 DROP TABLE t1;