Debian Codegraph @

mysql-test/suite/atomic/alter_table_rocksdb.result

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