Debian Codegraph @

mysql-test/suite/atomic/drop_table.result

raw
1 call mtr.add_suppression("InnoDB: .* does not exist in the InnoDB internal");
2 RESET MASTER;
3 "engine: myisam crash point: ddl_log_drop_before_delete_hlindex position: 1"
4 t2#i#00.MYD
5 t2#i#00.MYI
6 t2.MYD
7 t2.MYI
8 t2.TRG
9 t2.frm
10 t2_trg.TRN
11 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
12 "engine: myisam crash point: ddl_log_drop_before_delete_hlindex position: 2"
13 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
14 "engine: myisam crash point: ddl_log_drop_before_delete_table position: 1"
15 t2#i#00.MYD
16 t2#i#00.MYI
17 t2.MYD
18 t2.MYI
19 t2.TRG
20 t2.frm
21 t2_trg.TRN
22 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
23 "engine: myisam crash point: ddl_log_drop_before_delete_table position: 2"
24 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
25 "engine: myisam crash point: ddl_log_drop_after_delete_table position: 1"
26 t2#i#00.MYD
27 t2#i#00.MYI
28 t2.MYD
29 t2.MYI
30 t2.TRG
31 t2.frm
32 t2_trg.TRN
33 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
34 "engine: myisam crash point: ddl_log_drop_after_delete_table position: 2"
35 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
36 "engine: myisam crash point: ddl_log_drop_before_drop_trigger position: 1"
37 t2#i#00.MYD
38 t2#i#00.MYI
39 t2.MYD
40 t2.MYI
41 t2.TRG
42 t2.frm
43 t2_trg.TRN
44 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
45 "engine: myisam crash point: ddl_log_drop_before_drop_trigger position: 2"
46 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
47 "engine: myisam crash point: ddl_log_drop_before_drop_trigger2 position: 1"
48 t2#i#00.MYD
49 t2#i#00.MYI
50 t2.MYD
51 t2.MYI
52 t2.TRG
53 t2.frm
54 t2_trg.TRN
55 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
56 "engine: myisam crash point: ddl_log_drop_before_drop_trigger2 position: 2"
57 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
58 "engine: myisam crash point: ddl_log_drop_after_drop_trigger position: 1"
59 t2#i#00.MYD
60 t2#i#00.MYI
61 t2.MYD
62 t2.MYI
63 t2.TRG
64 t2.frm
65 t2_trg.TRN
66 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
67 "engine: myisam crash point: ddl_log_drop_after_drop_trigger position: 2"
68 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
69 "engine: myisam crash point: ddl_log_drop_before_binlog position: 1"
70 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
71 "engine: myisam crash point: ddl_log_drop_before_binlog position: 2"
72 "No crash!"
73 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
74 "engine: myisam crash point: ddl_log_drop_after_binlog position: 1"
75 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
76 "engine: myisam crash point: ddl_log_drop_after_binlog position: 2"
77 "No crash!"
78 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
79 "engine: aria crash point: ddl_log_drop_before_delete_hlindex position: 1"
80 t2#i#00.MAD
81 t2#i#00.MAI
82 t2.MAD
83 t2.MAI
84 t2.TRG
85 t2.frm
86 t2_trg.TRN
87 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
88 "engine: aria crash point: ddl_log_drop_before_delete_hlindex position: 2"
89 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
90 "engine: aria crash point: ddl_log_drop_before_delete_table position: 1"
91 t2#i#00.MAD
92 t2#i#00.MAI
93 t2.MAD
94 t2.MAI
95 t2.TRG
96 t2.frm
97 t2_trg.TRN
98 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
99 "engine: aria crash point: ddl_log_drop_before_delete_table position: 2"
100 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
101 "engine: aria crash point: ddl_log_drop_after_delete_table position: 1"
102 t2#i#00.MAD
103 t2#i#00.MAI
104 t2.MAD
105 t2.MAI
106 t2.TRG
107 t2.frm
108 t2_trg.TRN
109 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
110 "engine: aria crash point: ddl_log_drop_after_delete_table position: 2"
111 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
112 "engine: aria crash point: ddl_log_drop_before_drop_trigger position: 1"
113 t2#i#00.MAD
114 t2#i#00.MAI
115 t2.MAD
116 t2.MAI
117 t2.TRG
118 t2.frm
119 t2_trg.TRN
120 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
121 "engine: aria crash point: ddl_log_drop_before_drop_trigger position: 2"
122 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
123 "engine: aria crash point: ddl_log_drop_before_drop_trigger2 position: 1"
124 t2#i#00.MAD
125 t2#i#00.MAI
126 t2.MAD
127 t2.MAI
128 t2.TRG
129 t2.frm
130 t2_trg.TRN
131 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
132 "engine: aria crash point: ddl_log_drop_before_drop_trigger2 position: 2"
133 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
134 "engine: aria crash point: ddl_log_drop_after_drop_trigger position: 1"
135 t2#i#00.MAD
136 t2#i#00.MAI
137 t2.MAD
138 t2.MAI
139 t2.TRG
140 t2.frm
141 t2_trg.TRN
142 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
143 "engine: aria crash point: ddl_log_drop_after_drop_trigger position: 2"
144 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
145 "engine: aria crash point: ddl_log_drop_before_binlog position: 1"
146 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
147 "engine: aria crash point: ddl_log_drop_before_binlog position: 2"
148 "No crash!"
149 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
150 "engine: aria crash point: ddl_log_drop_after_binlog position: 1"
151 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
152 "engine: aria crash point: ddl_log_drop_after_binlog position: 2"
153 "No crash!"
154 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
155 "engine: aria_notrans crash point: ddl_log_drop_before_delete_hlindex position: 1"
156 t2#i#00.MAD
157 t2#i#00.MAI
158 t2.MAD
159 t2.MAI
160 t2.TRG
161 t2.frm
162 t2_trg.TRN
163 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
164 "engine: aria_notrans crash point: ddl_log_drop_before_delete_hlindex position: 2"
165 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
166 "engine: aria_notrans crash point: ddl_log_drop_before_delete_table position: 1"
167 t2#i#00.MAD
168 t2#i#00.MAI
169 t2.MAD
170 t2.MAI
171 t2.TRG
172 t2.frm
173 t2_trg.TRN
174 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
175 "engine: aria_notrans crash point: ddl_log_drop_before_delete_table position: 2"
176 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
177 "engine: aria_notrans crash point: ddl_log_drop_after_delete_table position: 1"
178 t2#i#00.MAD
179 t2#i#00.MAI
180 t2.MAD
181 t2.MAI
182 t2.TRG
183 t2.frm
184 t2_trg.TRN
185 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
186 "engine: aria_notrans crash point: ddl_log_drop_after_delete_table position: 2"
187 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
188 "engine: aria_notrans crash point: ddl_log_drop_before_drop_trigger position: 1"
189 t2#i#00.MAD
190 t2#i#00.MAI
191 t2.MAD
192 t2.MAI
193 t2.TRG
194 t2.frm
195 t2_trg.TRN
196 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
197 "engine: aria_notrans crash point: ddl_log_drop_before_drop_trigger position: 2"
198 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
199 "engine: aria_notrans crash point: ddl_log_drop_before_drop_trigger2 position: 1"
200 t2#i#00.MAD
201 t2#i#00.MAI
202 t2.MAD
203 t2.MAI
204 t2.TRG
205 t2.frm
206 t2_trg.TRN
207 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
208 "engine: aria_notrans crash point: ddl_log_drop_before_drop_trigger2 position: 2"
209 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
210 "engine: aria_notrans crash point: ddl_log_drop_after_drop_trigger position: 1"
211 t2#i#00.MAD
212 t2#i#00.MAI
213 t2.MAD
214 t2.MAI
215 t2.TRG
216 t2.frm
217 t2_trg.TRN
218 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
219 "engine: aria_notrans crash point: ddl_log_drop_after_drop_trigger position: 2"
220 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
221 "engine: aria_notrans crash point: ddl_log_drop_before_binlog position: 1"
222 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
223 "engine: aria_notrans crash point: ddl_log_drop_before_binlog position: 2"
224 "No crash!"
225 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
226 "engine: aria_notrans crash point: ddl_log_drop_after_binlog position: 1"
227 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
228 "engine: aria_notrans crash point: ddl_log_drop_after_binlog position: 2"
229 "No crash!"
230 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
231 "engine: innodb crash point: ddl_log_drop_before_delete_hlindex position: 1"
232 t2#i#00.ibd
233 t2.TRG
234 t2.frm
235 t2.ibd
236 t2_trg.TRN
237 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
238 "engine: innodb crash point: ddl_log_drop_before_delete_hlindex position: 2"
239 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
240 "engine: innodb crash point: ddl_log_drop_before_delete_table position: 1"
241 t2#i#00.ibd
242 t2.TRG
243 t2.frm
244 t2.ibd
245 t2_trg.TRN
246 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
247 "engine: innodb crash point: ddl_log_drop_before_delete_table position: 2"
248 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
249 "engine: innodb crash point: ddl_log_drop_after_delete_table position: 1"
250 t2#i#00.ibd
251 t2.TRG
252 t2.frm
253 t2.ibd
254 t2_trg.TRN
255 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
256 "engine: innodb crash point: ddl_log_drop_after_delete_table position: 2"
257 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
258 "engine: innodb crash point: ddl_log_drop_before_drop_trigger position: 1"
259 t2#i#00.ibd
260 t2.TRG
261 t2.frm
262 t2.ibd
263 t2_trg.TRN
264 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
265 "engine: innodb crash point: ddl_log_drop_before_drop_trigger position: 2"
266 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
267 "engine: innodb crash point: ddl_log_drop_before_drop_trigger2 position: 1"
268 t2#i#00.ibd
269 t2.TRG
270 t2.frm
271 t2.ibd
272 t2_trg.TRN
273 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
274 "engine: innodb crash point: ddl_log_drop_before_drop_trigger2 position: 2"
275 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
276 "engine: innodb crash point: ddl_log_drop_after_drop_trigger position: 1"
277 t2#i#00.ibd
278 t2.TRG
279 t2.frm
280 t2.ibd
281 t2_trg.TRN
282 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
283 "engine: innodb crash point: ddl_log_drop_after_drop_trigger position: 2"
284 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
285 "engine: innodb crash point: ddl_log_drop_before_binlog position: 1"
286 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
287 "engine: innodb crash point: ddl_log_drop_before_binlog position: 2"
288 "No crash!"
289 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
290 "engine: innodb crash point: ddl_log_drop_after_binlog position: 1"
291 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
292 "engine: innodb crash point: ddl_log_drop_after_binlog position: 2"
293 "No crash!"
294 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
295 "engine: csv crash point: ddl_log_drop_before_delete_hlindex position: 1"
296 t2.CSM
297 t2.CSV
298 t2.TRG
299 t2.frm
300 t2_trg.TRN
301 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
302 "engine: csv crash point: ddl_log_drop_before_delete_hlindex position: 2"
303 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
304 "engine: csv crash point: ddl_log_drop_before_delete_table position: 1"
305 t2.CSM
306 t2.CSV
307 t2.TRG
308 t2.frm
309 t2_trg.TRN
310 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
311 "engine: csv crash point: ddl_log_drop_before_delete_table position: 2"
312 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
313 "engine: csv crash point: ddl_log_drop_after_delete_table position: 1"
314 t2.CSM
315 t2.CSV
316 t2.TRG
317 t2.frm
318 t2_trg.TRN
319 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
320 "engine: csv crash point: ddl_log_drop_after_delete_table position: 2"
321 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
322 "engine: csv crash point: ddl_log_drop_before_drop_trigger position: 1"
323 t2.CSM
324 t2.CSV
325 t2.TRG
326 t2.frm
327 t2_trg.TRN
328 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
329 "engine: csv crash point: ddl_log_drop_before_drop_trigger position: 2"
330 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
331 "engine: csv crash point: ddl_log_drop_before_drop_trigger2 position: 1"
332 t2.CSM
333 t2.CSV
334 t2.TRG
335 t2.frm
336 t2_trg.TRN
337 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
338 "engine: csv crash point: ddl_log_drop_before_drop_trigger2 position: 2"
339 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
340 "engine: csv crash point: ddl_log_drop_after_drop_trigger position: 1"
341 t2.CSM
342 t2.CSV
343 t2.TRG
344 t2.frm
345 t2_trg.TRN
346 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
347 "engine: csv crash point: ddl_log_drop_after_drop_trigger position: 2"
348 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
349 "engine: csv crash point: ddl_log_drop_before_binlog position: 1"
350 master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
351 "engine: csv crash point: ddl_log_drop_before_binlog position: 2"
352 "No crash!"
353 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
354 "engine: csv crash point: ddl_log_drop_after_binlog position: 1"
355 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
356 "engine: csv crash point: ddl_log_drop_after_binlog position: 2"
357 "No crash!"
358 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
359 Warnings:
360 Note 1051 Unknown table 'test.t1,test.t2'