Debian Codegraph @

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