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 master-bin.000001 # Gtid # # GTID #-#-#
12 master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
13 master-bin.000001 # Gtid # # GTID #-#-#
14 master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
15 master-bin.000001 # Gtid # # GTID #-#-#
16 master-bin.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
17 master-bin.000001 # Gtid # # GTID #-#-#
18 master-bin.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
19 master-bin.000001 # Gtid # # GTID #-#-#
20 master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
21 master-bin.000001 # Gtid # # GTID #-#-#
22 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `db_bug_13684`.`t` /* generated by server */
23 master-bin.000001 # Gtid # # GTID #-#-#
24 master-bin.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
25 CREATE DATABASE db_bug_13684;
26 CREATE TABLE db_bug_13684.t (a int);
27 CREATE EVENT db_bug_13684.e
28 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
29 DO
30 UPDATE db_bug_13684.t SET a = a + 1;
31 CREATE VIEW db_bug_13684.v
32 AS SELECT * FROM db_bug_13684.t;
33 CREATE TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
34 FOR EACH ROW BEGIN
35 END;
36 CREATE PROCEDURE db_bug_13684.p (OUT p1 INT)
37 BEGIN
38 END;
39 CREATE FUNCTION db_bug_13684.f (s CHAR(20))
40 RETURNS CHAR(50) DETERMINISTIC
41 RETURN s;
42 include/show_binlog_events.inc
43 Log_name Pos Event_type Server_id End_log_pos Info
44 master-bin.000001 # Gtid # # GTID #-#-#
45 master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
46 master-bin.000001 # Gtid # # GTID #-#-#
47 master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
48 master-bin.000001 # Gtid # # GTID #-#-#
49 master-bin.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
50 master-bin.000001 # Gtid # # GTID #-#-#
51 master-bin.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
52 master-bin.000001 # Gtid # # GTID #-#-#
53 master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
54 master-bin.000001 # Gtid # # GTID #-#-#
55 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `db_bug_13684`.`t` /* generated by server */
56 master-bin.000001 # Gtid # # GTID #-#-#
57 master-bin.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
58 master-bin.000001 # Gtid # # GTID #-#-#
59 master-bin.000001 # Query # # CREATE DATABASE db_bug_13684
60 master-bin.000001 # Gtid # # GTID #-#-#
61 master-bin.000001 # Query # # use `test`; CREATE TABLE db_bug_13684.t (a int)
62 master-bin.000001 # Gtid # # GTID #-#-#
63 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_bug_13684.e
64 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
65 DO
66 UPDATE db_bug_13684.t SET a = a + 1
67 master-bin.000001 # Gtid # # GTID #-#-#
68 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
69 master-bin.000001 # Gtid # # GTID #-#-#
70 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
71 FOR EACH ROW BEGIN
72 END
73 master-bin.000001 # Gtid # # GTID #-#-#
74 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `db_bug_13684`.`p`(OUT p1 INT)
75 BEGIN
76 END
77 master-bin.000001 # Gtid # # GTID #-#-#
78 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_bug_13684`.`f`(s CHAR(20)) RETURNS char(50) CHARSET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci
79 DETERMINISTIC
80 RETURN s
81 DROP PROCEDURE IF EXISTS db_bug_13684.p;
82 DROP FUNCTION IF EXISTS db_bug_13684.f;
83 DROP TRIGGER IF EXISTS db_bug_13684.tr;
84 DROP VIEW IF EXISTS db_bug_13684.v;
85 DROP EVENT IF EXISTS db_bug_13684.e;
86 DROP TABLE IF EXISTS db_bug_13684.t;
87 DROP DATABASE IF EXISTS db_bug_13684;
88 include/show_binlog_events.inc
89 Log_name Pos Event_type Server_id End_log_pos Info
90 master-bin.000001 # Gtid # # GTID #-#-#
91 master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
92 master-bin.000001 # Gtid # # GTID #-#-#
93 master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
94 master-bin.000001 # Gtid # # GTID #-#-#
95 master-bin.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
96 master-bin.000001 # Gtid # # GTID #-#-#
97 master-bin.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
98 master-bin.000001 # Gtid # # GTID #-#-#
99 master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
100 master-bin.000001 # Gtid # # GTID #-#-#
101 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `db_bug_13684`.`t` /* generated by server */
102 master-bin.000001 # Gtid # # GTID #-#-#
103 master-bin.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
104 master-bin.000001 # Gtid # # GTID #-#-#
105 master-bin.000001 # Query # # CREATE DATABASE db_bug_13684
106 master-bin.000001 # Gtid # # GTID #-#-#
107 master-bin.000001 # Query # # use `test`; CREATE TABLE db_bug_13684.t (a int)
108 master-bin.000001 # Gtid # # GTID #-#-#
109 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_bug_13684.e
110 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
111 DO
112 UPDATE db_bug_13684.t SET a = a + 1
113 master-bin.000001 # Gtid # # GTID #-#-#
114 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
115 master-bin.000001 # Gtid # # GTID #-#-#
116 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
117 FOR EACH ROW BEGIN
118 END
119 master-bin.000001 # Gtid # # GTID #-#-#
120 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `db_bug_13684`.`p`(OUT p1 INT)
121 BEGIN
122 END
123 master-bin.000001 # Gtid # # GTID #-#-#
124 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_bug_13684`.`f`(s CHAR(20)) RETURNS char(50) CHARSET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci
125 DETERMINISTIC
126 RETURN s
127 master-bin.000001 # Gtid # # GTID #-#-#
128 master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
129 master-bin.000001 # Gtid # # GTID #-#-#
130 master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
131 master-bin.000001 # Gtid # # GTID #-#-#
132 master-bin.000001 # Query # # use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
133 master-bin.000001 # Gtid # # GTID #-#-#
134 master-bin.000001 # Query # # use `test`; DROP VIEW IF EXISTS db_bug_13684.v
135 master-bin.000001 # Gtid # # GTID #-#-#
136 master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS db_bug_13684.e
137 master-bin.000001 # Gtid # # GTID #-#-#
138 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `db_bug_13684`.`t` /* generated by server */
139 master-bin.000001 # Gtid # # GTID #-#-#
140 master-bin.000001 # Query # # DROP DATABASE IF EXISTS db_bug_13684
141 CREATE TABLE t1(id int);
142 DROP TABLE /* comment */ t1;
143 CREATE TABLE t1(id int);
144 DROP TABLE IF EXISTS /* comment */ t1;
145 CREATE TABLE t1(id int);
146 DROP TABLE /**/ t1;
147 CREATE TABLE t1(id int);
148 DROP TABLE IF EXISTS /* */ t1;
149 include/show_binlog_events.inc
150 Log_name Pos Event_type Server_id End_log_pos Info
151 master-bin.000001 # Gtid # # GTID #-#-#
152 master-bin.000001 # Query # # use `test`; CREATE TABLE t1(id int)
153 master-bin.000001 # Gtid # # GTID #-#-#
154 master-bin.000001 # Query # # use `test`; DROP TABLE /* comment */ `t1` /* generated by server */
155 master-bin.000001 # Gtid # # GTID #-#-#
156 master-bin.000001 # Query # # use `test`; CREATE TABLE t1(id int)
157 master-bin.000001 # Gtid # # GTID #-#-#
158 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS /* comment */ `t1` /* generated by server */
159 master-bin.000001 # Gtid # # GTID #-#-#
160 master-bin.000001 # Query # # use `test`; CREATE TABLE t1(id int)
161 master-bin.000001 # Gtid # # GTID #-#-#
162 master-bin.000001 # Query # # use `test`; DROP TABLE /**/ `t1` /* generated by server */
163 master-bin.000001 # Gtid # # GTID #-#-#
164 master-bin.000001 # Query # # use `test`; CREATE TABLE t1(id int)
165 master-bin.000001 # Gtid # # GTID #-#-#
166 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS /* */ `t1` /* generated by server */
167 #
168 # MDEV-22820 Bogus "Unknown table" warnings produced upon attempt to
169 # drop parent table referenced by FK
170 #
171 create table t1 (a int, key(a)) engine=InnoDB;
172 create table t2 (b int, foreign key(b) references t1(a)) engine=InnoDB;
173 drop table if exists t1;
174 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
175 drop table if exists t1,t0;
176 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
177 show warnings;
178 Level Code Message
179 Error 1451 Cannot delete or update a parent row: a foreign key constraint fails
180 Note 1051 Unknown table 'test.t0'
181 drop table t2,t1;
182 create table t3 (a int) engine=aria;
183 drop table t10,t20;
184 ERROR 42S02: Unknown table 'test.t10,test.t20'
185 drop table t10,t20,t3;
186 ERROR 42S02: Unknown table 'test.t10,test.t20'
187 drop table if exists t10,t20;
188 Warnings:
189 Note 1051 Unknown table 'test.t10,test.t20'
190 drop table if exists t10,t20,t3;
191 Warnings:
192 Note 1051 Unknown table 'test.t10,test.t20,test.t3'
193 include/show_binlog_events.inc
194 Log_name Pos Event_type Server_id End_log_pos Info
195 master-bin.000001 # Gtid # # GTID #-#-#
196 master-bin.000001 # Query # # use `test`; create table t1 (a int, key(a)) engine=InnoDB
197 master-bin.000001 # Gtid # # GTID #-#-#
198 master-bin.000001 # Query # # use `test`; create table t2 (b int, foreign key(b) references t1(a)) engine=InnoDB
199 master-bin.000001 # Gtid # # GTID #-#-#
200 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t0` /* generated by server */
201 master-bin.000001 # Gtid # # GTID #-#-#
202 master-bin.000001 # Query # # use `test`; DROP TABLE `t2`,`t1` /* generated by server */
203 master-bin.000001 # Gtid # # GTID #-#-#
204 master-bin.000001 # Query # # use `test`; create table t3 (a int) engine=aria
205 master-bin.000001 # Gtid # # GTID #-#-#
206 master-bin.000001 # Query # # use `test`; DROP TABLE `t10`,`t20`,`t3` /* generated by server */
207 master-bin.000001 # Gtid # # GTID #-#-#
208 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t10`,`t20` /* generated by server */
209 master-bin.000001 # Gtid # # GTID #-#-#
210 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t10`,`t20`,`t3` /* generated by server */