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
show binlog events from <binlog_start>;
10
Log_name Pos Event_type Server_id End_log_pos Info
11
master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
12
master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
13
master-bin.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
14
master-bin.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
15
master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
16
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS db_bug_13684.t
17
master-bin.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
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
29
CREATE PROCEDURE db_bug_13684.p (OUT p1 INT)
32
CREATE FUNCTION db_bug_13684.f (s CHAR(20))
33
RETURNS CHAR(50) DETERMINISTIC
35
show binlog events from <binlog_start>;
36
Log_name Pos Event_type Server_id End_log_pos Info
37
master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
38
master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
39
master-bin.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
40
master-bin.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
41
master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
42
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS db_bug_13684.t
43
master-bin.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
44
master-bin.000001 # Query # # CREATE DATABASE db_bug_13684
45
master-bin.000001 # Query # # use `test`; CREATE TABLE db_bug_13684.t (a int)
46
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_bug_13684.e
47
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
49
UPDATE db_bug_13684.t SET a = a + 1
50
master-bin.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
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
54
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `db_bug_13684`.`p`(OUT p1 INT)
57
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_bug_13684`.`f`(s CHAR(20)) RETURNS char(50) CHARSET latin1
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
show binlog events from <binlog_start>;
68
Log_name Pos Event_type Server_id End_log_pos Info
69
master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
70
master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
71
master-bin.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
72
master-bin.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
73
master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
74
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS db_bug_13684.t
75
master-bin.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
76
master-bin.000001 # Query # # CREATE DATABASE db_bug_13684
77
master-bin.000001 # Query # # use `test`; CREATE TABLE db_bug_13684.t (a int)
78
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_bug_13684.e
79
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
81
UPDATE db_bug_13684.t SET a = a + 1
82
master-bin.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
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
86
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `db_bug_13684`.`p`(OUT p1 INT)
89
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_bug_13684`.`f`(s CHAR(20)) RETURNS char(50) CHARSET latin1
92
master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
93
master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
94
master-bin.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
95
master-bin.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
96
master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
97
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS db_bug_13684.t
98
master-bin.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684