Debian Codegraph @

mysql-test/suite/atomic/alter_table_innodb.result

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