Debian Codegraph @

mysql-test/suite/atomic/vector_myisam.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 create database test2;
3 RESET MASTER;
4
5 engine: myisam
6
7
8 query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
9
10 crash point: ddl_log_alter_after_create_frm
11 t1#i#01.MYD
12 t1#i#01.MYI
13 t1.MYD
14 t1.MYI
15 t1.frm
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `a` int(11) DEFAULT NULL,
19 `b` int(11) DEFAULT NULL,
20 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
21 KEY `a` (`a`),
22 VECTOR KEY `v` (`v`)
23 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
24 count(*)
25 2
26 crash point: ddl_log_alter_after_create_table
27 t1#i#01.MYD
28 t1#i#01.MYI
29 t1.MYD
30 t1.MYI
31 t1.frm
32 Table Create Table
33 t1 CREATE TABLE `t1` (
34 `a` int(11) DEFAULT NULL,
35 `b` int(11) DEFAULT NULL,
36 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
37 KEY `a` (`a`),
38 VECTOR KEY `v` (`v`)
39 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
40 count(*)
41 2
42 crash point: ddl_log_alter_after_prepare_inplace
43 "No crash!"
44 crash point: ddl_log_alter_after_copy
45 t1#i#01.MYD
46 t1#i#01.MYI
47 t1.MYD
48 t1.MYI
49 t1.frm
50 Table Create Table
51 t1 CREATE TABLE `t1` (
52 `a` int(11) DEFAULT NULL,
53 `b` int(11) DEFAULT NULL,
54 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
55 KEY `a` (`a`),
56 VECTOR KEY `v` (`v`)
57 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
58 count(*)
59 2
60 crash point: ddl_log_alter_after_log
61 t1#i#01.MYD
62 t1#i#01.MYI
63 t1.MYD
64 t1.MYI
65 t1.frm
66 Table Create Table
67 t1 CREATE TABLE `t1` (
68 `a` int(11) DEFAULT NULL,
69 `b` int(11) DEFAULT NULL,
70 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
71 `c` int(11) DEFAULT NULL,
72 KEY `a` (`a`),
73 VECTOR KEY `v` (`v`)
74 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
75 count(*)
76 2
77 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
78 crash point: ddl_log_alter_after_rename_to_backup
79 t1#i#01.MYD
80 t1#i#01.MYI
81 t1.MYD
82 t1.MYI
83 t1.frm
84 Table Create Table
85 t1 CREATE TABLE `t1` (
86 `a` int(11) DEFAULT NULL,
87 `b` int(11) DEFAULT NULL,
88 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
89 `c` int(11) DEFAULT NULL,
90 KEY `a` (`a`),
91 VECTOR KEY `v` (`v`)
92 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
93 count(*)
94 2
95 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
96 crash point: ddl_log_alter_after_rename_to_backup_log
97 t1#i#01.MYD
98 t1#i#01.MYI
99 t1.MYD
100 t1.MYI
101 t1.frm
102 Table Create Table
103 t1 CREATE TABLE `t1` (
104 `a` int(11) DEFAULT NULL,
105 `b` int(11) DEFAULT NULL,
106 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
107 `c` int(11) DEFAULT NULL,
108 KEY `a` (`a`),
109 VECTOR KEY `v` (`v`)
110 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
111 count(*)
112 2
113 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
114 crash point: ddl_log_alter_rename_frm
115 "No crash!"
116 crash point: ddl_log_alter_after_rename_to_original
117 t1#i#01.MYD
118 t1#i#01.MYI
119 t1.MYD
120 t1.MYI
121 t1.frm
122 Table Create Table
123 t1 CREATE TABLE `t1` (
124 `a` int(11) DEFAULT NULL,
125 `b` int(11) DEFAULT NULL,
126 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
127 `c` int(11) DEFAULT NULL,
128 KEY `a` (`a`),
129 VECTOR KEY `v` (`v`)
130 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
131 count(*)
132 2
133 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
134 crash point: ddl_log_alter_before_rename_triggers
135 "No crash!"
136 crash point: ddl_log_alter_after_rename_triggers
137 "No crash!"
138 crash point: ddl_log_alter_after_delete_backup
139 t1#i#01.MYD
140 t1#i#01.MYI
141 t1.MYD
142 t1.MYI
143 t1.frm
144 Table Create Table
145 t1 CREATE TABLE `t1` (
146 `a` int(11) DEFAULT NULL,
147 `b` int(11) DEFAULT NULL,
148 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
149 `c` int(11) DEFAULT NULL,
150 KEY `a` (`a`),
151 VECTOR KEY `v` (`v`)
152 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
153 count(*)
154 2
155 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
156 crash point: ddl_log_alter_after_drop_original_table
157 t1#i#01.MYD
158 t1#i#01.MYI
159 t1.MYD
160 t1.MYI
161 t1.frm
162 Table Create Table
163 t1 CREATE TABLE `t1` (
164 `a` int(11) DEFAULT NULL,
165 `b` int(11) DEFAULT NULL,
166 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
167 `c` int(11) DEFAULT NULL,
168 KEY `a` (`a`),
169 VECTOR KEY `v` (`v`)
170 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
171 count(*)
172 2
173 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
174
175 query: ALTER TABLE t1 COMMENT "new"
176
177 crash point: ddl_log_alter_after_create_frm
178 t1#i#01.MYD
179 t1#i#01.MYI
180 t1.MYD
181 t1.MYI
182 t1.frm
183 Table Create Table
184 t1 CREATE TABLE `t1` (
185 `a` int(11) DEFAULT NULL,
186 `b` int(11) DEFAULT NULL,
187 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
188 KEY `a` (`a`),
189 VECTOR KEY `v` (`v`)
190 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
191 count(*)
192 2
193 crash point: ddl_log_alter_after_create_table
194 "No crash!"
195 crash point: ddl_log_alter_after_prepare_inplace
196 t1#i#01.MYD
197 t1#i#01.MYI
198 t1.MYD
199 t1.MYI
200 t1.frm
201 Table Create Table
202 t1 CREATE TABLE `t1` (
203 `a` int(11) DEFAULT NULL,
204 `b` int(11) DEFAULT NULL,
205 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
206 KEY `a` (`a`),
207 VECTOR KEY `v` (`v`)
208 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
209 count(*)
210 2
211 crash point: ddl_log_alter_after_copy
212 t1#i#01.MYD
213 t1#i#01.MYI
214 t1.MYD
215 t1.MYI
216 t1.frm
217 Table Create Table
218 t1 CREATE TABLE `t1` (
219 `a` int(11) DEFAULT NULL,
220 `b` int(11) DEFAULT NULL,
221 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
222 KEY `a` (`a`),
223 VECTOR KEY `v` (`v`)
224 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
225 count(*)
226 2
227 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new"
228 crash point: ddl_log_alter_after_log
229 t1#i#01.MYD
230 t1#i#01.MYI
231 t1.MYD
232 t1.MYI
233 t1.frm
234 Table Create Table
235 t1 CREATE TABLE `t1` (
236 `a` int(11) DEFAULT NULL,
237 `b` int(11) DEFAULT NULL,
238 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
239 KEY `a` (`a`),
240 VECTOR KEY `v` (`v`)
241 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
242 count(*)
243 2
244 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new"
245 crash point: ddl_log_alter_after_rename_to_backup
246 "No crash!"
247 crash point: ddl_log_alter_after_rename_to_backup_log
248 "No crash!"
249 crash point: ddl_log_alter_rename_frm
250 "No crash!"
251 crash point: ddl_log_alter_after_rename_to_original
252 "No crash!"
253 crash point: ddl_log_alter_before_rename_triggers
254 "No crash!"
255 crash point: ddl_log_alter_after_rename_triggers
256 "No crash!"
257 crash point: ddl_log_alter_after_delete_backup
258 "No crash!"
259 crash point: ddl_log_alter_after_drop_original_table
260 "No crash!"
261
262 query: ALTER TABLE t1 change column a c int COMMENT "new"
263
264 crash point: ddl_log_alter_after_create_frm
265 t1#i#01.MYD
266 t1#i#01.MYI
267 t1.MYD
268 t1.MYI
269 t1.frm
270 Table Create Table
271 t1 CREATE TABLE `t1` (
272 `a` int(11) DEFAULT NULL,
273 `b` int(11) DEFAULT NULL,
274 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
275 KEY `a` (`a`),
276 VECTOR KEY `v` (`v`)
277 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
278 count(*)
279 2
280 crash point: ddl_log_alter_after_create_table
281 "No crash!"
282 crash point: ddl_log_alter_after_prepare_inplace
283 t1#i#01.MYD
284 t1#i#01.MYI
285 t1.MYD
286 t1.MYI
287 t1.frm
288 Table Create Table
289 t1 CREATE TABLE `t1` (
290 `a` int(11) DEFAULT NULL,
291 `b` int(11) DEFAULT NULL,
292 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
293 KEY `a` (`a`),
294 VECTOR KEY `v` (`v`)
295 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
296 count(*)
297 2
298 crash point: ddl_log_alter_after_copy
299 t1#i#01.MYD
300 t1#i#01.MYI
301 t1.MYD
302 t1.MYI
303 t1.frm
304 Table Create Table
305 t1 CREATE TABLE `t1` (
306 `c` int(11) DEFAULT NULL COMMENT 'new',
307 `b` int(11) DEFAULT NULL,
308 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
309 KEY `a` (`c`),
310 VECTOR KEY `v` (`v`)
311 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
312 count(*)
313 2
314 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new"
315 crash point: ddl_log_alter_after_log
316 t1#i#01.MYD
317 t1#i#01.MYI
318 t1.MYD
319 t1.MYI
320 t1.frm
321 Table Create Table
322 t1 CREATE TABLE `t1` (
323 `c` int(11) DEFAULT NULL COMMENT 'new',
324 `b` int(11) DEFAULT NULL,
325 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
326 KEY `a` (`c`),
327 VECTOR KEY `v` (`v`)
328 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
329 count(*)
330 2
331 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new"
332 crash point: ddl_log_alter_after_rename_to_backup
333 "No crash!"
334 crash point: ddl_log_alter_after_rename_to_backup_log
335 "No crash!"
336 crash point: ddl_log_alter_rename_frm
337 "No crash!"
338 crash point: ddl_log_alter_after_rename_to_original
339 "No crash!"
340 crash point: ddl_log_alter_before_rename_triggers
341 "No crash!"
342 crash point: ddl_log_alter_after_rename_triggers
343 "No crash!"
344 crash point: ddl_log_alter_after_delete_backup
345 "No crash!"
346 crash point: ddl_log_alter_after_drop_original_table
347 "No crash!"
348
349 query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
350
351 crash point: ddl_log_alter_after_create_frm
352 t1#i#01.MYD
353 t1#i#01.MYI
354 t1.MYD
355 t1.MYI
356 t1.frm
357 Table Create Table
358 t1 CREATE TABLE `t1` (
359 `a` int(11) DEFAULT NULL,
360 `b` int(11) DEFAULT NULL,
361 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
362 KEY `a` (`a`),
363 VECTOR KEY `v` (`v`)
364 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
365 count(*)
366 2
367 crash point: ddl_log_alter_after_create_table
368 t1#i#01.MYD
369 t1#i#01.MYI
370 t1.MYD
371 t1.MYI
372 t1.frm
373 Table Create Table
374 t1 CREATE TABLE `t1` (
375 `a` int(11) DEFAULT NULL,
376 `b` int(11) DEFAULT NULL,
377 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
378 KEY `a` (`a`),
379 VECTOR KEY `v` (`v`)
380 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
381 count(*)
382 2
383 crash point: ddl_log_alter_after_prepare_inplace
384 "No crash!"
385 crash point: ddl_log_alter_after_copy
386 t1#i#01.MYD
387 t1#i#01.MYI
388 t1.MYD
389 t1.MYI
390 t1.frm
391 Table Create Table
392 t1 CREATE TABLE `t1` (
393 `a` int(11) DEFAULT NULL,
394 `b` int(11) DEFAULT NULL,
395 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
396 KEY `a` (`a`),
397 VECTOR KEY `v` (`v`)
398 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
399 count(*)
400 2
401 crash point: ddl_log_alter_after_log
402 t2#i#01.MYD
403 t2#i#01.MYI
404 t2.MYD
405 t2.MYI
406 t2.frm
407 Table Create Table
408 t2 CREATE TABLE `t2` (
409 `a` int(11) DEFAULT NULL,
410 `b` int(11) DEFAULT NULL,
411 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
412 `c` int(11) DEFAULT NULL,
413 KEY `a` (`a`),
414 VECTOR KEY `v` (`v`)
415 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
416 count(*)
417 2
418 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
419 crash point: ddl_log_alter_after_rename_to_backup
420 t2#i#01.MYD
421 t2#i#01.MYI
422 t2.MYD
423 t2.MYI
424 t2.frm
425 Table Create Table
426 t2 CREATE TABLE `t2` (
427 `a` int(11) DEFAULT NULL,
428 `b` int(11) DEFAULT NULL,
429 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
430 `c` int(11) DEFAULT NULL,
431 KEY `a` (`a`),
432 VECTOR KEY `v` (`v`)
433 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
434 count(*)
435 2
436 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
437 crash point: ddl_log_alter_after_rename_to_backup_log
438 t2#i#01.MYD
439 t2#i#01.MYI
440 t2.MYD
441 t2.MYI
442 t2.frm
443 Table Create Table
444 t2 CREATE TABLE `t2` (
445 `a` int(11) DEFAULT NULL,
446 `b` int(11) DEFAULT NULL,
447 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
448 `c` int(11) DEFAULT NULL,
449 KEY `a` (`a`),
450 VECTOR KEY `v` (`v`)
451 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
452 count(*)
453 2
454 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
455 crash point: ddl_log_alter_rename_frm
456 "No crash!"
457 crash point: ddl_log_alter_after_rename_to_original
458 t2#i#01.MYD
459 t2#i#01.MYI
460 t2.MYD
461 t2.MYI
462 t2.frm
463 Table Create Table
464 t2 CREATE TABLE `t2` (
465 `a` int(11) DEFAULT NULL,
466 `b` int(11) DEFAULT NULL,
467 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
468 `c` int(11) DEFAULT NULL,
469 KEY `a` (`a`),
470 VECTOR KEY `v` (`v`)
471 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
472 count(*)
473 2
474 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
475 crash point: ddl_log_alter_before_rename_triggers
476 t2#i#01.MYD
477 t2#i#01.MYI
478 t2.MYD
479 t2.MYI
480 t2.frm
481 Table Create Table
482 t2 CREATE TABLE `t2` (
483 `a` int(11) DEFAULT NULL,
484 `b` int(11) DEFAULT NULL,
485 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
486 `c` int(11) DEFAULT NULL,
487 KEY `a` (`a`),
488 VECTOR KEY `v` (`v`)
489 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
490 count(*)
491 2
492 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
493 crash point: ddl_log_alter_after_rename_triggers
494 t2#i#01.MYD
495 t2#i#01.MYI
496 t2.MYD
497 t2.MYI
498 t2.frm
499 Table Create Table
500 t2 CREATE TABLE `t2` (
501 `a` int(11) DEFAULT NULL,
502 `b` int(11) DEFAULT NULL,
503 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
504 `c` int(11) DEFAULT NULL,
505 KEY `a` (`a`),
506 VECTOR KEY `v` (`v`)
507 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
508 count(*)
509 2
510 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
511 crash point: ddl_log_alter_after_delete_backup
512 t2#i#01.MYD
513 t2#i#01.MYI
514 t2.MYD
515 t2.MYI
516 t2.frm
517 Table Create Table
518 t2 CREATE TABLE `t2` (
519 `a` int(11) DEFAULT NULL,
520 `b` int(11) DEFAULT NULL,
521 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
522 `c` int(11) DEFAULT NULL,
523 KEY `a` (`a`),
524 VECTOR KEY `v` (`v`)
525 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
526 count(*)
527 2
528 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
529 crash point: ddl_log_alter_after_drop_original_table
530 t2#i#01.MYD
531 t2#i#01.MYI
532 t2.MYD
533 t2.MYI
534 t2.frm
535 Table Create Table
536 t2 CREATE TABLE `t2` (
537 `a` int(11) DEFAULT NULL,
538 `b` int(11) DEFAULT NULL,
539 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
540 `c` int(11) DEFAULT NULL,
541 KEY `a` (`a`),
542 VECTOR KEY `v` (`v`)
543 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
544 count(*)
545 2
546 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
547
548 query: ALTER TABLE t1 disable keys
549
550 crash point: ddl_log_alter_after_create_frm
551 "No crash!"
552 crash point: ddl_log_alter_after_create_table
553 "No crash!"
554 crash point: ddl_log_alter_after_prepare_inplace
555 "No crash!"
556 crash point: ddl_log_alter_after_copy
557 "No crash!"
558 crash point: ddl_log_alter_after_log
559 "No crash!"
560 crash point: ddl_log_alter_after_rename_to_backup
561 "No crash!"
562 crash point: ddl_log_alter_after_rename_to_backup_log
563 "No crash!"
564 crash point: ddl_log_alter_rename_frm
565 "No crash!"
566 crash point: ddl_log_alter_after_rename_to_original
567 "No crash!"
568 crash point: ddl_log_alter_before_rename_triggers
569 "No crash!"
570 crash point: ddl_log_alter_after_rename_triggers
571 "No crash!"
572 crash point: ddl_log_alter_after_delete_backup
573 "No crash!"
574 crash point: ddl_log_alter_after_drop_original_table
575 "No crash!"
576
577 query: ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
578
579 crash point: ddl_log_alter_after_create_frm
580 t1#i#01.MYD
581 t1#i#01.MYI
582 t1.MYD
583 t1.MYI
584 t1.frm
585 Table Create Table
586 t1 CREATE TABLE `t1` (
587 `a` int(11) DEFAULT NULL,
588 `b` int(11) DEFAULT NULL,
589 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
590 KEY `a` (`a`),
591 VECTOR KEY `v` (`v`)
592 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
593 count(*)
594 2
595 crash point: ddl_log_alter_after_create_table
596 t1#i#01.MYD
597 t1#i#01.MYI
598 t1.MYD
599 t1.MYI
600 t1.frm
601 Table Create Table
602 t1 CREATE TABLE `t1` (
603 `a` int(11) DEFAULT NULL,
604 `b` int(11) DEFAULT NULL,
605 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
606 KEY `a` (`a`),
607 VECTOR KEY `v` (`v`)
608 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
609 count(*)
610 2
611 crash point: ddl_log_alter_after_prepare_inplace
612 "No crash!"
613 crash point: ddl_log_alter_after_copy
614 t1#i#01.MYD
615 t1#i#01.MYI
616 t1.MYD
617 t1.MYI
618 t1.frm
619 Table Create Table
620 t1 CREATE TABLE `t1` (
621 `a` int(11) DEFAULT NULL,
622 `b` int(11) DEFAULT NULL,
623 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
624 KEY `a` (`a`),
625 VECTOR KEY `v` (`v`)
626 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
627 count(*)
628 2
629 crash point: ddl_log_alter_after_log
630 t1#i#01.MYD
631 t1#i#01.MYI
632 t1.MYD
633 t1.MYI
634 t1.frm
635 Table Create Table
636 t1 CREATE TABLE `t1` (
637 `a` int(11) DEFAULT NULL,
638 `b` int(11) DEFAULT NULL,
639 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
640 `c` int(11) DEFAULT NULL,
641 KEY `a` (`a`),
642 VECTOR KEY `v` (`v`)
643 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
644 count(*)
645 2
646 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
647 crash point: ddl_log_alter_after_rename_to_backup
648 t1#i#01.MYD
649 t1#i#01.MYI
650 t1.MYD
651 t1.MYI
652 t1.frm
653 Table Create Table
654 t1 CREATE TABLE `t1` (
655 `a` int(11) DEFAULT NULL,
656 `b` int(11) DEFAULT NULL,
657 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
658 `c` int(11) DEFAULT NULL,
659 KEY `a` (`a`),
660 VECTOR KEY `v` (`v`)
661 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
662 count(*)
663 2
664 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
665 crash point: ddl_log_alter_after_rename_to_backup_log
666 t1#i#01.MYD
667 t1#i#01.MYI
668 t1.MYD
669 t1.MYI
670 t1.frm
671 Table Create Table
672 t1 CREATE TABLE `t1` (
673 `a` int(11) DEFAULT NULL,
674 `b` int(11) DEFAULT NULL,
675 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
676 `c` int(11) DEFAULT NULL,
677 KEY `a` (`a`),
678 VECTOR KEY `v` (`v`)
679 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
680 count(*)
681 2
682 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
683 crash point: ddl_log_alter_rename_frm
684 "No crash!"
685 crash point: ddl_log_alter_after_rename_to_original
686 t1#i#01.MYD
687 t1#i#01.MYI
688 t1.MYD
689 t1.MYI
690 t1.frm
691 Table Create Table
692 t1 CREATE TABLE `t1` (
693 `a` int(11) DEFAULT NULL,
694 `b` int(11) DEFAULT NULL,
695 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
696 `c` int(11) DEFAULT NULL,
697 KEY `a` (`a`),
698 VECTOR KEY `v` (`v`)
699 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
700 count(*)
701 2
702 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
703 crash point: ddl_log_alter_before_rename_triggers
704 "No crash!"
705 crash point: ddl_log_alter_after_rename_triggers
706 "No crash!"
707 crash point: ddl_log_alter_after_delete_backup
708 t1#i#01.MYD
709 t1#i#01.MYI
710 t1.MYD
711 t1.MYI
712 t1.frm
713 Table Create Table
714 t1 CREATE TABLE `t1` (
715 `a` int(11) DEFAULT NULL,
716 `b` int(11) DEFAULT NULL,
717 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
718 `c` int(11) DEFAULT NULL,
719 KEY `a` (`a`),
720 VECTOR KEY `v` (`v`)
721 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
722 count(*)
723 2
724 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
725 crash point: ddl_log_alter_after_drop_original_table
726 t1#i#01.MYD
727 t1#i#01.MYI
728 t1.MYD
729 t1.MYI
730 t1.frm
731 Table Create Table
732 t1 CREATE TABLE `t1` (
733 `a` int(11) DEFAULT NULL,
734 `b` int(11) DEFAULT NULL,
735 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
736 `c` int(11) DEFAULT NULL,
737 KEY `a` (`a`),
738 VECTOR KEY `v` (`v`)
739 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
740 count(*)
741 2
742 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
743
744 query: ALTER TABLE t1 rename t2
745
746 crash point: ddl_log_alter_after_create_frm
747 "No crash!"
748 crash point: ddl_log_alter_after_create_table
749 "No crash!"
750 crash point: ddl_log_alter_after_prepare_inplace
751 "No crash!"
752 crash point: ddl_log_alter_after_copy
753 "No crash!"
754 crash point: ddl_log_alter_after_log
755 "No crash!"
756 crash point: ddl_log_alter_after_rename_to_backup
757 "No crash!"
758 crash point: ddl_log_alter_after_rename_to_backup_log
759 "No crash!"
760 crash point: ddl_log_alter_rename_frm
761 "No crash!"
762 crash point: ddl_log_alter_after_rename_to_original
763 "No crash!"
764 crash point: ddl_log_alter_before_rename_triggers
765 t1#i#01.MYD
766 t1#i#01.MYI
767 t1.MYD
768 t1.MYI
769 t1.frm
770 Table Create Table
771 t1 CREATE TABLE `t1` (
772 `a` int(11) DEFAULT NULL,
773 `b` int(11) DEFAULT NULL,
774 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
775 KEY `a` (`a`),
776 VECTOR KEY `v` (`v`)
777 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
778 count(*)
779 2
780 crash point: ddl_log_alter_after_rename_triggers
781 t1#i#01.MYD
782 t1#i#01.MYI
783 t1.MYD
784 t1.MYI
785 t1.frm
786 Table Create Table
787 t1 CREATE TABLE `t1` (
788 `a` int(11) DEFAULT NULL,
789 `b` int(11) DEFAULT NULL,
790 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
791 KEY `a` (`a`),
792 VECTOR KEY `v` (`v`)
793 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
794 count(*)
795 2
796 crash point: ddl_log_alter_after_delete_backup
797 "No crash!"
798 crash point: ddl_log_alter_after_drop_original_table
799 "No crash!"
800
801 query: ALTER TABLE t1 COMMENT "new", rename t2
802
803 crash point: ddl_log_alter_after_create_frm
804 t1#i#01.MYD
805 t1#i#01.MYI
806 t1.MYD
807 t1.MYI
808 t1.frm
809 Table Create Table
810 t1 CREATE TABLE `t1` (
811 `a` int(11) DEFAULT NULL,
812 `b` int(11) DEFAULT NULL,
813 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
814 KEY `a` (`a`),
815 VECTOR KEY `v` (`v`)
816 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
817 count(*)
818 2
819 crash point: ddl_log_alter_after_create_table
820 "No crash!"
821 crash point: ddl_log_alter_after_prepare_inplace
822 t1#i#01.MYD
823 t1#i#01.MYI
824 t1.MYD
825 t1.MYI
826 t1.frm
827 Table Create Table
828 t1 CREATE TABLE `t1` (
829 `a` int(11) DEFAULT NULL,
830 `b` int(11) DEFAULT NULL,
831 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
832 KEY `a` (`a`),
833 VECTOR KEY `v` (`v`)
834 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
835 count(*)
836 2
837 crash point: ddl_log_alter_after_copy
838 t2#i#01.MYD
839 t2#i#01.MYI
840 t2.MYD
841 t2.MYI
842 t2.frm
843 Table Create Table
844 t2 CREATE TABLE `t2` (
845 `a` int(11) DEFAULT NULL,
846 `b` int(11) DEFAULT NULL,
847 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
848 KEY `a` (`a`),
849 VECTOR KEY `v` (`v`)
850 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
851 count(*)
852 2
853 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
854 crash point: ddl_log_alter_after_log
855 t2#i#01.MYD
856 t2#i#01.MYI
857 t2.MYD
858 t2.MYI
859 t2.frm
860 Table Create Table
861 t2 CREATE TABLE `t2` (
862 `a` int(11) DEFAULT NULL,
863 `b` int(11) DEFAULT NULL,
864 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
865 KEY `a` (`a`),
866 VECTOR KEY `v` (`v`)
867 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
868 count(*)
869 2
870 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
871 crash point: ddl_log_alter_after_rename_to_backup
872 "No crash!"
873 crash point: ddl_log_alter_after_rename_to_backup_log
874 "No crash!"
875 crash point: ddl_log_alter_rename_frm
876 "No crash!"
877 crash point: ddl_log_alter_after_rename_to_original
878 "No crash!"
879 crash point: ddl_log_alter_before_rename_triggers
880 t2#i#01.MYD
881 t2#i#01.MYI
882 t2.MYD
883 t2.MYI
884 t2.frm
885 Table Create Table
886 t2 CREATE TABLE `t2` (
887 `a` int(11) DEFAULT NULL,
888 `b` int(11) DEFAULT NULL,
889 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
890 KEY `a` (`a`),
891 VECTOR KEY `v` (`v`)
892 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
893 count(*)
894 2
895 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
896 crash point: ddl_log_alter_after_rename_triggers
897 t2#i#01.MYD
898 t2#i#01.MYI
899 t2.MYD
900 t2.MYI
901 t2.frm
902 Table Create Table
903 t2 CREATE TABLE `t2` (
904 `a` int(11) DEFAULT NULL,
905 `b` int(11) DEFAULT NULL,
906 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
907 KEY `a` (`a`),
908 VECTOR KEY `v` (`v`)
909 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
910 count(*)
911 2
912 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
913 crash point: ddl_log_alter_after_delete_backup
914 "No crash!"
915 crash point: ddl_log_alter_after_drop_original_table
916 "No crash!"
917
918 query: ALTER TABLE t1 change column a c int COMMENT "new", rename t2
919
920 crash point: ddl_log_alter_after_create_frm
921 t1#i#01.MYD
922 t1#i#01.MYI
923 t1.MYD
924 t1.MYI
925 t1.frm
926 Table Create Table
927 t1 CREATE TABLE `t1` (
928 `a` int(11) DEFAULT NULL,
929 `b` int(11) DEFAULT NULL,
930 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
931 KEY `a` (`a`),
932 VECTOR KEY `v` (`v`)
933 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
934 count(*)
935 2
936 crash point: ddl_log_alter_after_create_table
937 "No crash!"
938 crash point: ddl_log_alter_after_prepare_inplace
939 t1#i#01.MYD
940 t1#i#01.MYI
941 t1.MYD
942 t1.MYI
943 t1.frm
944 Table Create Table
945 t1 CREATE TABLE `t1` (
946 `a` int(11) DEFAULT NULL,
947 `b` int(11) DEFAULT NULL,
948 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
949 KEY `a` (`a`),
950 VECTOR KEY `v` (`v`)
951 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
952 count(*)
953 2
954 crash point: ddl_log_alter_after_copy
955 t2#i#01.MYD
956 t2#i#01.MYI
957 t2.MYD
958 t2.MYI
959 t2.frm
960 Table Create Table
961 t2 CREATE TABLE `t2` (
962 `c` int(11) DEFAULT NULL COMMENT 'new',
963 `b` int(11) DEFAULT NULL,
964 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
965 KEY `a` (`c`),
966 VECTOR KEY `v` (`v`)
967 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
968 count(*)
969 2
970 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", rename t2
971 crash point: ddl_log_alter_after_log
972 t2#i#01.MYD
973 t2#i#01.MYI
974 t2.MYD
975 t2.MYI
976 t2.frm
977 Table Create Table
978 t2 CREATE TABLE `t2` (
979 `c` int(11) DEFAULT NULL COMMENT 'new',
980 `b` int(11) DEFAULT NULL,
981 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
982 KEY `a` (`c`),
983 VECTOR KEY `v` (`v`)
984 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
985 count(*)
986 2
987 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", rename t2
988 crash point: ddl_log_alter_after_rename_to_backup
989 "No crash!"
990 crash point: ddl_log_alter_after_rename_to_backup_log
991 "No crash!"
992 crash point: ddl_log_alter_rename_frm
993 "No crash!"
994 crash point: ddl_log_alter_after_rename_to_original
995 "No crash!"
996 crash point: ddl_log_alter_before_rename_triggers
997 t2#i#01.MYD
998 t2#i#01.MYI
999 t2.MYD
1000 t2.MYI
1001 t2.frm
1002 Table Create Table
1003 t2 CREATE TABLE `t2` (
1004 `c` int(11) DEFAULT NULL COMMENT 'new',
1005 `b` int(11) DEFAULT NULL,
1006 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1007 KEY `a` (`c`),
1008 VECTOR KEY `v` (`v`)
1009 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1010 count(*)
1011 2
1012 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", rename t2
1013 crash point: ddl_log_alter_after_rename_triggers
1014 t2#i#01.MYD
1015 t2#i#01.MYI
1016 t2.MYD
1017 t2.MYI
1018 t2.frm
1019 Table Create Table
1020 t2 CREATE TABLE `t2` (
1021 `c` int(11) DEFAULT NULL COMMENT 'new',
1022 `b` int(11) DEFAULT NULL,
1023 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1024 KEY `a` (`c`),
1025 VECTOR KEY `v` (`v`)
1026 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1027 count(*)
1028 2
1029 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", rename t2
1030 crash point: ddl_log_alter_after_delete_backup
1031 "No crash!"
1032 crash point: ddl_log_alter_after_drop_original_table
1033 "No crash!"
1034
1035 query: ALTER TABLE t1 ENGINE=aria, COMMENT "new"
1036
1037 crash point: ddl_log_alter_after_create_frm
1038 t1#i#01.MYD
1039 t1#i#01.MYI
1040 t1.MYD
1041 t1.MYI
1042 t1.frm
1043 Table Create Table
1044 t1 CREATE TABLE `t1` (
1045 `a` int(11) DEFAULT NULL,
1046 `b` int(11) DEFAULT NULL,
1047 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1048 KEY `a` (`a`),
1049 VECTOR KEY `v` (`v`)
1050 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1051 count(*)
1052 2
1053 crash point: ddl_log_alter_after_create_table
1054 t1#i#01.MYD
1055 t1#i#01.MYI
1056 t1.MYD
1057 t1.MYI
1058 t1.frm
1059 Table Create Table
1060 t1 CREATE TABLE `t1` (
1061 `a` int(11) DEFAULT NULL,
1062 `b` int(11) DEFAULT NULL,
1063 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1064 KEY `a` (`a`),
1065 VECTOR KEY `v` (`v`)
1066 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1067 count(*)
1068 2
1069 crash point: ddl_log_alter_after_prepare_inplace
1070 "No crash!"
1071 crash point: ddl_log_alter_after_copy
1072 t1#i#01.MYD
1073 t1#i#01.MYI
1074 t1.MYD
1075 t1.MYI
1076 t1.frm
1077 Table Create Table
1078 t1 CREATE TABLE `t1` (
1079 `a` int(11) DEFAULT NULL,
1080 `b` int(11) DEFAULT NULL,
1081 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1082 KEY `a` (`a`),
1083 VECTOR KEY `v` (`v`)
1084 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1085 count(*)
1086 2
1087 crash point: ddl_log_alter_after_log
1088 t1#i#01.MAD
1089 t1#i#01.MAI
1090 t1.MAD
1091 t1.MAI
1092 t1.frm
1093 Table Create Table
1094 t1 CREATE TABLE `t1` (
1095 `a` int(11) DEFAULT NULL,
1096 `b` int(11) DEFAULT NULL,
1097 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1098 KEY `a` (`a`),
1099 VECTOR KEY `v` (`v`)
1100 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1101 count(*)
1102 2
1103 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=aria, COMMENT "new"
1104 crash point: ddl_log_alter_after_rename_to_backup
1105 t1#i#01.MAD
1106 t1#i#01.MAI
1107 t1.MAD
1108 t1.MAI
1109 t1.frm
1110 Table Create Table
1111 t1 CREATE TABLE `t1` (
1112 `a` int(11) DEFAULT NULL,
1113 `b` int(11) DEFAULT NULL,
1114 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1115 KEY `a` (`a`),
1116 VECTOR KEY `v` (`v`)
1117 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1118 count(*)
1119 2
1120 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=aria, COMMENT "new"
1121 crash point: ddl_log_alter_after_rename_to_backup_log
1122 t1#i#01.MAD
1123 t1#i#01.MAI
1124 t1.MAD
1125 t1.MAI
1126 t1.frm
1127 Table Create Table
1128 t1 CREATE TABLE `t1` (
1129 `a` int(11) DEFAULT NULL,
1130 `b` int(11) DEFAULT NULL,
1131 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1132 KEY `a` (`a`),
1133 VECTOR KEY `v` (`v`)
1134 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1135 count(*)
1136 2
1137 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=aria, COMMENT "new"
1138 crash point: ddl_log_alter_rename_frm
1139 "No crash!"
1140 crash point: ddl_log_alter_after_rename_to_original
1141 t1#i#01.MAD
1142 t1#i#01.MAI
1143 t1.MAD
1144 t1.MAI
1145 t1.frm
1146 Table Create Table
1147 t1 CREATE TABLE `t1` (
1148 `a` int(11) DEFAULT NULL,
1149 `b` int(11) DEFAULT NULL,
1150 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1151 KEY `a` (`a`),
1152 VECTOR KEY `v` (`v`)
1153 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1154 count(*)
1155 2
1156 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=aria, COMMENT "new"
1157 crash point: ddl_log_alter_before_rename_triggers
1158 "No crash!"
1159 crash point: ddl_log_alter_after_rename_triggers
1160 "No crash!"
1161 crash point: ddl_log_alter_after_delete_backup
1162 t1#i#01.MAD
1163 t1#i#01.MAI
1164 t1.MAD
1165 t1.MAI
1166 t1.frm
1167 Table Create Table
1168 t1 CREATE TABLE `t1` (
1169 `a` int(11) DEFAULT NULL,
1170 `b` int(11) DEFAULT NULL,
1171 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1172 KEY `a` (`a`),
1173 VECTOR KEY `v` (`v`)
1174 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1175 count(*)
1176 2
1177 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=aria, COMMENT "new"
1178 crash point: ddl_log_alter_after_drop_original_table
1179 t1#i#01.MAD
1180 t1#i#01.MAI
1181 t1.MAD
1182 t1.MAI
1183 t1.frm
1184 Table Create Table
1185 t1 CREATE TABLE `t1` (
1186 `a` int(11) DEFAULT NULL,
1187 `b` int(11) DEFAULT NULL,
1188 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1189 KEY `a` (`a`),
1190 VECTOR KEY `v` (`v`)
1191 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1192 count(*)
1193 2
1194 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=aria, COMMENT "new"
1195
1196 query: ALTER TABLE t1 change column a c int COMMENT "new", engine=aria
1197
1198 crash point: ddl_log_alter_after_create_frm
1199 t1#i#01.MYD
1200 t1#i#01.MYI
1201 t1.MYD
1202 t1.MYI
1203 t1.frm
1204 Table Create Table
1205 t1 CREATE TABLE `t1` (
1206 `a` int(11) DEFAULT NULL,
1207 `b` int(11) DEFAULT NULL,
1208 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1209 KEY `a` (`a`),
1210 VECTOR KEY `v` (`v`)
1211 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1212 count(*)
1213 2
1214 crash point: ddl_log_alter_after_create_table
1215 t1#i#01.MYD
1216 t1#i#01.MYI
1217 t1.MYD
1218 t1.MYI
1219 t1.frm
1220 Table Create Table
1221 t1 CREATE TABLE `t1` (
1222 `a` int(11) DEFAULT NULL,
1223 `b` int(11) DEFAULT NULL,
1224 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1225 KEY `a` (`a`),
1226 VECTOR KEY `v` (`v`)
1227 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1228 count(*)
1229 2
1230 crash point: ddl_log_alter_after_prepare_inplace
1231 "No crash!"
1232 crash point: ddl_log_alter_after_copy
1233 t1#i#01.MYD
1234 t1#i#01.MYI
1235 t1.MYD
1236 t1.MYI
1237 t1.frm
1238 Table Create Table
1239 t1 CREATE TABLE `t1` (
1240 `a` int(11) DEFAULT NULL,
1241 `b` int(11) DEFAULT NULL,
1242 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1243 KEY `a` (`a`),
1244 VECTOR KEY `v` (`v`)
1245 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1246 count(*)
1247 2
1248 crash point: ddl_log_alter_after_log
1249 t1#i#01.MAD
1250 t1#i#01.MAI
1251 t1.MAD
1252 t1.MAI
1253 t1.frm
1254 Table Create Table
1255 t1 CREATE TABLE `t1` (
1256 `c` int(11) DEFAULT NULL COMMENT 'new',
1257 `b` int(11) DEFAULT NULL,
1258 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1259 KEY `a` (`c`),
1260 VECTOR KEY `v` (`v`)
1261 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
1262 count(*)
1263 2
1264 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=aria
1265 crash point: ddl_log_alter_after_rename_to_backup
1266 t1#i#01.MAD
1267 t1#i#01.MAI
1268 t1.MAD
1269 t1.MAI
1270 t1.frm
1271 Table Create Table
1272 t1 CREATE TABLE `t1` (
1273 `c` int(11) DEFAULT NULL COMMENT 'new',
1274 `b` int(11) DEFAULT NULL,
1275 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1276 KEY `a` (`c`),
1277 VECTOR KEY `v` (`v`)
1278 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
1279 count(*)
1280 2
1281 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=aria
1282 crash point: ddl_log_alter_after_rename_to_backup_log
1283 t1#i#01.MAD
1284 t1#i#01.MAI
1285 t1.MAD
1286 t1.MAI
1287 t1.frm
1288 Table Create Table
1289 t1 CREATE TABLE `t1` (
1290 `c` int(11) DEFAULT NULL COMMENT 'new',
1291 `b` int(11) DEFAULT NULL,
1292 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1293 KEY `a` (`c`),
1294 VECTOR KEY `v` (`v`)
1295 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
1296 count(*)
1297 2
1298 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=aria
1299 crash point: ddl_log_alter_rename_frm
1300 "No crash!"
1301 crash point: ddl_log_alter_after_rename_to_original
1302 t1#i#01.MAD
1303 t1#i#01.MAI
1304 t1.MAD
1305 t1.MAI
1306 t1.frm
1307 Table Create Table
1308 t1 CREATE TABLE `t1` (
1309 `c` int(11) DEFAULT NULL COMMENT 'new',
1310 `b` int(11) DEFAULT NULL,
1311 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1312 KEY `a` (`c`),
1313 VECTOR KEY `v` (`v`)
1314 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
1315 count(*)
1316 2
1317 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=aria
1318 crash point: ddl_log_alter_before_rename_triggers
1319 "No crash!"
1320 crash point: ddl_log_alter_after_rename_triggers
1321 "No crash!"
1322 crash point: ddl_log_alter_after_delete_backup
1323 t1#i#01.MAD
1324 t1#i#01.MAI
1325 t1.MAD
1326 t1.MAI
1327 t1.frm
1328 Table Create Table
1329 t1 CREATE TABLE `t1` (
1330 `c` int(11) DEFAULT NULL COMMENT 'new',
1331 `b` int(11) DEFAULT NULL,
1332 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1333 KEY `a` (`c`),
1334 VECTOR KEY `v` (`v`)
1335 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
1336 count(*)
1337 2
1338 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=aria
1339 crash point: ddl_log_alter_after_drop_original_table
1340 t1#i#01.MAD
1341 t1#i#01.MAI
1342 t1.MAD
1343 t1.MAI
1344 t1.frm
1345 Table Create Table
1346 t1 CREATE TABLE `t1` (
1347 `c` int(11) DEFAULT NULL COMMENT 'new',
1348 `b` int(11) DEFAULT NULL,
1349 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1350 KEY `a` (`c`),
1351 VECTOR KEY `v` (`v`)
1352 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
1353 count(*)
1354 2
1355 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=aria
1356
1357 query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1358
1359 crash point: ddl_log_alter_after_create_frm
1360 t1#i#01.MYD
1361 t1#i#01.MYI
1362 t1.MYD
1363 t1.MYI
1364 t1.frm
1365 Table Create Table
1366 t1 CREATE TABLE `t1` (
1367 `a` int(11) DEFAULT NULL,
1368 `b` int(11) DEFAULT NULL,
1369 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1370 KEY `a` (`a`),
1371 VECTOR KEY `v` (`v`)
1372 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1373 count(*)
1374 2
1375 crash point: ddl_log_alter_after_create_table
1376 t1#i#01.MYD
1377 t1#i#01.MYI
1378 t1.MYD
1379 t1.MYI
1380 t1.frm
1381 Table Create Table
1382 t1 CREATE TABLE `t1` (
1383 `a` int(11) DEFAULT NULL,
1384 `b` int(11) DEFAULT NULL,
1385 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1386 KEY `a` (`a`),
1387 VECTOR KEY `v` (`v`)
1388 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1389 count(*)
1390 2
1391 crash point: ddl_log_alter_after_prepare_inplace
1392 "No crash!"
1393 crash point: ddl_log_alter_after_copy
1394 t1#i#01.MYD
1395 t1#i#01.MYI
1396 t1.MYD
1397 t1.MYI
1398 t1.frm
1399 Table Create Table
1400 t1 CREATE TABLE `t1` (
1401 `a` int(11) DEFAULT NULL,
1402 `b` int(11) DEFAULT NULL,
1403 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1404 KEY `a` (`a`),
1405 VECTOR KEY `v` (`v`)
1406 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1407 count(*)
1408 2
1409 crash point: ddl_log_alter_after_log
1410 t2#i#01.MAD
1411 t2#i#01.MAI
1412 t2.MAD
1413 t2.MAI
1414 t2.frm
1415 Table Create Table
1416 t2 CREATE TABLE `t2` (
1417 `a` int(11) DEFAULT NULL,
1418 `b` int(11) DEFAULT NULL,
1419 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1420 `c` int(11) DEFAULT NULL,
1421 KEY `a` (`a`),
1422 VECTOR KEY `v` (`v`)
1423 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1424 count(*)
1425 2
1426 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1427 crash point: ddl_log_alter_after_rename_to_backup
1428 t2#i#01.MAD
1429 t2#i#01.MAI
1430 t2.MAD
1431 t2.MAI
1432 t2.frm
1433 Table Create Table
1434 t2 CREATE TABLE `t2` (
1435 `a` int(11) DEFAULT NULL,
1436 `b` int(11) DEFAULT NULL,
1437 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1438 `c` int(11) DEFAULT NULL,
1439 KEY `a` (`a`),
1440 VECTOR KEY `v` (`v`)
1441 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1442 count(*)
1443 2
1444 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1445 crash point: ddl_log_alter_after_rename_to_backup_log
1446 t2#i#01.MAD
1447 t2#i#01.MAI
1448 t2.MAD
1449 t2.MAI
1450 t2.frm
1451 Table Create Table
1452 t2 CREATE TABLE `t2` (
1453 `a` int(11) DEFAULT NULL,
1454 `b` int(11) DEFAULT NULL,
1455 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1456 `c` int(11) DEFAULT NULL,
1457 KEY `a` (`a`),
1458 VECTOR KEY `v` (`v`)
1459 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1460 count(*)
1461 2
1462 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1463 crash point: ddl_log_alter_rename_frm
1464 "No crash!"
1465 crash point: ddl_log_alter_after_rename_to_original
1466 t2#i#01.MAD
1467 t2#i#01.MAI
1468 t2.MAD
1469 t2.MAI
1470 t2.frm
1471 Table Create Table
1472 t2 CREATE TABLE `t2` (
1473 `a` int(11) DEFAULT NULL,
1474 `b` int(11) DEFAULT NULL,
1475 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1476 `c` int(11) DEFAULT NULL,
1477 KEY `a` (`a`),
1478 VECTOR KEY `v` (`v`)
1479 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1480 count(*)
1481 2
1482 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1483 crash point: ddl_log_alter_before_rename_triggers
1484 t2#i#01.MAD
1485 t2#i#01.MAI
1486 t2.MAD
1487 t2.MAI
1488 t2.frm
1489 Table Create Table
1490 t2 CREATE TABLE `t2` (
1491 `a` int(11) DEFAULT NULL,
1492 `b` int(11) DEFAULT NULL,
1493 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1494 `c` int(11) DEFAULT NULL,
1495 KEY `a` (`a`),
1496 VECTOR KEY `v` (`v`)
1497 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1498 count(*)
1499 2
1500 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1501 crash point: ddl_log_alter_after_rename_triggers
1502 t2#i#01.MAD
1503 t2#i#01.MAI
1504 t2.MAD
1505 t2.MAI
1506 t2.frm
1507 Table Create Table
1508 t2 CREATE TABLE `t2` (
1509 `a` int(11) DEFAULT NULL,
1510 `b` int(11) DEFAULT NULL,
1511 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1512 `c` int(11) DEFAULT NULL,
1513 KEY `a` (`a`),
1514 VECTOR KEY `v` (`v`)
1515 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1516 count(*)
1517 2
1518 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1519 crash point: ddl_log_alter_after_delete_backup
1520 t2#i#01.MAD
1521 t2#i#01.MAI
1522 t2.MAD
1523 t2.MAI
1524 t2.frm
1525 Table Create Table
1526 t2 CREATE TABLE `t2` (
1527 `a` int(11) DEFAULT NULL,
1528 `b` int(11) DEFAULT NULL,
1529 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1530 `c` int(11) DEFAULT NULL,
1531 KEY `a` (`a`),
1532 VECTOR KEY `v` (`v`)
1533 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1534 count(*)
1535 2
1536 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1537 crash point: ddl_log_alter_after_drop_original_table
1538 t2#i#01.MAD
1539 t2#i#01.MAI
1540 t2.MAD
1541 t2.MAI
1542 t2.frm
1543 Table Create Table
1544 t2 CREATE TABLE `t2` (
1545 `a` int(11) DEFAULT NULL,
1546 `b` int(11) DEFAULT NULL,
1547 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1548 `c` int(11) DEFAULT NULL,
1549 KEY `a` (`a`),
1550 VECTOR KEY `v` (`v`)
1551 ) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 COMMENT='new'
1552 count(*)
1553 2
1554 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=aria
1555
1556 query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1557
1558 crash point: ddl_log_alter_after_create_frm
1559 t1#i#01.MYD
1560 t1#i#01.MYI
1561 t1.MYD
1562 t1.MYI
1563 t1.frm
1564 Table Create Table
1565 t1 CREATE TABLE `t1` (
1566 `a` int(11) DEFAULT NULL,
1567 `b` int(11) DEFAULT NULL,
1568 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1569 KEY `a` (`a`),
1570 VECTOR KEY `v` (`v`)
1571 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1572 count(*)
1573 2
1574 crash point: ddl_log_alter_after_create_table
1575 t1#i#01.MYD
1576 t1#i#01.MYI
1577 t1.MYD
1578 t1.MYI
1579 t1.frm
1580 Table Create Table
1581 t1 CREATE TABLE `t1` (
1582 `a` int(11) DEFAULT NULL,
1583 `b` int(11) DEFAULT NULL,
1584 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1585 KEY `a` (`a`),
1586 VECTOR KEY `v` (`v`)
1587 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1588 count(*)
1589 2
1590 crash point: ddl_log_alter_after_prepare_inplace
1591 "No crash!"
1592 crash point: ddl_log_alter_after_copy
1593 t1#i#01.MYD
1594 t1#i#01.MYI
1595 t1.MYD
1596 t1.MYI
1597 t1.frm
1598 Table Create Table
1599 t1 CREATE TABLE `t1` (
1600 `a` int(11) DEFAULT NULL,
1601 `b` int(11) DEFAULT NULL,
1602 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1603 KEY `a` (`a`),
1604 VECTOR KEY `v` (`v`)
1605 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1606 count(*)
1607 2
1608 crash point: ddl_log_alter_after_log
1609 t2#i#01.MYD
1610 t2#i#01.MYI
1611 t2.MYD
1612 t2.MYI
1613 t2.frm
1614 "Table is in test2"
1615 Table Create Table
1616 t2 CREATE TABLE `t2` (
1617 `a` int(11) DEFAULT NULL,
1618 `b` int(11) DEFAULT NULL,
1619 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1620 `c` int(11) DEFAULT NULL,
1621 KEY `a` (`a`),
1622 VECTOR KEY `v` (`v`)
1623 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1624 count(*)
1625 2
1626 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1627 crash point: ddl_log_alter_after_rename_to_backup
1628 t2#i#01.MYD
1629 t2#i#01.MYI
1630 t2.MYD
1631 t2.MYI
1632 t2.frm
1633 "Table is in test2"
1634 Table Create Table
1635 t2 CREATE TABLE `t2` (
1636 `a` int(11) DEFAULT NULL,
1637 `b` int(11) DEFAULT NULL,
1638 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1639 `c` int(11) DEFAULT NULL,
1640 KEY `a` (`a`),
1641 VECTOR KEY `v` (`v`)
1642 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1643 count(*)
1644 2
1645 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1646 crash point: ddl_log_alter_after_rename_to_backup_log
1647 t2#i#01.MYD
1648 t2#i#01.MYI
1649 t2.MYD
1650 t2.MYI
1651 t2.frm
1652 "Table is in test2"
1653 Table Create Table
1654 t2 CREATE TABLE `t2` (
1655 `a` int(11) DEFAULT NULL,
1656 `b` int(11) DEFAULT NULL,
1657 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1658 `c` int(11) DEFAULT NULL,
1659 KEY `a` (`a`),
1660 VECTOR KEY `v` (`v`)
1661 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1662 count(*)
1663 2
1664 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1665 crash point: ddl_log_alter_rename_frm
1666 "No crash!"
1667 crash point: ddl_log_alter_after_rename_to_original
1668 t2#i#01.MYD
1669 t2#i#01.MYI
1670 t2.MYD
1671 t2.MYI
1672 t2.frm
1673 "Table is in test2"
1674 Table Create Table
1675 t2 CREATE TABLE `t2` (
1676 `a` int(11) DEFAULT NULL,
1677 `b` int(11) DEFAULT NULL,
1678 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1679 `c` int(11) DEFAULT NULL,
1680 KEY `a` (`a`),
1681 VECTOR KEY `v` (`v`)
1682 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1683 count(*)
1684 2
1685 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1686 crash point: ddl_log_alter_before_rename_triggers
1687 t2#i#01.MYD
1688 t2#i#01.MYI
1689 t2.MYD
1690 t2.MYI
1691 t2.frm
1692 "Table is in test2"
1693 Table Create Table
1694 t2 CREATE TABLE `t2` (
1695 `a` int(11) DEFAULT NULL,
1696 `b` int(11) DEFAULT NULL,
1697 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1698 `c` int(11) DEFAULT NULL,
1699 KEY `a` (`a`),
1700 VECTOR KEY `v` (`v`)
1701 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1702 count(*)
1703 2
1704 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1705 crash point: ddl_log_alter_after_rename_triggers
1706 t2#i#01.MYD
1707 t2#i#01.MYI
1708 t2.MYD
1709 t2.MYI
1710 t2.frm
1711 "Table is in test2"
1712 Table Create Table
1713 t2 CREATE TABLE `t2` (
1714 `a` int(11) DEFAULT NULL,
1715 `b` int(11) DEFAULT NULL,
1716 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1717 `c` int(11) DEFAULT NULL,
1718 KEY `a` (`a`),
1719 VECTOR KEY `v` (`v`)
1720 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1721 count(*)
1722 2
1723 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1724 crash point: ddl_log_alter_after_delete_backup
1725 t2#i#01.MYD
1726 t2#i#01.MYI
1727 t2.MYD
1728 t2.MYI
1729 t2.frm
1730 "Table is in test2"
1731 Table Create Table
1732 t2 CREATE TABLE `t2` (
1733 `a` int(11) DEFAULT NULL,
1734 `b` int(11) DEFAULT NULL,
1735 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1736 `c` int(11) DEFAULT NULL,
1737 KEY `a` (`a`),
1738 VECTOR KEY `v` (`v`)
1739 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1740 count(*)
1741 2
1742 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1743 crash point: ddl_log_alter_after_drop_original_table
1744 t2#i#01.MYD
1745 t2#i#01.MYI
1746 t2.MYD
1747 t2.MYI
1748 t2.frm
1749 "Table is in test2"
1750 Table Create Table
1751 t2 CREATE TABLE `t2` (
1752 `a` int(11) DEFAULT NULL,
1753 `b` int(11) DEFAULT NULL,
1754 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1755 `c` int(11) DEFAULT NULL,
1756 KEY `a` (`a`),
1757 VECTOR KEY `v` (`v`)
1758 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1759 count(*)
1760 2
1761 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
1762
1763 query: ALTER TABLE t1 COMMENT "new", rename test2.t2
1764
1765 crash point: ddl_log_alter_after_create_frm
1766 t1#i#01.MYD
1767 t1#i#01.MYI
1768 t1.MYD
1769 t1.MYI
1770 t1.frm
1771 Table Create Table
1772 t1 CREATE TABLE `t1` (
1773 `a` int(11) DEFAULT NULL,
1774 `b` int(11) DEFAULT NULL,
1775 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1776 KEY `a` (`a`),
1777 VECTOR KEY `v` (`v`)
1778 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1779 count(*)
1780 2
1781 crash point: ddl_log_alter_after_create_table
1782 "No crash!"
1783 crash point: ddl_log_alter_after_prepare_inplace
1784 t1#i#01.MYD
1785 t1#i#01.MYI
1786 t1.MYD
1787 t1.MYI
1788 t1.frm
1789 Table Create Table
1790 t1 CREATE TABLE `t1` (
1791 `a` int(11) DEFAULT NULL,
1792 `b` int(11) DEFAULT NULL,
1793 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1794 KEY `a` (`a`),
1795 VECTOR KEY `v` (`v`)
1796 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1797 count(*)
1798 2
1799 crash point: ddl_log_alter_after_copy
1800 t1#i#01.MYD
1801 t1#i#01.MYI
1802 t1.MYD
1803 t1.MYI
1804 t1.frm
1805 Table Create Table
1806 t1 CREATE TABLE `t1` (
1807 `a` int(11) DEFAULT NULL,
1808 `b` int(11) DEFAULT NULL,
1809 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1810 KEY `a` (`a`),
1811 VECTOR KEY `v` (`v`)
1812 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1813 count(*)
1814 2
1815 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename test2.t2
1816 crash point: ddl_log_alter_after_log
1817 t1#i#01.MYD
1818 t1#i#01.MYI
1819 t1.MYD
1820 t1.MYI
1821 t1.frm
1822 Table Create Table
1823 t1 CREATE TABLE `t1` (
1824 `a` int(11) DEFAULT NULL,
1825 `b` int(11) DEFAULT NULL,
1826 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1827 KEY `a` (`a`),
1828 VECTOR KEY `v` (`v`)
1829 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1830 count(*)
1831 2
1832 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename test2.t2
1833 crash point: ddl_log_alter_after_rename_to_backup
1834 "No crash!"
1835 crash point: ddl_log_alter_after_rename_to_backup_log
1836 "No crash!"
1837 crash point: ddl_log_alter_rename_frm
1838 "No crash!"
1839 crash point: ddl_log_alter_after_rename_to_original
1840 "No crash!"
1841 crash point: ddl_log_alter_before_rename_triggers
1842 t2#i#01.MYD
1843 t2#i#01.MYI
1844 t2.MYD
1845 t2.MYI
1846 t2.frm
1847 "Table is in test2"
1848 Table Create Table
1849 t2 CREATE TABLE `t2` (
1850 `a` int(11) DEFAULT NULL,
1851 `b` int(11) DEFAULT NULL,
1852 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1853 KEY `a` (`a`),
1854 VECTOR KEY `v` (`v`)
1855 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1856 count(*)
1857 2
1858 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename test2.t2
1859 crash point: ddl_log_alter_after_rename_triggers
1860 t2#i#01.MYD
1861 t2#i#01.MYI
1862 t2.MYD
1863 t2.MYI
1864 t2.frm
1865 "Table is in test2"
1866 Table Create Table
1867 t2 CREATE TABLE `t2` (
1868 `a` int(11) DEFAULT NULL,
1869 `b` int(11) DEFAULT NULL,
1870 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1871 KEY `a` (`a`),
1872 VECTOR KEY `v` (`v`)
1873 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1874 count(*)
1875 2
1876 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename test2.t2
1877 crash point: ddl_log_alter_after_delete_backup
1878 "No crash!"
1879 crash point: ddl_log_alter_after_drop_original_table
1880 "No crash!"
1881
1882 query: ALTER TABLE t1 ADD key(b), COMMENT "new"
1883
1884 crash point: ddl_log_alter_after_create_frm
1885 t1#i#01.MYD
1886 t1#i#01.MYI
1887 t1.MYD
1888 t1.MYI
1889 t1.frm
1890 Table Create Table
1891 t1 CREATE TABLE `t1` (
1892 `a` int(11) DEFAULT NULL,
1893 `b` int(11) DEFAULT NULL,
1894 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1895 KEY `a` (`a`),
1896 VECTOR KEY `v` (`v`)
1897 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1898 count(*)
1899 2
1900 crash point: ddl_log_alter_after_create_table
1901 t1#i#01.MYD
1902 t1#i#01.MYI
1903 t1.MYD
1904 t1.MYI
1905 t1.frm
1906 Table Create Table
1907 t1 CREATE TABLE `t1` (
1908 `a` int(11) DEFAULT NULL,
1909 `b` int(11) DEFAULT NULL,
1910 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1911 KEY `a` (`a`),
1912 VECTOR KEY `v` (`v`)
1913 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1914 count(*)
1915 2
1916 crash point: ddl_log_alter_after_prepare_inplace
1917 "No crash!"
1918 crash point: ddl_log_alter_after_copy
1919 t1#i#01.MYD
1920 t1#i#01.MYI
1921 t1.MYD
1922 t1.MYI
1923 t1.frm
1924 Table Create Table
1925 t1 CREATE TABLE `t1` (
1926 `a` int(11) DEFAULT NULL,
1927 `b` int(11) DEFAULT NULL,
1928 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1929 KEY `a` (`a`),
1930 VECTOR KEY `v` (`v`)
1931 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1932 count(*)
1933 2
1934 crash point: ddl_log_alter_after_log
1935 t1#i#02.MYD
1936 t1#i#02.MYI
1937 t1.MYD
1938 t1.MYI
1939 t1.frm
1940 Table Create Table
1941 t1 CREATE TABLE `t1` (
1942 `a` int(11) DEFAULT NULL,
1943 `b` int(11) DEFAULT NULL,
1944 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1945 KEY `a` (`a`),
1946 KEY `b` (`b`),
1947 VECTOR KEY `v` (`v`)
1948 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1949 count(*)
1950 2
1951 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
1952 crash point: ddl_log_alter_after_rename_to_backup
1953 t1#i#02.MYD
1954 t1#i#02.MYI
1955 t1.MYD
1956 t1.MYI
1957 t1.frm
1958 Table Create Table
1959 t1 CREATE TABLE `t1` (
1960 `a` int(11) DEFAULT NULL,
1961 `b` int(11) DEFAULT NULL,
1962 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1963 KEY `a` (`a`),
1964 KEY `b` (`b`),
1965 VECTOR KEY `v` (`v`)
1966 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1967 count(*)
1968 2
1969 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
1970 crash point: ddl_log_alter_after_rename_to_backup_log
1971 t1#i#02.MYD
1972 t1#i#02.MYI
1973 t1.MYD
1974 t1.MYI
1975 t1.frm
1976 Table Create Table
1977 t1 CREATE TABLE `t1` (
1978 `a` int(11) DEFAULT NULL,
1979 `b` int(11) DEFAULT NULL,
1980 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
1981 KEY `a` (`a`),
1982 KEY `b` (`b`),
1983 VECTOR KEY `v` (`v`)
1984 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
1985 count(*)
1986 2
1987 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
1988 crash point: ddl_log_alter_rename_frm
1989 "No crash!"
1990 crash point: ddl_log_alter_after_rename_to_original
1991 t1#i#02.MYD
1992 t1#i#02.MYI
1993 t1.MYD
1994 t1.MYI
1995 t1.frm
1996 Table Create Table
1997 t1 CREATE TABLE `t1` (
1998 `a` int(11) DEFAULT NULL,
1999 `b` int(11) DEFAULT NULL,
2000 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2001 KEY `a` (`a`),
2002 KEY `b` (`b`),
2003 VECTOR KEY `v` (`v`)
2004 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
2005 count(*)
2006 2
2007 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
2008 crash point: ddl_log_alter_before_rename_triggers
2009 "No crash!"
2010 crash point: ddl_log_alter_after_rename_triggers
2011 "No crash!"
2012 crash point: ddl_log_alter_after_delete_backup
2013 t1#i#02.MYD
2014 t1#i#02.MYI
2015 t1.MYD
2016 t1.MYI
2017 t1.frm
2018 Table Create Table
2019 t1 CREATE TABLE `t1` (
2020 `a` int(11) DEFAULT NULL,
2021 `b` int(11) DEFAULT NULL,
2022 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2023 KEY `a` (`a`),
2024 KEY `b` (`b`),
2025 VECTOR KEY `v` (`v`)
2026 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
2027 count(*)
2028 2
2029 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
2030 crash point: ddl_log_alter_after_drop_original_table
2031 t1#i#02.MYD
2032 t1#i#02.MYI
2033 t1.MYD
2034 t1.MYI
2035 t1.frm
2036 Table Create Table
2037 t1 CREATE TABLE `t1` (
2038 `a` int(11) DEFAULT NULL,
2039 `b` int(11) DEFAULT NULL,
2040 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2041 KEY `a` (`a`),
2042 KEY `b` (`b`),
2043 VECTOR KEY `v` (`v`)
2044 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
2045 count(*)
2046 2
2047 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
2048
2049 query: ALTER TABLE t1 DROP INDEX a
2050
2051 crash point: ddl_log_alter_after_create_frm
2052 t1#i#01.MYD
2053 t1#i#01.MYI
2054 t1.MYD
2055 t1.MYI
2056 t1.frm
2057 Table Create Table
2058 t1 CREATE TABLE `t1` (
2059 `a` int(11) DEFAULT NULL,
2060 `b` int(11) DEFAULT NULL,
2061 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2062 KEY `a` (`a`),
2063 VECTOR KEY `v` (`v`)
2064 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2065 count(*)
2066 2
2067 crash point: ddl_log_alter_after_create_table
2068 t1#i#01.MYD
2069 t1#i#01.MYI
2070 t1.MYD
2071 t1.MYI
2072 t1.frm
2073 Table Create Table
2074 t1 CREATE TABLE `t1` (
2075 `a` int(11) DEFAULT NULL,
2076 `b` int(11) DEFAULT NULL,
2077 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2078 KEY `a` (`a`),
2079 VECTOR KEY `v` (`v`)
2080 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2081 count(*)
2082 2
2083 crash point: ddl_log_alter_after_prepare_inplace
2084 "No crash!"
2085 crash point: ddl_log_alter_after_copy
2086 t1#i#01.MYD
2087 t1#i#01.MYI
2088 t1.MYD
2089 t1.MYI
2090 t1.frm
2091 Table Create Table
2092 t1 CREATE TABLE `t1` (
2093 `a` int(11) DEFAULT NULL,
2094 `b` int(11) DEFAULT NULL,
2095 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2096 KEY `a` (`a`),
2097 VECTOR KEY `v` (`v`)
2098 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2099 count(*)
2100 2
2101 crash point: ddl_log_alter_after_log
2102 t1#i#00.MYD
2103 t1#i#00.MYI
2104 t1.MYD
2105 t1.MYI
2106 t1.frm
2107 Table Create Table
2108 t1 CREATE TABLE `t1` (
2109 `a` int(11) DEFAULT NULL,
2110 `b` int(11) DEFAULT NULL,
2111 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2112 VECTOR KEY `v` (`v`)
2113 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2114 count(*)
2115 2
2116 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
2117 crash point: ddl_log_alter_after_rename_to_backup
2118 t1#i#00.MYD
2119 t1#i#00.MYI
2120 t1.MYD
2121 t1.MYI
2122 t1.frm
2123 Table Create Table
2124 t1 CREATE TABLE `t1` (
2125 `a` int(11) DEFAULT NULL,
2126 `b` int(11) DEFAULT NULL,
2127 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2128 VECTOR KEY `v` (`v`)
2129 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2130 count(*)
2131 2
2132 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
2133 crash point: ddl_log_alter_after_rename_to_backup_log
2134 t1#i#00.MYD
2135 t1#i#00.MYI
2136 t1.MYD
2137 t1.MYI
2138 t1.frm
2139 Table Create Table
2140 t1 CREATE TABLE `t1` (
2141 `a` int(11) DEFAULT NULL,
2142 `b` int(11) DEFAULT NULL,
2143 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2144 VECTOR KEY `v` (`v`)
2145 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2146 count(*)
2147 2
2148 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
2149 crash point: ddl_log_alter_rename_frm
2150 "No crash!"
2151 crash point: ddl_log_alter_after_rename_to_original
2152 t1#i#00.MYD
2153 t1#i#00.MYI
2154 t1.MYD
2155 t1.MYI
2156 t1.frm
2157 Table Create Table
2158 t1 CREATE TABLE `t1` (
2159 `a` int(11) DEFAULT NULL,
2160 `b` int(11) DEFAULT NULL,
2161 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2162 VECTOR KEY `v` (`v`)
2163 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2164 count(*)
2165 2
2166 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
2167 crash point: ddl_log_alter_before_rename_triggers
2168 "No crash!"
2169 crash point: ddl_log_alter_after_rename_triggers
2170 "No crash!"
2171 crash point: ddl_log_alter_after_delete_backup
2172 t1#i#00.MYD
2173 t1#i#00.MYI
2174 t1.MYD
2175 t1.MYI
2176 t1.frm
2177 Table Create Table
2178 t1 CREATE TABLE `t1` (
2179 `a` int(11) DEFAULT NULL,
2180 `b` int(11) DEFAULT NULL,
2181 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2182 VECTOR KEY `v` (`v`)
2183 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2184 count(*)
2185 2
2186 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
2187 crash point: ddl_log_alter_after_drop_original_table
2188 t1#i#00.MYD
2189 t1#i#00.MYI
2190 t1.MYD
2191 t1.MYI
2192 t1.frm
2193 Table Create Table
2194 t1 CREATE TABLE `t1` (
2195 `a` int(11) DEFAULT NULL,
2196 `b` int(11) DEFAULT NULL,
2197 `v` vector(5) NOT NULL DEFAULT x'e360d63ebe554f3fcdbc523f4522193f5236083d',
2198 VECTOR KEY `v` (`v`)
2199 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
2200 count(*)
2201 2
2202 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
2203 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;