Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 show global variables like 'binlog_format%';
5 Variable_name Value
6 binlog_format MIXED
7 show session variables like 'binlog_format%';
8 Variable_name Value
9 binlog_format MIXED
10 select @@global.binlog_format, @@session.binlog_format;
11 @@global.binlog_format @@session.binlog_format
12 MIXED MIXED
13 connection slave;
14 show global variables like 'binlog_format%';
15 Variable_name Value
16 binlog_format MIXED
17 show session variables like 'binlog_format%';
18 Variable_name Value
19 binlog_format MIXED
20 select @@global.binlog_format, @@session.binlog_format;
21 @@global.binlog_format @@session.binlog_format
22 MIXED MIXED
23 connection master;
24 CREATE DATABASE test_rpl;
25
26 ******************** PREPARE TESTING ********************
27 USE test_rpl;
28 CREATE TABLE t1 (a int auto_increment not null, b char(254), PRIMARY KEY(a)) ENGINE=innodb;
29 CREATE TABLE t2 (a int auto_increment not null, b char(254), PRIMARY KEY(a)) ENGINE=innodb;
30 INSERT INTO t1 VALUES(1, 't1, text 1');
31 INSERT INTO t1 VALUES(2, 't1, text 2');
32 INSERT INTO t2 VALUES(1, 't2, text 1');
33
34 ******************** DELETE ********************
35 DELETE FROM t1 WHERE a = 1;
36 DELETE FROM t2 WHERE b <> SYS_GUID();
37 SELECT COUNT(*) FROM t1;
38 COUNT(*)
39 1
40 SELECT * FROM t1 ORDER BY a;
41 a b
42 2 t1, text 2
43 SELECT COUNT(*) FROM t2;
44 COUNT(*)
45 0
46 SELECT * FROM t2 ORDER BY a;
47 a b
48 connection slave;
49 USE test_rpl;
50 SELECT COUNT(*) FROM t1;
51 COUNT(*)
52 1
53 SELECT * FROM t1 ORDER BY a;
54 a b
55 2 t1, text 2
56 SELECT COUNT(*) FROM t2;
57 COUNT(*)
58 0
59 SELECT * FROM t2 ORDER BY a;
60 a b
61 connection master;
62 DELETE FROM t1;
63 DELETE FROM t2;
64
65 ******************** INSERT ********************
66 INSERT INTO t1 VALUES(1, 't1, text 1');
67 INSERT INTO t1 VALUES(2, SYS_GUID());
68 INSERT INTO t2 SELECT * FROM t1;
69 INSERT INTO t2 VALUES (1, 't1, text 1') ON DUPLICATE KEY UPDATE b = 't2, text 1';
70 DELETE FROM t1 WHERE a = 2;
71 DELETE FROM t2 WHERE a = 2;
72 SELECT COUNT(*) FROM t1;
73 COUNT(*)
74 1
75 SELECT * FROM t1 ORDER BY a;
76 a b
77 1 t1, text 1
78 SELECT COUNT(*) FROM t2;
79 COUNT(*)
80 1
81 SELECT * FROM t2 ORDER BY a;
82 a b
83 1 t2, text 1
84 connection slave;
85 USE test_rpl;
86 SELECT COUNT(*) FROM t1;
87 COUNT(*)
88 1
89 SELECT * FROM t1 ORDER BY a;
90 a b
91 1 t1, text 1
92 SELECT COUNT(*) FROM t2;
93 COUNT(*)
94 1
95 SELECT * FROM t2 ORDER BY a;
96 a b
97 1 t2, text 1
98 connection master;
99 DELETE FROM t1;
100 DELETE FROM t2;
101
102 ******************** LOAD DATA INFILE ********************
103 LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/rpl_mixed.dat' INTO TABLE t1 FIELDS TERMINATED BY '|' ;
104 SELECT * FROM t1 ORDER BY a;
105 a b
106 10 line A
107 20 line B
108 30 line C
109 SELECT COUNT(*) FROM t1;
110 COUNT(*)
111 3
112 SELECT * FROM t1 ORDER BY a;
113 a b
114 10 line A
115 20 line B
116 30 line C
117 SELECT COUNT(*) FROM t2;
118 COUNT(*)
119 0
120 SELECT * FROM t2 ORDER BY a;
121 a b
122 connection slave;
123 USE test_rpl;
124 SELECT COUNT(*) FROM t1;
125 COUNT(*)
126 3
127 SELECT * FROM t1 ORDER BY a;
128 a b
129 10 line A
130 20 line B
131 30 line C
132 SELECT COUNT(*) FROM t2;
133 COUNT(*)
134 0
135 SELECT * FROM t2 ORDER BY a;
136 a b
137 connection master;
138 DELETE FROM t1;
139 DELETE FROM t2;
140
141 ******************** REPLACE ********************
142 INSERT INTO t1 VALUES(1, 't1, text 1');
143 INSERT INTO t1 VALUES(2, 't1, text 2');
144 INSERT INTO t1 VALUES(3, 't1, text 3');
145 REPLACE INTO t1 VALUES(1, 't1, text 11');
146 REPLACE INTO t1 VALUES(2, SYS_GUID());
147 REPLACE INTO t1 SET a=3, b='t1, text 33';
148 DELETE FROM t1 WHERE a = 2;
149 SELECT COUNT(*) FROM t1;
150 COUNT(*)
151 2
152 SELECT * FROM t1 ORDER BY a;
153 a b
154 1 t1, text 11
155 3 t1, text 33
156 SELECT COUNT(*) FROM t2;
157 COUNT(*)
158 0
159 SELECT * FROM t2 ORDER BY a;
160 a b
161 connection slave;
162 USE test_rpl;
163 SELECT COUNT(*) FROM t1;
164 COUNT(*)
165 2
166 SELECT * FROM t1 ORDER BY a;
167 a b
168 1 t1, text 11
169 3 t1, text 33
170 SELECT COUNT(*) FROM t2;
171 COUNT(*)
172 0
173 SELECT * FROM t2 ORDER BY a;
174 a b
175 connection master;
176 DELETE FROM t1;
177 DELETE FROM t2;
178
179 ******************** SELECT ********************
180 INSERT INTO t1 VALUES(1, 't1, text 1');
181 SELECT * FROM t1 WHERE b <> SYS_GUID() ORDER BY a;
182 a b
183 1 t1, text 1
184 DELETE FROM t1;
185 DELETE FROM t2;
186
187 ******************** JOIN ********************
188 INSERT INTO t1 VALUES(1, 'CCC');
189 INSERT INTO t1 VALUES(2, 'DDD');
190 INSERT INTO t2 VALUES(1, 'DDD');
191 INSERT INTO t2 VALUES(2, 'CCC');
192 SELECT * FROM t1 LEFT JOIN t2 ON t1.a = t2.a ORDER BY t1.a,t2.a;
193 a b a b
194 1 CCC 1 DDD
195 2 DDD 2 CCC
196 SELECT * FROM t1 INNER JOIN t2 ON t1.b = t2.b ORDER BY t1.a,t2.a;
197 a b a b
198 1 CCC 2 CCC
199 2 DDD 1 DDD
200 DELETE FROM t1;
201 DELETE FROM t2;
202
203 ******************** UNION ********************
204 INSERT INTO t1 VALUES(1, 't1, text 1');
205 INSERT INTO t2 VALUES(1, 't2, text 1');
206 SELECT * FROM t1 UNION SELECT * FROM t2 WHERE t2.b <> SYS_GUID();
207 a b
208 1 t1, text 1
209 1 t2, text 1
210 DELETE FROM t1;
211 DELETE FROM t2;
212
213 ******************** TRUNCATE ********************
214 INSERT INTO t1 VALUES(1, 't1, text 1');
215 SELECT COUNT(*) FROM t1;
216 COUNT(*)
217 1
218 SELECT * FROM t1 ORDER BY a;
219 a b
220 1 t1, text 1
221 SELECT COUNT(*) FROM t2;
222 COUNT(*)
223 0
224 SELECT * FROM t2 ORDER BY a;
225 a b
226 connection slave;
227 USE test_rpl;
228 SELECT COUNT(*) FROM t1;
229 COUNT(*)
230 1
231 SELECT * FROM t1 ORDER BY a;
232 a b
233 1 t1, text 1
234 SELECT COUNT(*) FROM t2;
235 COUNT(*)
236 0
237 SELECT * FROM t2 ORDER BY a;
238 a b
239 connection master;
240 TRUNCATE t1;
241 SELECT COUNT(*) FROM t1;
242 COUNT(*)
243 0
244 SELECT * FROM t1 ORDER BY a;
245 a b
246 SELECT COUNT(*) FROM t2;
247 COUNT(*)
248 0
249 SELECT * FROM t2 ORDER BY a;
250 a b
251 connection slave;
252 USE test_rpl;
253 SELECT COUNT(*) FROM t1;
254 COUNT(*)
255 0
256 SELECT * FROM t1 ORDER BY a;
257 a b
258 SELECT COUNT(*) FROM t2;
259 COUNT(*)
260 0
261 SELECT * FROM t2 ORDER BY a;
262 a b
263 connection master;
264 DELETE FROM t1;
265 DELETE FROM t2;
266
267 ******************** UPDATE ********************
268 INSERT INTO t1 VALUES(1, 't1, text 1');
269 INSERT INTO t2 VALUES(1, 't2, text 1');
270 UPDATE t1 SET b = 't1, text 1 updated' WHERE a = 1;
271 SELECT COUNT(*) FROM t1;
272 COUNT(*)
273 1
274 SELECT * FROM t1 ORDER BY a;
275 a b
276 1 t1, text 1 updated
277 SELECT COUNT(*) FROM t2;
278 COUNT(*)
279 1
280 SELECT * FROM t2 ORDER BY a;
281 a b
282 1 t2, text 1
283 connection slave;
284 USE test_rpl;
285 SELECT COUNT(*) FROM t1;
286 COUNT(*)
287 1
288 SELECT * FROM t1 ORDER BY a;
289 a b
290 1 t1, text 1 updated
291 SELECT COUNT(*) FROM t2;
292 COUNT(*)
293 1
294 SELECT * FROM t2 ORDER BY a;
295 a b
296 1 t2, text 1
297 connection master;
298 UPDATE t1, t2 SET t1.b = 'test', t2.b = 'test';
299 SELECT COUNT(*) FROM t1;
300 COUNT(*)
301 1
302 SELECT * FROM t1 ORDER BY a;
303 a b
304 1 test
305 SELECT COUNT(*) FROM t2;
306 COUNT(*)
307 1
308 SELECT * FROM t2 ORDER BY a;
309 a b
310 1 test
311 connection slave;
312 USE test_rpl;
313 SELECT COUNT(*) FROM t1;
314 COUNT(*)
315 1
316 SELECT * FROM t1 ORDER BY a;
317 a b
318 1 test
319 SELECT COUNT(*) FROM t2;
320 COUNT(*)
321 1
322 SELECT * FROM t2 ORDER BY a;
323 a b
324 1 test
325 connection master;
326 DELETE FROM t1;
327 DELETE FROM t2;
328
329 ******************** DESCRIBE ********************
330 DESCRIBE t1;
331 Field Type Null Key Default Extra
332 a int(11) NO PRI NULL auto_increment
333 b char(254) YES NULL
334 DESCRIBE t2 b;
335 Field Type Null Key Default Extra
336 b char(254) YES NULL
337
338 ******************** USE ********************
339 USE test_rpl;
340
341 ******************** TRANSACTION ********************
342 START TRANSACTION;
343 INSERT INTO t1 VALUES (1, 'start');
344 COMMIT;
345 SELECT COUNT(*) FROM t1;
346 COUNT(*)
347 1
348 SELECT * FROM t1 ORDER BY a;
349 a b
350 1 start
351 SELECT COUNT(*) FROM t2;
352 COUNT(*)
353 0
354 SELECT * FROM t2 ORDER BY a;
355 a b
356 connection slave;
357 USE test_rpl;
358 SELECT COUNT(*) FROM t1;
359 COUNT(*)
360 1
361 SELECT * FROM t1 ORDER BY a;
362 a b
363 1 start
364 SELECT COUNT(*) FROM t2;
365 COUNT(*)
366 0
367 SELECT * FROM t2 ORDER BY a;
368 a b
369 connection master;
370 START TRANSACTION;
371 INSERT INTO t1 VALUES (2, 'rollback');
372 ROLLBACK;
373 SELECT COUNT(*) FROM t1;
374 COUNT(*)
375 1
376 SELECT * FROM t1 ORDER BY a;
377 a b
378 1 start
379 SELECT COUNT(*) FROM t2;
380 COUNT(*)
381 0
382 SELECT * FROM t2 ORDER BY a;
383 a b
384 connection slave;
385 USE test_rpl;
386 SELECT COUNT(*) FROM t1;
387 COUNT(*)
388 1
389 SELECT * FROM t1 ORDER BY a;
390 a b
391 1 start
392 SELECT COUNT(*) FROM t2;
393 COUNT(*)
394 0
395 SELECT * FROM t2 ORDER BY a;
396 a b
397 connection master;
398 START TRANSACTION;
399 INSERT INTO t1 VALUES (3, 'before savepoint s1');
400 SAVEPOINT s1;
401 INSERT INTO t1 VALUES (4, 'after savepoint s1');
402 ROLLBACK TO SAVEPOINT s1;
403 SELECT COUNT(*) FROM t1;
404 COUNT(*)
405 2
406 SELECT * FROM t1 ORDER BY a;
407 a b
408 1 start
409 3 before savepoint s1
410 SELECT COUNT(*) FROM t2;
411 COUNT(*)
412 0
413 SELECT * FROM t2 ORDER BY a;
414 a b
415 connection slave;
416 USE test_rpl;
417 SELECT COUNT(*) FROM t1;
418 COUNT(*)
419 1
420 SELECT * FROM t1 ORDER BY a;
421 a b
422 1 start
423 SELECT COUNT(*) FROM t2;
424 COUNT(*)
425 0
426 SELECT * FROM t2 ORDER BY a;
427 a b
428 connection master;
429 START TRANSACTION;
430 INSERT INTO t1 VALUES (5, 'before savepoint s2');
431 SAVEPOINT s2;
432 INSERT INTO t1 VALUES (6, 'after savepoint s2');
433 INSERT INTO t1 VALUES (7, CONCAT('with SYS_GUID() ',SYS_GUID()));
434 RELEASE SAVEPOINT s2;
435 COMMIT;
436 DELETE FROM t1 WHERE a = 7;
437 SELECT COUNT(*) FROM t1;
438 COUNT(*)
439 4
440 SELECT * FROM t1 ORDER BY a;
441 a b
442 1 start
443 3 before savepoint s1
444 5 before savepoint s2
445 6 after savepoint s2
446 SELECT COUNT(*) FROM t2;
447 COUNT(*)
448 0
449 SELECT * FROM t2 ORDER BY a;
450 a b
451 connection slave;
452 USE test_rpl;
453 SELECT COUNT(*) FROM t1;
454 COUNT(*)
455 4
456 SELECT * FROM t1 ORDER BY a;
457 a b
458 1 start
459 3 before savepoint s1
460 5 before savepoint s2
461 6 after savepoint s2
462 SELECT COUNT(*) FROM t2;
463 COUNT(*)
464 0
465 SELECT * FROM t2 ORDER BY a;
466 a b
467 connection master;
468 DELETE FROM t1;
469 DELETE FROM t2;
470
471 ******************** LOCK TABLES ********************
472 LOCK TABLES t1 READ , t2 READ;
473 UNLOCK TABLES;
474
475 ******************** TRANSACTION ISOLATION LEVEL ********************
476 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
477 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
478 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
479 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
480
481 ******************** CREATE USER ********************
482 CREATE USER 'user_test_rpl'@'localhost' IDENTIFIED BY PASSWORD '*1111111111111111111111111111111111111111';
483 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
484 Host User Password plugin authentication_string Select_priv
485 localhost user_test_rpl *1111111111111111111111111111111111111111 mysql_native_password *1111111111111111111111111111111111111111 N
486 connection slave;
487 USE test_rpl;
488 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
489 Host User Password plugin authentication_string Select_priv
490 localhost user_test_rpl *1111111111111111111111111111111111111111 mysql_native_password *1111111111111111111111111111111111111111 N
491 connection master;
492
493 ******************** GRANT ********************
494 GRANT SELECT ON *.* TO 'user_test_rpl'@'localhost';
495 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
496 Host User Password plugin authentication_string Select_priv
497 localhost user_test_rpl *1111111111111111111111111111111111111111 mysql_native_password *1111111111111111111111111111111111111111 Y
498 connection slave;
499 USE test_rpl;
500 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
501 Host User Password plugin authentication_string Select_priv
502 localhost user_test_rpl *1111111111111111111111111111111111111111 mysql_native_password *1111111111111111111111111111111111111111 Y
503 connection master;
504
505 ******************** REVOKE ********************
506 REVOKE SELECT ON *.* FROM 'user_test_rpl'@'localhost';
507 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
508 Host User Password plugin authentication_string Select_priv
509 localhost user_test_rpl *1111111111111111111111111111111111111111 mysql_native_password *1111111111111111111111111111111111111111 N
510 connection slave;
511 USE test_rpl;
512 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
513 Host User Password plugin authentication_string Select_priv
514 localhost user_test_rpl *1111111111111111111111111111111111111111 mysql_native_password *1111111111111111111111111111111111111111 N
515 connection master;
516
517 ******************** SET PASSWORD ********************
518 SET PASSWORD FOR 'user_test_rpl'@'localhost' = '*0000000000000000000000000000000000000000';
519 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
520 Host User Password plugin authentication_string Select_priv
521 localhost user_test_rpl *0000000000000000000000000000000000000000 mysql_native_password *0000000000000000000000000000000000000000 N
522 connection slave;
523 USE test_rpl;
524 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
525 Host User Password plugin authentication_string Select_priv
526 localhost user_test_rpl *0000000000000000000000000000000000000000 mysql_native_password *0000000000000000000000000000000000000000 N
527 connection master;
528
529 ******************** RENAME USER ********************
530 RENAME USER 'user_test_rpl'@'localhost' TO 'user_test_rpl_2'@'localhost';
531 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
532 Host User Password plugin authentication_string Select_priv
533 localhost user_test_rpl_2 *0000000000000000000000000000000000000000 mysql_native_password *0000000000000000000000000000000000000000 N
534 connection slave;
535 USE test_rpl;
536 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
537 Host User Password plugin authentication_string Select_priv
538 localhost user_test_rpl_2 *0000000000000000000000000000000000000000 mysql_native_password *0000000000000000000000000000000000000000 N
539 connection master;
540
541 ******************** DROP USER ********************
542 DROP USER 'user_test_rpl_2'@'localhost';
543 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
544 Host User Password plugin authentication_string Select_priv
545 connection slave;
546 USE test_rpl;
547 SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
548 Host User Password plugin authentication_string Select_priv
549 connection master;
550 INSERT INTO t1 VALUES(100, 'test');
551
552 ******************** ANALYZE ********************
553 ANALYZE TABLE t1;
554 Table Op Msg_type Msg_text
555 test_rpl.t1 analyze status Engine-independent statistics collected
556 test_rpl.t1 analyze status OK
557
558 ******************** CHECK TABLE ********************
559 CHECK TABLE t1;
560 Table Op Msg_type Msg_text
561 test_rpl.t1 check status OK
562
563 ******************** CHECKSUM TABLE ********************
564 CHECKSUM TABLE t1;
565 Table Checksum
566 test_rpl.t1 3445341981
567
568 ******************** OPTIMIZE TABLE ********************
569 OPTIMIZE TABLE t1;
570 Table Op Msg_type Msg_text
571 test_rpl.t1 optimize note Table does not support optimize, doing recreate + analyze instead
572 test_rpl.t1 optimize status OK
573
574 ******************** REPAIR TABLE ********************
575 REPAIR TABLE t1;
576 Table Op Msg_type Msg_text
577 test_rpl.t1 repair status OK
578
579 ******************** SET VARIABLE ********************
580 SET @test_rpl_var = 1;
581 SHOW VARIABLES LIKE 'test_rpl_var';
582 Variable_name Value
583
584 ******************** SHOW ********************
585 SHOW DATABASES LIKE 'test_rpl%';
586 Database (test_rpl%)
587 test_rpl
588 connection slave;
589 SHOW DATABASES LIKE 'test_rpl%';
590 Database (test_rpl%)
591 test_rpl
592 connection master;
593
594 ******************** PROCEDURE ********************
595 CREATE PROCEDURE p1 ()
596 BEGIN
597 UPDATE t1 SET b = 'test' WHERE a = 201;
598 END|
599 CREATE PROCEDURE p2 ()
600 BEGIN
601 UPDATE t1 SET b = SYS_GUID() WHERE a = 202;
602 END|
603 INSERT INTO t1 VALUES(201, 'test 201');
604 CALL p1();
605 INSERT INTO t1 VALUES(202, 'test 202');
606 CALL p2();
607 DELETE FROM t1 WHERE a = 202;
608 SELECT COUNT(*) FROM t1;
609 COUNT(*)
610 2
611 SELECT * FROM t1 ORDER BY a;
612 a b
613 100 test
614 201 test
615 SELECT COUNT(*) FROM t2;
616 COUNT(*)
617 0
618 SELECT * FROM t2 ORDER BY a;
619 a b
620 connection slave;
621 USE test_rpl;
622 SELECT COUNT(*) FROM t1;
623 COUNT(*)
624 2
625 SELECT * FROM t1 ORDER BY a;
626 a b
627 100 test
628 201 test
629 SELECT COUNT(*) FROM t2;
630 COUNT(*)
631 0
632 SELECT * FROM t2 ORDER BY a;
633 a b
634 connection master;
635 ALTER PROCEDURE p1 COMMENT 'p1';
636 DROP PROCEDURE p1;
637 DROP PROCEDURE p2;
638 DELETE FROM t1;
639 DELETE FROM t2;
640
641 ******************** TRIGGER ********************
642 CREATE TRIGGER tr1 BEFORE INSERT ON t1
643 FOR EACH ROW BEGIN
644 INSERT INTO t2 SET a = NEW.a, b = NEW.b;
645 END|
646 INSERT INTO t1 VALUES (1, 'test');
647 SELECT COUNT(*) FROM t1;
648 COUNT(*)
649 1
650 SELECT * FROM t1 ORDER BY a;
651 a b
652 1 test
653 SELECT COUNT(*) FROM t2;
654 COUNT(*)
655 1
656 SELECT * FROM t2 ORDER BY a;
657 a b
658 1 test
659 connection slave;
660 USE test_rpl;
661 SELECT COUNT(*) FROM t1;
662 COUNT(*)
663 1
664 SELECT * FROM t1 ORDER BY a;
665 a b
666 1 test
667 SELECT COUNT(*) FROM t2;
668 COUNT(*)
669 1
670 SELECT * FROM t2 ORDER BY a;
671 a b
672 1 test
673 connection master;
674 DELETE FROM t1;
675 DELETE FROM t2;
676 DROP TRIGGER tr1;
677
678
679 ******************** EVENTS ********************
680 INSERT INTO t1 VALUES(1, 'test1');
681 CREATE EVENT e1 ON SCHEDULE EVERY '1' SECOND COMMENT 'e_second_comment' DO DELETE FROM t1;
682 Warnings:
683 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
684 SHOW EVENTS;
685 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
686 test_rpl e1 root@localhost SYSTEM RECURRING NULL 1 # # NULL ENABLED 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
687 connection slave;
688 USE test_rpl;
689 SHOW EVENTS;
690 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
691 test_rpl e1 root@localhost SYSTEM RECURRING NULL 1 # # NULL SLAVESIDE_DISABLED 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
692 connection master;
693 SELECT COUNT(*) FROM t1;
694 COUNT(*)
695 1
696 SELECT * FROM t1 ORDER BY a;
697 a b
698 1 test1
699 SELECT COUNT(*) FROM t2;
700 COUNT(*)
701 0
702 SELECT * FROM t2 ORDER BY a;
703 a b
704 connection slave;
705 USE test_rpl;
706 SELECT COUNT(*) FROM t1;
707 COUNT(*)
708 1
709 SELECT * FROM t1 ORDER BY a;
710 a b
711 1 test1
712 SELECT COUNT(*) FROM t2;
713 COUNT(*)
714 0
715 SELECT * FROM t2 ORDER BY a;
716 a b
717 connection master;
718 SELECT COUNT(*) FROM t1;
719 COUNT(*)
720 1
721 SELECT * FROM t1 ORDER BY a;
722 a b
723 1 test1
724 SELECT COUNT(*) FROM t2;
725 COUNT(*)
726 0
727 SELECT * FROM t2 ORDER BY a;
728 a b
729 connection slave;
730 USE test_rpl;
731 SELECT COUNT(*) FROM t1;
732 COUNT(*)
733 1
734 SELECT * FROM t1 ORDER BY a;
735 a b
736 1 test1
737 SELECT COUNT(*) FROM t2;
738 COUNT(*)
739 0
740 SELECT * FROM t2 ORDER BY a;
741 a b
742 connection master;
743 ALTER EVENT e1 RENAME TO e2;
744 SHOW EVENTS;
745 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
746 test_rpl e2 root@localhost SYSTEM RECURRING NULL 1 # # NULL ENABLED 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
747 connection slave;
748 USE test_rpl;
749 SHOW EVENTS;
750 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
751 test_rpl e2 root@localhost SYSTEM RECURRING NULL 1 # # NULL SLAVESIDE_DISABLED 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
752 connection master;
753 SELECT COUNT(*) FROM t1;
754 COUNT(*)
755 1
756 SELECT * FROM t1 ORDER BY a;
757 a b
758 1 test1
759 SELECT COUNT(*) FROM t2;
760 COUNT(*)
761 0
762 SELECT * FROM t2 ORDER BY a;
763 a b
764 connection slave;
765 USE test_rpl;
766 SELECT COUNT(*) FROM t1;
767 COUNT(*)
768 1
769 SELECT * FROM t1 ORDER BY a;
770 a b
771 1 test1
772 SELECT COUNT(*) FROM t2;
773 COUNT(*)
774 0
775 SELECT * FROM t2 ORDER BY a;
776 a b
777 connection master;
778 DROP EVENT e2;
779 SHOW EVENTS;
780 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
781 connection slave;
782 USE test_rpl;
783 SHOW EVENTS;
784 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
785 connection master;
786 DELETE FROM t1;
787 DELETE FROM t2;
788
789 ******************** VIEWS ********************
790 INSERT INTO t1 VALUES(1, 'test1');
791 INSERT INTO t1 VALUES(2, 'test2');
792 CREATE VIEW v1 AS SELECT * FROM t1 WHERE a = 1;
793 CREATE VIEW v2 AS SELECT * FROM t1 WHERE b <> SYS_GUID();
794 SHOW CREATE VIEW v1;
795 View Create View character_set_client collation_connection
796 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where `t1`.`a` = 1 latin1 latin1_swedish_ci
797 SELECT * FROM v1 ORDER BY a;
798 a b
799 1 test1
800 connection slave;
801 USE test_rpl;
802 SHOW CREATE VIEW v1;
803 View Create View character_set_client collation_connection
804 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where `t1`.`a` = 1 latin1 latin1_swedish_ci
805 SELECT * FROM v1 ORDER BY a;
806 a b
807 1 test1
808 connection master;
809 ALTER VIEW v1 AS SELECT * FROM t1 WHERE a = 2;
810 SHOW CREATE VIEW v1;
811 View Create View character_set_client collation_connection
812 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where `t1`.`a` = 2 latin1 latin1_swedish_ci
813 SELECT * FROM v1 ORDER BY a;
814 a b
815 2 test2
816 connection slave;
817 USE test_rpl;
818 SHOW CREATE VIEW v1;
819 View Create View character_set_client collation_connection
820 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where `t1`.`a` = 2 latin1 latin1_swedish_ci
821 SELECT * FROM v1 ORDER BY a;
822 a b
823 2 test2
824 connection master;
825 DROP VIEW v1;
826 DROP VIEW v2;
827 DELETE FROM t1;
828 DELETE FROM t2;
829
830
831 ******************** SHOW BINLOG EVENTS ********************
832 include/show_binlog_events.inc
833 Log_name Pos Event_type Server_id End_log_pos Info
834 master-bin.000001 # Gtid # # GTID #-#-#
835 master-bin.000001 # Query # # CREATE DATABASE test_rpl
836 master-bin.000001 # Gtid # # GTID #-#-#
837 master-bin.000001 # Query # # use `test_rpl`; CREATE TABLE t1 (a int auto_increment not null, b char(254), PRIMARY KEY(a)) ENGINE=innodb
838 master-bin.000001 # Gtid # # GTID #-#-#
839 master-bin.000001 # Query # # use `test_rpl`; CREATE TABLE t2 (a int auto_increment not null, b char(254), PRIMARY KEY(a)) ENGINE=innodb
840 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
841 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
842 master-bin.000001 # Xid # # COMMIT /* XID */
843 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
844 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(2, 't1, text 2')
845 master-bin.000001 # Xid # # COMMIT /* XID */
846 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
847 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
848 master-bin.000001 # Xid # # COMMIT /* XID */
849 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
850 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1 WHERE a = 1
851 master-bin.000001 # Xid # # COMMIT /* XID */
852 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
853 master-bin.000001 # Annotate_rows # # DELETE FROM t2 WHERE b <> SYS_GUID()
854 master-bin.000001 # Table_map # # table_id: # (test_rpl.t2)
855 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
856 master-bin.000001 # Xid # # COMMIT /* XID */
857 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
858 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
859 master-bin.000001 # Xid # # COMMIT /* XID */
860 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
861 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
862 master-bin.000001 # Xid # # COMMIT /* XID */
863 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
864 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
865 master-bin.000001 # Xid # # COMMIT /* XID */
866 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
867 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES(2, SYS_GUID())
868 master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
869 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
870 master-bin.000001 # Xid # # COMMIT /* XID */
871 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
872 master-bin.000001 # Annotate_rows # # INSERT INTO t2 SELECT * FROM t1
873 master-bin.000001 # Table_map # # table_id: # (test_rpl.t2)
874 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
875 master-bin.000001 # Xid # # COMMIT /* XID */
876 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
877 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t2 VALUES (1, 't1, text 1') ON DUPLICATE KEY UPDATE b = 't2, text 1'
878 master-bin.000001 # Xid # # COMMIT /* XID */
879 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
880 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1 WHERE a = 2
881 master-bin.000001 # Xid # # COMMIT /* XID */
882 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
883 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2 WHERE a = 2
884 master-bin.000001 # Xid # # COMMIT /* XID */
885 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
886 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
887 master-bin.000001 # Xid # # COMMIT /* XID */
888 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
889 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
890 master-bin.000001 # Xid # # COMMIT /* XID */
891 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
892 master-bin.000001 # Annotate_rows # # LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/rpl_mixed.dat' INTO TABLE t1 FIELDS TERMINATED BY '|'
893 master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
894 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
895 master-bin.000001 # Xid # # COMMIT /* XID */
896 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
897 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
898 master-bin.000001 # Xid # # COMMIT /* XID */
899 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
900 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
901 master-bin.000001 # Xid # # COMMIT /* XID */
902 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
903 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
904 master-bin.000001 # Xid # # COMMIT /* XID */
905 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
906 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(2, 't1, text 2')
907 master-bin.000001 # Xid # # COMMIT /* XID */
908 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
909 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(3, 't1, text 3')
910 master-bin.000001 # Xid # # COMMIT /* XID */
911 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
912 master-bin.000001 # Query # # use `test_rpl`; REPLACE INTO t1 VALUES(1, 't1, text 11')
913 master-bin.000001 # Xid # # COMMIT /* XID */
914 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
915 master-bin.000001 # Annotate_rows # # REPLACE INTO t1 VALUES(2, SYS_GUID())
916 master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
917 master-bin.000001 # Update_rows_v1 # # table_id: # flags: STMT_END_F
918 master-bin.000001 # Xid # # COMMIT /* XID */
919 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
920 master-bin.000001 # Query # # use `test_rpl`; REPLACE INTO t1 SET a=3, b='t1, text 33'
921 master-bin.000001 # Xid # # COMMIT /* XID */
922 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
923 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1 WHERE a = 2
924 master-bin.000001 # Xid # # COMMIT /* XID */
925 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
926 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
927 master-bin.000001 # Xid # # COMMIT /* XID */
928 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
929 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
930 master-bin.000001 # Xid # # COMMIT /* XID */
931 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
932 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
933 master-bin.000001 # Xid # # COMMIT /* XID */
934 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
935 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
936 master-bin.000001 # Xid # # COMMIT /* XID */
937 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
938 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
939 master-bin.000001 # Xid # # COMMIT /* XID */
940 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
941 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 'CCC')
942 master-bin.000001 # Xid # # COMMIT /* XID */
943 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
944 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(2, 'DDD')
945 master-bin.000001 # Xid # # COMMIT /* XID */
946 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
947 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t2 VALUES(1, 'DDD')
948 master-bin.000001 # Xid # # COMMIT /* XID */
949 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
950 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t2 VALUES(2, 'CCC')
951 master-bin.000001 # Xid # # COMMIT /* XID */
952 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
953 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
954 master-bin.000001 # Xid # # COMMIT /* XID */
955 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
956 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
957 master-bin.000001 # Xid # # COMMIT /* XID */
958 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
959 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
960 master-bin.000001 # Xid # # COMMIT /* XID */
961 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
962 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
963 master-bin.000001 # Xid # # COMMIT /* XID */
964 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
965 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
966 master-bin.000001 # Xid # # COMMIT /* XID */
967 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
968 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
969 master-bin.000001 # Xid # # COMMIT /* XID */
970 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
971 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
972 master-bin.000001 # Xid # # COMMIT /* XID */
973 master-bin.000001 # Gtid # # GTID #-#-#
974 master-bin.000001 # Query # # use `test_rpl`; TRUNCATE t1
975 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
976 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
977 master-bin.000001 # Xid # # COMMIT /* XID */
978 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
979 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
980 master-bin.000001 # Xid # # COMMIT /* XID */
981 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
982 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
983 master-bin.000001 # Xid # # COMMIT /* XID */
984 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
985 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
986 master-bin.000001 # Xid # # COMMIT /* XID */
987 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
988 master-bin.000001 # Query # # use `test_rpl`; UPDATE t1 SET b = 't1, text 1 updated' WHERE a = 1
989 master-bin.000001 # Xid # # COMMIT /* XID */
990 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
991 master-bin.000001 # Query # # use `test_rpl`; UPDATE t1, t2 SET t1.b = 'test', t2.b = 'test'
992 master-bin.000001 # Xid # # COMMIT /* XID */
993 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
994 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
995 master-bin.000001 # Xid # # COMMIT /* XID */
996 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
997 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
998 master-bin.000001 # Xid # # COMMIT /* XID */
999 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1000 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES (1, 'start')
1001 master-bin.000001 # Xid # # COMMIT /* XID */
1002 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1003 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES (3, 'before savepoint s1')
1004 master-bin.000001 # Query # # SAVEPOINT `s1`
1005 master-bin.000001 # Xid # # COMMIT /* XID */
1006 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1007 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES (5, 'before savepoint s2')
1008 master-bin.000001 # Query # # SAVEPOINT `s2`
1009 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES (6, 'after savepoint s2')
1010 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (7, CONCAT('with SYS_GUID() ',SYS_GUID()))
1011 master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
1012 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1013 master-bin.000001 # Xid # # COMMIT /* XID */
1014 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1015 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1 WHERE a = 7
1016 master-bin.000001 # Xid # # COMMIT /* XID */
1017 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1018 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
1019 master-bin.000001 # Xid # # COMMIT /* XID */
1020 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1021 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
1022 master-bin.000001 # Xid # # COMMIT /* XID */
1023 master-bin.000001 # Gtid # # GTID #-#-#
1024 master-bin.000001 # Query # # use `test_rpl`; CREATE USER 'user_test_rpl'@'localhost' IDENTIFIED BY PASSWORD '*1111111111111111111111111111111111111111'
1025 master-bin.000001 # Gtid # # GTID #-#-#
1026 master-bin.000001 # Query # # use `test_rpl`; GRANT SELECT ON *.* TO 'user_test_rpl'@'localhost'
1027 master-bin.000001 # Gtid # # GTID #-#-#
1028 master-bin.000001 # Query # # use `test_rpl`; REVOKE SELECT ON *.* FROM 'user_test_rpl'@'localhost'
1029 master-bin.000001 # Gtid # # GTID #-#-#
1030 master-bin.000001 # Query # # use `test_rpl`; SET PASSWORD FOR 'user_test_rpl'@'localhost'='*0000000000000000000000000000000000000000'
1031 master-bin.000001 # Gtid # # GTID #-#-#
1032 master-bin.000001 # Query # # use `test_rpl`; RENAME USER 'user_test_rpl'@'localhost' TO 'user_test_rpl_2'@'localhost'
1033 master-bin.000001 # Gtid # # GTID #-#-#
1034 master-bin.000001 # Query # # use `test_rpl`; DROP USER 'user_test_rpl_2'@'localhost'
1035 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1036 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(100, 'test')
1037 master-bin.000001 # Xid # # COMMIT /* XID */
1038 master-bin.000001 # Gtid # # GTID #-#-#
1039 master-bin.000001 # Query # # use `test_rpl`; ANALYZE TABLE t1
1040 master-bin.000001 # Gtid # # GTID #-#-#
1041 master-bin.000001 # Query # # use `test_rpl`; OPTIMIZE TABLE t1
1042 master-bin.000001 # Gtid # # GTID #-#-#
1043 master-bin.000001 # Query # # use `test_rpl`; REPAIR TABLE t1
1044 master-bin.000001 # Gtid # # GTID #-#-#
1045 master-bin.000001 # Query # # use `test_rpl`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
1046 BEGIN
1047 UPDATE t1 SET b = 'test' WHERE a = 201;
1048 END
1049 master-bin.000001 # Gtid # # GTID #-#-#
1050 master-bin.000001 # Query # # use `test_rpl`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`()
1051 BEGIN
1052 UPDATE t1 SET b = SYS_GUID() WHERE a = 202;
1053 END
1054 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1055 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(201, 'test 201')
1056 master-bin.000001 # Xid # # COMMIT /* XID */
1057 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1058 master-bin.000001 # Query # # use `test_rpl`; UPDATE t1 SET b = 'test' WHERE a = 201
1059 master-bin.000001 # Xid # # COMMIT /* XID */
1060 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1061 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(202, 'test 202')
1062 master-bin.000001 # Xid # # COMMIT /* XID */
1063 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1064 master-bin.000001 # Annotate_rows # # UPDATE t1 SET b = SYS_GUID() WHERE a = 202
1065 master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
1066 master-bin.000001 # Update_rows_v1 # # table_id: # flags: STMT_END_F
1067 master-bin.000001 # Xid # # COMMIT /* XID */
1068 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1069 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1 WHERE a = 202
1070 master-bin.000001 # Xid # # COMMIT /* XID */
1071 master-bin.000001 # Gtid # # GTID #-#-#
1072 master-bin.000001 # Query # # use `test_rpl`; ALTER PROCEDURE p1 COMMENT 'p1'
1073 master-bin.000001 # Gtid # # GTID #-#-#
1074 master-bin.000001 # Query # # use `test_rpl`; DROP PROCEDURE p1
1075 master-bin.000001 # Gtid # # GTID #-#-#
1076 master-bin.000001 # Query # # use `test_rpl`; DROP PROCEDURE p2
1077 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1078 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
1079 master-bin.000001 # Xid # # COMMIT /* XID */
1080 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1081 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
1082 master-bin.000001 # Xid # # COMMIT /* XID */
1083 master-bin.000001 # Gtid # # GTID #-#-#
1084 master-bin.000001 # Query # # use `test_rpl`; CREATE DEFINER=`root`@`localhost` TRIGGER tr1 BEFORE INSERT ON t1
1085 FOR EACH ROW BEGIN
1086 INSERT INTO t2 SET a = NEW.a, b = NEW.b;
1087 END
1088 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1089 master-bin.000001 # Annotate_rows # # INSERT INTO t2 SET a = NEW.a, b = NEW.b
1090 master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
1091 master-bin.000001 # Table_map # # table_id: # (test_rpl.t2)
1092 master-bin.000001 # Write_rows_v1 # # table_id: #
1093 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1094 master-bin.000001 # Xid # # COMMIT /* XID */
1095 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1096 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
1097 master-bin.000001 # Xid # # COMMIT /* XID */
1098 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1099 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
1100 master-bin.000001 # Xid # # COMMIT /* XID */
1101 master-bin.000001 # Gtid # # GTID #-#-#
1102 master-bin.000001 # Query # # use `test_rpl`; DROP TRIGGER tr1
1103 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1104 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 'test1')
1105 master-bin.000001 # Xid # # COMMIT /* XID */
1106 master-bin.000001 # Gtid # # GTID #-#-#
1107 master-bin.000001 # Query # # use `test_rpl`; CREATE DEFINER=`root`@`localhost` EVENT e1 ON SCHEDULE EVERY '1' SECOND COMMENT 'e_second_comment' DO DELETE FROM t1
1108 master-bin.000001 # Gtid # # GTID #-#-#
1109 master-bin.000001 # Query # # use `test_rpl`; ALTER EVENT e1 RENAME TO e2
1110 master-bin.000001 # Gtid # # GTID #-#-#
1111 master-bin.000001 # Query # # use `test_rpl`; DROP EVENT e2
1112 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1113 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
1114 master-bin.000001 # Xid # # COMMIT /* XID */
1115 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1116 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
1117 master-bin.000001 # Xid # # COMMIT /* XID */
1118 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1119 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 'test1')
1120 master-bin.000001 # Xid # # COMMIT /* XID */
1121 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1122 master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(2, 'test2')
1123 master-bin.000001 # Xid # # COMMIT /* XID */
1124 master-bin.000001 # Gtid # # GTID #-#-#
1125 master-bin.000001 # Query # # use `test_rpl`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS SELECT * FROM t1 WHERE a = 1
1126 master-bin.000001 # Gtid # # GTID #-#-#
1127 master-bin.000001 # Query # # use `test_rpl`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS SELECT * FROM t1 WHERE b <> SYS_GUID()
1128 master-bin.000001 # Gtid # # GTID #-#-#
1129 master-bin.000001 # Query # # use `test_rpl`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS SELECT * FROM t1 WHERE a = 2
1130 master-bin.000001 # Gtid # # GTID #-#-#
1131 master-bin.000001 # Query # # use `test_rpl`; DROP VIEW v1
1132 master-bin.000001 # Gtid # # GTID #-#-#
1133 master-bin.000001 # Query # # use `test_rpl`; DROP VIEW v2
1134 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1135 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1
1136 master-bin.000001 # Xid # # COMMIT /* XID */
1137 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1138 master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
1139 master-bin.000001 # Xid # # COMMIT /* XID */
1140 connection slave;
1141 connection master;
1142 drop database test_rpl;
1143 connection slave;
1144 include/rpl_end.inc