Debian Codegraph @

mysql-test/suite/binlog/r/binlog_drop_if_exists.result

raw
1 RESET MASTER;
2 DROP PROCEDURE IF EXISTS db_bug_13684.p;
3 DROP FUNCTION IF EXISTS db_bug_13684.f;
4 DROP TRIGGER IF EXISTS db_bug_13684.tr;
5 DROP VIEW IF EXISTS db_bug_13684.v;
6 DROP EVENT IF EXISTS db_bug_13684.e;
7 DROP TABLE IF EXISTS db_bug_13684.t;
8 DROP DATABASE IF EXISTS db_bug_13684;
9 include/show_binlog_events.inc
10 Log_name Pos Event_type Server_id End_log_pos Info
11 binlog.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
12 binlog.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
13 binlog.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
14 binlog.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
15 binlog.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
16 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `db_bug_13684`.`t` /* generated by server */
17 binlog.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
18 CREATE DATABASE db_bug_13684;
19 CREATE TABLE db_bug_13684.t (a int);
20 CREATE EVENT db_bug_13684.e
21 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
22 DO
23 UPDATE db_bug_13684.t SET a = a + 1;
24 CREATE VIEW db_bug_13684.v
25 AS SELECT * FROM db_bug_13684.t;
26 CREATE TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
27 FOR EACH ROW BEGIN
28 END;
29 CREATE PROCEDURE db_bug_13684.p (OUT p1 INT)
30 BEGIN
31 END;
32 CREATE FUNCTION db_bug_13684.f (s CHAR(20))
33 RETURNS CHAR(50) DETERMINISTIC
34 RETURN s;
35 include/show_binlog_events.inc
36 Log_name Pos Event_type Server_id End_log_pos Info
37 binlog.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
38 binlog.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
39 binlog.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
40 binlog.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
41 binlog.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
42 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `db_bug_13684`.`t` /* generated by server */
43 binlog.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
44 binlog.000001 # Query # # CREATE DATABASE db_bug_13684
45 binlog.000001 # Query # # use `test`; CREATE TABLE db_bug_13684.t (a int)
46 binlog.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_bug_13684.e
47 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
48 DO
49 UPDATE db_bug_13684.t SET a = a + 1
50 binlog.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `db_bug_13684`.`v` AS SELECT * FROM db_bug_13684.t
51 binlog.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
52 FOR EACH ROW BEGIN
53 END
54 binlog.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `db_bug_13684`.`p`(OUT p1 INT)
55 BEGIN
56 END
57 binlog.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_bug_13684`.`f`(s CHAR(20)) RETURNS char(50) CHARSET utf8mb4
58 DETERMINISTIC
59 RETURN s
60 DROP PROCEDURE IF EXISTS db_bug_13684.p;
61 DROP FUNCTION IF EXISTS db_bug_13684.f;
62 DROP TRIGGER IF EXISTS db_bug_13684.tr;
63 DROP VIEW IF EXISTS db_bug_13684.v;
64 DROP EVENT IF EXISTS db_bug_13684.e;
65 DROP TABLE IF EXISTS db_bug_13684.t;
66 DROP DATABASE IF EXISTS db_bug_13684;
67 include/show_binlog_events.inc
68 Log_name Pos Event_type Server_id End_log_pos Info
69 binlog.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
70 binlog.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
71 binlog.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
72 binlog.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
73 binlog.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
74 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `db_bug_13684`.`t` /* generated by server */
75 binlog.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
76 binlog.000001 # Query # # CREATE DATABASE db_bug_13684
77 binlog.000001 # Query # # use `test`; CREATE TABLE db_bug_13684.t (a int)
78 binlog.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_bug_13684.e
79 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
80 DO
81 UPDATE db_bug_13684.t SET a = a + 1
82 binlog.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `db_bug_13684`.`v` AS SELECT * FROM db_bug_13684.t
83 binlog.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
84 FOR EACH ROW BEGIN
85 END
86 binlog.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `db_bug_13684`.`p`(OUT p1 INT)
87 BEGIN
88 END
89 binlog.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_bug_13684`.`f`(s CHAR(20)) RETURNS char(50) CHARSET utf8mb4
90 DETERMINISTIC
91 RETURN s
92 binlog.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
93 binlog.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
94 binlog.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
95 binlog.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
96 binlog.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
97 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `db_bug_13684`.`t` /* generated by server */
98 binlog.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684