Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 DROP DATABASE IF EXISTS d1;
4 DROP DATABASE IF EXISTS d2;
5 DROP DATABASE IF EXISTS d3;
6 DROP DATABASE IF EXISTS d4;
7 DROP EVENT IF EXISTS e1;
8 DROP EVENT IF EXISTS e2;
9 DROP EVENT IF EXISTS e3;
10 DROP EVENT IF EXISTS e4;
11 DROP FUNCTION IF EXISTS f1;
12 DROP FUNCTION IF EXISTS f2;
13 DROP FUNCTION IF EXISTS f3;
14 DROP FUNCTION IF EXISTS f4;
15 DROP SERVER IF EXISTS s1;
16 DROP SERVER IF EXISTS s2;
17 DROP SERVER IF EXISTS s3;
18 DROP SERVER IF EXISTS s4;
19 DROP TABLE IF EXISTS t1;
20 DROP TABLE IF EXISTS t2;
21 DROP TABLE IF EXISTS t3;
22 DROP TABLE IF EXISTS t4;
23 DROP PROCEDURE IF EXISTS p1;
24 DROP PROCEDURE IF EXISTS p2;
25 DROP PROCEDURE IF EXISTS p3;
26 DROP PROCEDURE IF EXISTS p4;
27 DROP TRIGGER IF EXISTS tr1;
28 DROP TRIGGER IF EXISTS tr2;
29 DROP TRIGGER IF EXISTS tr3;
30 DROP TRIGGER IF EXISTS tr4;
31 CREATE DATABASE d1;
32 CREATE EVENT e1
33 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
34 DO INSERT INTO test.t1 VALUES (1);
35 Warnings:
36 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
37 CREATE FUNCTION f1 () RETURNS INT DETERMINISTIC
38 RETURN 1;
39 CREATE PROCEDURE p1 (OUT rows_cnt INT)
40 BEGIN
41 SELECT COUNT(*) INTO rows_cnt FROM t1;
42 END;
43 //
44 CREATE SERVER s1
45 FOREIGN DATA WRAPPER mysql
46 OPTIONS (USER 'user1', HOST '192.168.1.106', DATABASE 'test');
47 CREATE TABLE t1 (a int);
48 CREATE TABLE t3 (a int);
49 CREATE TRIGGER tr1 BEFORE INSERT ON t1
50 FOR EACH ROW BEGIN
51 DELETE FROM t4 WHERE a=NEW.a;
52 END;
53 //
54 CREATE INDEX i1 ON t1 (a);
55 CREATE VIEW v1 AS SELECT a FROM t1 WHERE a < 100;
56 connection slave;
57 connection master1;
58 connection master;
59 connection master1;
60 CREATE DATABASE d2;
61 source include/kill_query.inc;
62 connection master;
63 include/rpl_diff.inc
64 connection master;
65 connection master1;
66 ALTER DATABASE d1
67 DEFAULT CHARACTER SET = 'utf8';
68 source include/kill_query.inc;
69 connection master;
70 include/rpl_diff.inc
71 connection master;
72 connection master1;
73 DROP DATABASE d1;
74 source include/kill_query.inc;
75 connection master;
76 include/rpl_diff.inc
77 connection master;
78 connection master1;
79 DROP DATABASE IF EXISTS d2;
80 source include/kill_query.inc;
81 connection master;
82 include/rpl_diff.inc
83 connection master;
84 connection master1;
85 CREATE EVENT e2
86 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
87 DO INSERT INTO test.t1 VALUES (2);
88 source include/kill_query.inc;
89 connection master;
90 include/rpl_diff.inc
91 connection master;
92 connection master1;
93 DROP EVENT e1;
94 source include/kill_query.inc;
95 connection master;
96 include/rpl_diff.inc
97 connection master;
98 connection master1;
99 DROP EVENT IF EXISTS e2;
100 source include/kill_query.inc;
101 connection master;
102 include/rpl_diff.inc
103 connection master;
104 connection master1;
105 CREATE FUNCTION f2 () RETURNS INT DETERMINISTIC
106 RETURN 1;
107 source include/kill_query.inc;
108 connection master;
109 include/rpl_diff.inc
110 connection master;
111 connection master1;
112 ALTER FUNCTION f1 SQL SECURITY INVOKER;
113 source include/kill_query.inc;
114 connection master;
115 include/rpl_diff.inc
116 connection master;
117 connection master1;
118 DROP FUNCTION f1;
119 source include/kill_query.inc;
120 connection master;
121 include/rpl_diff.inc
122 connection master;
123 connection master1;
124 DROP FUNCTION IF EXISTS f2;
125 source include/kill_query.inc;
126 connection master;
127 include/rpl_diff.inc
128 connection master;
129 connection master1;
130 CREATE PROCEDURE p2 (OUT rows_cnt INT)
131 BEGIN
132 SELECT COUNT(*) INTO rows_cnt FROM t2;
133 END;
134 //
135 source include/kill_query.inc;
136 connection master;
137 include/rpl_diff.inc
138 connection master;
139 connection master1;
140 ALTER PROCEDURE p1 SQL SECURITY INVOKER COMMENT 'return rows_cnt of table t1';
141 source include/kill_query.inc;
142 connection master;
143 include/rpl_diff.inc
144 connection master;
145 connection master1;
146 DROP PROCEDURE p1;
147 source include/kill_query.inc;
148 connection master;
149 include/rpl_diff.inc
150 connection master;
151 connection master1;
152 DROP PROCEDURE IF EXISTS p2;
153 source include/kill_query.inc;
154 connection master;
155 include/rpl_diff.inc
156 connection master;
157 connection master1;
158 CREATE TABLE t2 (b int);
159 source include/kill_query.inc;
160 connection master;
161 include/rpl_diff.inc
162 connection master;
163 connection master1;
164 ALTER TABLE t1 ADD (d int);
165 source include/kill_query.inc;
166 connection master;
167 include/rpl_diff.inc
168 connection master;
169 connection master1;
170 RENAME TABLE t3 TO t4;
171 source include/kill_query.inc;
172 connection master;
173 include/rpl_diff.inc
174 connection master;
175 connection master1;
176 CREATE INDEX i2 on t1 (a);
177 source include/kill_query.inc;
178 connection master;
179 include/rpl_diff.inc
180 connection master;
181 connection master1;
182 DROP INDEX i1 on t1;
183 source include/kill_query.inc;
184 connection master;
185 include/rpl_diff.inc
186 connection master;
187 connection master1;
188 connection master;
189 CREATE TABLE IF NOT EXISTS t4 (a int);
190 connection master1;
191 CREATE TRIGGER tr2 BEFORE INSERT ON t4
192 FOR EACH ROW BEGIN
193 DELETE FROM t1 WHERE a=NEW.a;
194 END;
195 //
196 source include/kill_query.inc;
197 connection master;
198 include/rpl_diff.inc
199 connection master;
200 connection master1;
201 DROP TRIGGER tr1;
202 source include/kill_query.inc;
203 connection master;
204 include/rpl_diff.inc
205 connection master;
206 connection master1;
207 DROP TRIGGER IF EXISTS tr2;
208 source include/kill_query.inc;
209 connection master;
210 include/rpl_diff.inc
211 connection master;
212 connection master1;
213 CREATE VIEW v2 AS SELECT a FROM t1 WHERE a > 100;
214 source include/kill_query.inc;
215 connection master;
216 include/rpl_diff.inc
217 connection master;
218 connection master1;
219 DROP VIEW v1;
220 source include/kill_query.inc;
221 connection master;
222 include/rpl_diff.inc
223 connection master;
224 connection master1;
225 DROP VIEW IF EXISTS v2;
226 source include/kill_query.inc;
227 connection master;
228 include/rpl_diff.inc
229 connection master;
230 connection master1;
231 DROP TABLE t1;
232 source include/kill_query.inc;
233 connection master;
234 include/rpl_diff.inc
235 connection master;
236 connection master1;
237 DROP TABLE IF EXISTS t2;
238 source include/kill_query.inc;
239 connection master;
240 include/rpl_diff.inc
241 connection master;
242 connection master1;
243 connection master;
244 DROP DATABASE IF EXISTS d1;
245 DROP DATABASE IF EXISTS d2;
246 DROP DATABASE IF EXISTS d3;
247 DROP DATABASE IF EXISTS d4;
248 DROP EVENT IF EXISTS e1;
249 DROP EVENT IF EXISTS e2;
250 DROP EVENT IF EXISTS e3;
251 DROP EVENT IF EXISTS e4;
252 DROP FUNCTION IF EXISTS f1;
253 DROP FUNCTION IF EXISTS f2;
254 DROP FUNCTION IF EXISTS f3;
255 DROP FUNCTION IF EXISTS f4;
256 DROP SERVER IF EXISTS s1;
257 DROP SERVER IF EXISTS s2;
258 DROP SERVER IF EXISTS s3;
259 DROP SERVER IF EXISTS s4;
260 DROP TABLE IF EXISTS t1;
261 DROP TABLE IF EXISTS t2;
262 DROP TABLE IF EXISTS t3;
263 DROP TABLE IF EXISTS t4;
264 DROP PROCEDURE IF EXISTS p1;
265 DROP PROCEDURE IF EXISTS p2;
266 DROP PROCEDURE IF EXISTS p3;
267 DROP PROCEDURE IF EXISTS p4;
268 include/rpl_end.inc