Debian Codegraph @

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

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