Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 #Test case 1:
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB;
5 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB;
6 CREATE TABLE t3 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB;
7 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW
8 BEGIN
9 DECLARE EXIT HANDLER FOR SQLEXCEPTION
10 BEGIN
11 ROLLBACK TO event_logging_1;
12 INSERT t3 VALUES (1);
13 END;
14 SAVEPOINT event_logging_1;
15 INSERT INTO t2 VALUES (1);
16 RELEASE SAVEPOINT event_logging_1;
17 END|
18 INSERT INTO t2 VALUES (1);
19 INSERT INTO t1 VALUES (1);
20 include/show_binlog_events.inc
21 Log_name Pos Event_type Server_id End_log_pos Info
22 master-bin.000001 # Gtid # # GTID #-#-#
23 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB
24 master-bin.000001 # Gtid # # GTID #-#-#
25 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB
26 master-bin.000001 # Gtid # # GTID #-#-#
27 master-bin.000001 # Query # # use `test`; CREATE TABLE t3 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB
28 master-bin.000001 # Gtid # # GTID #-#-#
29 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW
30 BEGIN
31 DECLARE EXIT HANDLER FOR SQLEXCEPTION
32 BEGIN
33 ROLLBACK TO event_logging_1;
34 INSERT t3 VALUES (1);
35 END;
36 SAVEPOINT event_logging_1;
37 INSERT INTO t2 VALUES (1);
38 RELEASE SAVEPOINT event_logging_1;
39 END
40 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
41 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
42 master-bin.000001 # Table_map # # table_id: # (test.t2)
43 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
44 master-bin.000001 # Xid # # COMMIT /* XID */
45 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
46 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
47 master-bin.000001 # Table_map # # table_id: # (test.t1)
48 master-bin.000001 # Table_map # # table_id: # (test.t2)
49 master-bin.000001 # Table_map # # table_id: # (test.t3)
50 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
51 master-bin.000001 # Query # # SAVEPOINT `event_logging_1`
52 master-bin.000001 # Annotate_rows # # INSERT t3 VALUES (1)
53 master-bin.000001 # Table_map # # table_id: # (test.t1)
54 master-bin.000001 # Table_map # # table_id: # (test.t2)
55 master-bin.000001 # Table_map # # table_id: # (test.t3)
56 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
57 master-bin.000001 # Xid # # COMMIT /* XID */
58 connection slave;
59 connection master;
60 DROP TRIGGER tr1;
61 DELETE FROM t1;
62 DELETE FROM t2;
63 DELETE FROM t3;
64 # Test case 2:
65 CREATE PROCEDURE p1()
66 BEGIN
67 DECLARE EXIT HANDLER FOR SQLEXCEPTION
68 BEGIN
69 ROLLBACK TO event_logging_2;
70 INSERT t3 VALUES (3);
71 END;
72 SAVEPOINT event_logging_2;
73 INSERT INTO t2 VALUES (1);
74 RELEASE SAVEPOINT event_logging_2;
75 END|
76 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW CALL p1()|
77 INSERT INTO t2 VALUES (1);
78 INSERT INTO t1 VALUES (1);
79 include/show_binlog_events.inc
80 Log_name Pos Event_type Server_id End_log_pos Info
81 master-bin.000001 # Gtid # # GTID #-#-#
82 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB
83 master-bin.000001 # Gtid # # GTID #-#-#
84 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB
85 master-bin.000001 # Gtid # # GTID #-#-#
86 master-bin.000001 # Query # # use `test`; CREATE TABLE t3 (f1 INTEGER PRIMARY KEY) ENGINE=INNODB
87 master-bin.000001 # Gtid # # GTID #-#-#
88 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW
89 BEGIN
90 DECLARE EXIT HANDLER FOR SQLEXCEPTION
91 BEGIN
92 ROLLBACK TO event_logging_1;
93 INSERT t3 VALUES (1);
94 END;
95 SAVEPOINT event_logging_1;
96 INSERT INTO t2 VALUES (1);
97 RELEASE SAVEPOINT event_logging_1;
98 END
99 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
100 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
101 master-bin.000001 # Table_map # # table_id: # (test.t2)
102 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
103 master-bin.000001 # Xid # # COMMIT /* XID */
104 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
105 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
106 master-bin.000001 # Table_map # # table_id: # (test.t1)
107 master-bin.000001 # Table_map # # table_id: # (test.t2)
108 master-bin.000001 # Table_map # # table_id: # (test.t3)
109 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
110 master-bin.000001 # Query # # SAVEPOINT `event_logging_1`
111 master-bin.000001 # Annotate_rows # # INSERT t3 VALUES (1)
112 master-bin.000001 # Table_map # # table_id: # (test.t1)
113 master-bin.000001 # Table_map # # table_id: # (test.t2)
114 master-bin.000001 # Table_map # # table_id: # (test.t3)
115 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
116 master-bin.000001 # Xid # # COMMIT /* XID */
117 master-bin.000001 # Gtid # # GTID #-#-#
118 master-bin.000001 # Query # # use `test`; DROP TRIGGER tr1
119 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
120 master-bin.000001 # Annotate_rows # # DELETE FROM t1
121 master-bin.000001 # Table_map # # table_id: # (test.t1)
122 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
123 master-bin.000001 # Xid # # COMMIT /* XID */
124 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
125 master-bin.000001 # Annotate_rows # # DELETE FROM t2
126 master-bin.000001 # Table_map # # table_id: # (test.t2)
127 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
128 master-bin.000001 # Xid # # COMMIT /* XID */
129 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
130 master-bin.000001 # Annotate_rows # # DELETE FROM t3
131 master-bin.000001 # Table_map # # table_id: # (test.t3)
132 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
133 master-bin.000001 # Xid # # COMMIT /* XID */
134 master-bin.000001 # Gtid # # GTID #-#-#
135 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
136 BEGIN
137 DECLARE EXIT HANDLER FOR SQLEXCEPTION
138 BEGIN
139 ROLLBACK TO event_logging_2;
140 INSERT t3 VALUES (3);
141 END;
142 SAVEPOINT event_logging_2;
143 INSERT INTO t2 VALUES (1);
144 RELEASE SAVEPOINT event_logging_2;
145 END
146 master-bin.000001 # Gtid # # GTID #-#-#
147 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW CALL p1()
148 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
149 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
150 master-bin.000001 # Table_map # # table_id: # (test.t2)
151 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
152 master-bin.000001 # Xid # # COMMIT /* XID */
153 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
154 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
155 master-bin.000001 # Table_map # # table_id: # (test.t1)
156 master-bin.000001 # Table_map # # table_id: # (test.t2)
157 master-bin.000001 # Table_map # # table_id: # (test.t3)
158 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
159 master-bin.000001 # Query # # SAVEPOINT `event_logging_2`
160 master-bin.000001 # Annotate_rows # # INSERT t3 VALUES (3)
161 master-bin.000001 # Table_map # # table_id: # (test.t1)
162 master-bin.000001 # Table_map # # table_id: # (test.t2)
163 master-bin.000001 # Table_map # # table_id: # (test.t3)
164 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
165 master-bin.000001 # Xid # # COMMIT /* XID */
166 connection slave;
167 connection master;
168 DROP TABLE t1;
169 DROP TABLE t2;
170 DROP TABLE t3;
171 DROP PROCEDURE p1;
172 # Test case 3:
173 include/rpl_reset.inc
174 connection master;
175 CREATE TABLE t (f1 int(10) unsigned NOT NULL, PRIMARY KEY (f1)) ENGINE=InnoDB;
176 CREATE TRIGGER t_insert_trig AFTER INSERT ON t FOR EACH ROW
177 BEGIN
178 SAVEPOINT savepoint_1;
179 ROLLBACK TO savepoint_1;
180 END |
181 INSERT INTO t VALUES (2);
182 INSERT INTO t VALUES (3);
183 include/show_binlog_events.inc
184 Log_name Pos Event_type Server_id End_log_pos Info
185 master-bin.000001 # Gtid # # GTID #-#-#
186 master-bin.000001 # Query # # use `test`; CREATE TABLE t (f1 int(10) unsigned NOT NULL, PRIMARY KEY (f1)) ENGINE=InnoDB
187 master-bin.000001 # Gtid # # GTID #-#-#
188 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t_insert_trig AFTER INSERT ON t FOR EACH ROW
189 BEGIN
190 SAVEPOINT savepoint_1;
191 ROLLBACK TO savepoint_1;
192 END
193 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
194 master-bin.000001 # Annotate_rows # # INSERT INTO t VALUES (2)
195 master-bin.000001 # Table_map # # table_id: # (test.t)
196 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
197 master-bin.000001 # Query # # SAVEPOINT `savepoint_1`
198 master-bin.000001 # Xid # # COMMIT /* XID */
199 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
200 master-bin.000001 # Annotate_rows # # INSERT INTO t VALUES (3)
201 master-bin.000001 # Table_map # # table_id: # (test.t)
202 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
203 master-bin.000001 # Query # # SAVEPOINT `savepoint_1`
204 master-bin.000001 # Xid # # COMMIT /* XID */
205 SELECT * FROM t;
206 f1
207 2
208 3
209 include/sync_slave_sql_with_master.inc
210 SELECT * FROM t;
211 f1
212 2
213 3
214 connection master;
215 DROP TABLE t;
216 # Test case 4:
217 include/rpl_reset.inc
218 connection master;
219 CREATE TABLE t (f1 int(10) unsigned NOT NULL) ENGINE=InnoDB;
220 CREATE TABLE t1 (f1 int(10) unsigned NOT NULL) ENGINE=InnoDB;
221 CREATE TRIGGER t_insert_trig BEFORE INSERT ON t FOR EACH ROW
222 BEGIN
223 SAVEPOINT savepoint_1;
224 INSERT INTO t1 VALUES (5);
225 END |
226 INSERT INTO t VALUES (2), (3);
227 INSERT INTO t1 VALUES (30);
228 include/show_binlog_events.inc
229 Log_name Pos Event_type Server_id End_log_pos Info
230 master-bin.000001 # Gtid # # GTID #-#-#
231 master-bin.000001 # Query # # use `test`; CREATE TABLE t (f1 int(10) unsigned NOT NULL) ENGINE=InnoDB
232 master-bin.000001 # Gtid # # GTID #-#-#
233 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (f1 int(10) unsigned NOT NULL) ENGINE=InnoDB
234 master-bin.000001 # Gtid # # GTID #-#-#
235 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t_insert_trig BEFORE INSERT ON t FOR EACH ROW
236 BEGIN
237 SAVEPOINT savepoint_1;
238 INSERT INTO t1 VALUES (5);
239 END
240 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
241 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (5)
242 master-bin.000001 # Table_map # # table_id: # (test.t)
243 master-bin.000001 # Table_map # # table_id: # (test.t1)
244 master-bin.000001 # Write_rows_v1 # # table_id: #
245 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
246 master-bin.000001 # Query # # SAVEPOINT `savepoint_1`
247 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (5)
248 master-bin.000001 # Table_map # # table_id: # (test.t)
249 master-bin.000001 # Table_map # # table_id: # (test.t1)
250 master-bin.000001 # Write_rows_v1 # # table_id: #
251 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
252 master-bin.000001 # Xid # # COMMIT /* XID */
253 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
254 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (30)
255 master-bin.000001 # Table_map # # table_id: # (test.t1)
256 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
257 master-bin.000001 # Xid # # COMMIT /* XID */
258 SELECT * FROM t;
259 f1
260 2
261 3
262 SELECT * FROM t1;
263 f1
264 5
265 5
266 30
267 include/sync_slave_sql_with_master.inc
268 SELECT * FROM t;
269 f1
270 2
271 3
272 SELECT * FROM t1;
273 f1
274 5
275 5
276 30
277 connection master;
278 DROP TABLE t;
279 DROP TABLE t1;
280 # Test case 5:
281 include/rpl_reset.inc
282 connection master;
283 CREATE TABLE t (f1 int(10) unsigned NOT NULL) ENGINE=InnoDB;
284 CREATE TABLE t1 (f1 int(10) unsigned NOT NULL) ENGINE=InnoDB;
285 CREATE TRIGGER t_insert_trig BEFORE INSERT ON t
286 FOR EACH ROW
287 BEGIN
288 SAVEPOINT savepoint_1;
289 END |
290 INSERT INTO t VALUES (2), (3);
291 INSERT INTO t1 VALUES (30);
292 include/show_binlog_events.inc
293 Log_name Pos Event_type Server_id End_log_pos Info
294 master-bin.000001 # Gtid # # GTID #-#-#
295 master-bin.000001 # Query # # use `test`; CREATE TABLE t (f1 int(10) unsigned NOT NULL) ENGINE=InnoDB
296 master-bin.000001 # Gtid # # GTID #-#-#
297 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (f1 int(10) unsigned NOT NULL) ENGINE=InnoDB
298 master-bin.000001 # Gtid # # GTID #-#-#
299 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t_insert_trig BEFORE INSERT ON t
300 FOR EACH ROW
301 BEGIN
302 SAVEPOINT savepoint_1;
303 END
304 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
305 master-bin.000001 # Annotate_rows # # INSERT INTO t VALUES (2), (3)
306 master-bin.000001 # Table_map # # table_id: # (test.t)
307 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
308 master-bin.000001 # Query # # SAVEPOINT `savepoint_1`
309 master-bin.000001 # Annotate_rows # # INSERT INTO t VALUES (2), (3)
310 master-bin.000001 # Table_map # # table_id: # (test.t)
311 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
312 master-bin.000001 # Xid # # COMMIT /* XID */
313 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
314 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (30)
315 master-bin.000001 # Table_map # # table_id: # (test.t1)
316 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
317 master-bin.000001 # Xid # # COMMIT /* XID */
318 SELECT * FROM t;
319 f1
320 2
321 3
322 SELECT * FROM t1;
323 f1
324 30
325 include/sync_slave_sql_with_master.inc
326 SELECT * FROM t;
327 f1
328 2
329 3
330 SELECT * FROM t1;
331 f1
332 30
333 connection master;
334 DROP TABLE t;
335 DROP TABLE t1;
336 # Test case 6:
337 include/rpl_reset.inc
338 connection master;
339 CREATE TABLE t1 (f1 INTEGER ) ENGINE=INNODB;
340 CREATE TABLE t2 (f1 INTEGER ) ENGINE=INNODB;
341 CREATE FUNCTION f1() RETURNS INT
342 BEGIN
343 SAVEPOINT event_logging_2;
344 INSERT INTO t1 VALUES (1);
345 ROLLBACK TO event_logging_2;
346 RETURN 0;
347 END|
348 BEGIN;
349 INSERT INTO t2 VALUES (1), (f1()), (2), (4);
350 COMMIT;
351 INSERT INTO t2 VALUES (10);
352 include/show_binlog_events.inc
353 Log_name Pos Event_type Server_id End_log_pos Info
354 master-bin.000001 # Gtid # # GTID #-#-#
355 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (f1 INTEGER ) ENGINE=INNODB
356 master-bin.000001 # Gtid # # GTID #-#-#
357 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (f1 INTEGER ) ENGINE=INNODB
358 master-bin.000001 # Gtid # # GTID #-#-#
359 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
360 BEGIN
361 SAVEPOINT event_logging_2;
362 INSERT INTO t1 VALUES (1);
363 ROLLBACK TO event_logging_2;
364 RETURN 0;
365 END
366 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
367 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1), (f1()), (2), (4)
368 master-bin.000001 # Table_map # # table_id: # (test.t2)
369 master-bin.000001 # Table_map # # table_id: # (test.t1)
370 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
371 master-bin.000001 # Query # # SAVEPOINT `event_logging_2`
372 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1), (f1()), (2), (4)
373 master-bin.000001 # Table_map # # table_id: # (test.t2)
374 master-bin.000001 # Table_map # # table_id: # (test.t1)
375 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
376 master-bin.000001 # Xid # # COMMIT /* XID */
377 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
378 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (10)
379 master-bin.000001 # Table_map # # table_id: # (test.t2)
380 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
381 master-bin.000001 # Xid # # COMMIT /* XID */
382 connection master;
383 SELECT * FROM t2;
384 f1
385 1
386 0
387 2
388 4
389 10
390 SELECT * FROM t1;
391 f1
392 include/sync_slave_sql_with_master.inc
393 SELECT * FROM t2;
394 f1
395 1
396 0
397 2
398 4
399 10
400 SELECT * FROM t1;
401 f1
402 connection master;
403 DROP TABLE t1;
404 DROP TABLE t2;
405 DROP FUNCTION f1;
406 # Test case 7:
407 include/rpl_reset.inc
408 connection master;
409 CREATE TABLE t1 (f1 INTEGER ) ENGINE=INNODB;
410 CREATE TABLE t2 (f1 INTEGER ) ENGINE=INNODB;
411 CREATE FUNCTION f1() RETURNS INT
412 BEGIN
413 SAVEPOINT event_logging_2;
414 INSERT INTO t1 VALUES (1);
415 RETURN 0;
416 END|
417 BEGIN;
418 INSERT INTO t2 VALUES (1), (f1()), (2), (4);
419 COMMIT;
420 INSERT INTO t2 VALUES (10);
421 include/show_binlog_events.inc
422 Log_name Pos Event_type Server_id End_log_pos Info
423 master-bin.000001 # Gtid # # GTID #-#-#
424 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (f1 INTEGER ) ENGINE=INNODB
425 master-bin.000001 # Gtid # # GTID #-#-#
426 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (f1 INTEGER ) ENGINE=INNODB
427 master-bin.000001 # Gtid # # GTID #-#-#
428 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
429 BEGIN
430 SAVEPOINT event_logging_2;
431 INSERT INTO t1 VALUES (1);
432 RETURN 0;
433 END
434 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
435 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1), (f1()), (2), (4)
436 master-bin.000001 # Table_map # # table_id: # (test.t2)
437 master-bin.000001 # Table_map # # table_id: # (test.t1)
438 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
439 master-bin.000001 # Query # # SAVEPOINT `event_logging_2`
440 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
441 master-bin.000001 # Table_map # # table_id: # (test.t2)
442 master-bin.000001 # Table_map # # table_id: # (test.t1)
443 master-bin.000001 # Write_rows_v1 # # table_id: #
444 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
445 master-bin.000001 # Xid # # COMMIT /* XID */
446 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
447 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (10)
448 master-bin.000001 # Table_map # # table_id: # (test.t2)
449 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
450 master-bin.000001 # Xid # # COMMIT /* XID */
451 connection master;
452 SELECT * FROM t2;
453 f1
454 1
455 0
456 2
457 4
458 10
459 SELECT * FROM t1;
460 f1
461 1
462 include/sync_slave_sql_with_master.inc
463 SELECT * FROM t2;
464 f1
465 1
466 0
467 2
468 4
469 10
470 SELECT * FROM t1;
471 f1
472 1
473 connection master;
474 DROP TABLE t1;
475 DROP TABLE t2;
476 DROP FUNCTION f1;
477 # Test case 8:
478 include/rpl_reset.inc
479 connection master;
480 CREATE TABLE t1 (f1 INTEGER ) ENGINE=INNODB;
481 CREATE FUNCTION f1() RETURNS INT
482 BEGIN
483 SAVEPOINT event_logging_2;
484 RETURN 0;
485 END|
486 BEGIN;
487 INSERT INTO t1 VALUES (1), (f1()), (2), (4);
488 COMMIT;
489 INSERT INTO t1 VALUES (10);
490 include/show_binlog_events.inc
491 Log_name Pos Event_type Server_id End_log_pos Info
492 master-bin.000001 # Gtid # # GTID #-#-#
493 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (f1 INTEGER ) ENGINE=INNODB
494 master-bin.000001 # Gtid # # GTID #-#-#
495 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
496 BEGIN
497 SAVEPOINT event_logging_2;
498 RETURN 0;
499 END
500 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
501 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1), (f1()), (2), (4)
502 master-bin.000001 # Table_map # # table_id: # (test.t1)
503 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
504 master-bin.000001 # Query # # SAVEPOINT `event_logging_2`
505 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1), (f1()), (2), (4)
506 master-bin.000001 # Table_map # # table_id: # (test.t1)
507 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
508 master-bin.000001 # Xid # # COMMIT /* XID */
509 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
510 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (10)
511 master-bin.000001 # Table_map # # table_id: # (test.t1)
512 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
513 master-bin.000001 # Xid # # COMMIT /* XID */
514 connection master;
515 SELECT * FROM t1;
516 f1
517 1
518 0
519 2
520 4
521 10
522 include/sync_slave_sql_with_master.inc
523 SELECT * FROM t1;
524 f1
525 1
526 0
527 2
528 4
529 10
530 connection master;
531 DROP TABLE t1;
532 DROP FUNCTION f1;
533 include/rpl_end.inc