Debian Codegraph @

mysql-test/suite/atomic/alter_table_aria.result

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