Debian Codegraph @

mysql-test/suite/atomic/alter_partition.result

raw
1 # Crash recovery
2 create or replace procedure prepare_table(r int)
3 begin
4 create or replace table t1 (x int)
5 with system versioning
6 partition by range(x) (
7 partition p0 values less than (10),
8 partition p1 values less than (20),
9 partition pn values less than (30));
10 insert into t1 values (2), (12), (22);
11 if r > 1 then
12 create or replace table tp2 (x int)
13 with system versioning;
14 insert into tp2 values (32), (39);
15 end if;
16 flush tables;
17 end $
18 # QUERY: ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE tp1
19 # CRASH: crash_create_before_create_frm
20 t1#P#p0.MYD
21 t1#P#p0.MYI
22 t1#P#p1.MYD
23 t1#P#p1.MYI
24 t1#P#pn.MYD
25 t1#P#pn.MYI
26 t1.frm
27 t1.par
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `x` int(11) DEFAULT NULL
31 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
32 PARTITION BY RANGE (`x`)
33 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
34 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
35 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
36 x
37 2
38 12
39 22
40 # CRASH: crash_alter_partition_after_create_frm
41 t1#P#p0.MYD
42 t1#P#p0.MYI
43 t1#P#p1.MYD
44 t1#P#p1.MYI
45 t1#P#pn.MYD
46 t1#P#pn.MYI
47 t1.frm
48 t1.par
49 Table Create Table
50 t1 CREATE TABLE `t1` (
51 `x` int(11) DEFAULT NULL
52 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
53 PARTITION BY RANGE (`x`)
54 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
55 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
56 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
57 x
58 2
59 12
60 22
61 # CRASH: crash_alter_partition_after_write_frm
62 t1#P#p0.MYD
63 t1#P#p0.MYI
64 t1#P#p1.MYD
65 t1#P#p1.MYI
66 t1#P#pn.MYD
67 t1#P#pn.MYI
68 t1.frm
69 t1.par
70 Table Create Table
71 t1 CREATE TABLE `t1` (
72 `x` int(11) DEFAULT NULL
73 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
74 PARTITION BY RANGE (`x`)
75 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
76 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
77 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
78 x
79 2
80 12
81 22
82 # CRASH: crash_convert_partition_1
83 t1#P#p0.MYD
84 t1#P#p0.MYI
85 t1#P#p1.MYD
86 t1#P#p1.MYI
87 t1#P#pn.MYD
88 t1#P#pn.MYI
89 t1.frm
90 t1.par
91 Table Create Table
92 t1 CREATE TABLE `t1` (
93 `x` int(11) DEFAULT NULL
94 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
95 PARTITION BY RANGE (`x`)
96 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
97 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
98 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
99 x
100 2
101 12
102 22
103 # CRASH: crash_convert_partition_2
104 t1#P#p0.MYD
105 t1#P#p0.MYI
106 t1#P#p1.MYD
107 t1#P#p1.MYI
108 t1#P#pn.MYD
109 t1#P#pn.MYI
110 t1.frm
111 t1.par
112 Table Create Table
113 t1 CREATE TABLE `t1` (
114 `x` int(11) DEFAULT NULL
115 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
116 PARTITION BY RANGE (`x`)
117 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
118 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
119 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
120 x
121 2
122 12
123 22
124 # CRASH: crash_convert_partition_3
125 t1#P#p0.MYD
126 t1#P#p0.MYI
127 t1#P#p1.MYD
128 t1#P#p1.MYI
129 t1#P#pn.MYD
130 t1#P#pn.MYI
131 t1.frm
132 t1.par
133 Table Create Table
134 t1 CREATE TABLE `t1` (
135 `x` int(11) DEFAULT NULL
136 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
137 PARTITION BY RANGE (`x`)
138 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
139 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
140 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
141 x
142 2
143 12
144 22
145 # CRASH: crash_convert_partition_4
146 t1#P#p0.MYD
147 t1#P#p0.MYI
148 t1#P#p1.MYD
149 t1#P#p1.MYI
150 t1#P#pn.MYD
151 t1#P#pn.MYI
152 t1.frm
153 t1.par
154 Table Create Table
155 t1 CREATE TABLE `t1` (
156 `x` int(11) DEFAULT NULL
157 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
158 PARTITION BY RANGE (`x`)
159 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
160 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
161 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
162 x
163 2
164 12
165 22
166 # CRASH: crash_convert_partition_5
167 t1#P#p0.MYD
168 t1#P#p0.MYI
169 t1#P#p1.MYD
170 t1#P#p1.MYI
171 t1#P#pn.MYD
172 t1#P#pn.MYI
173 t1.frm
174 t1.par
175 Table Create Table
176 t1 CREATE TABLE `t1` (
177 `x` int(11) DEFAULT NULL
178 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
179 PARTITION BY RANGE (`x`)
180 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
181 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
182 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
183 x
184 2
185 12
186 22
187 # CRASH: crash_convert_partition_6
188 t1#P#p0.MYD
189 t1#P#p0.MYI
190 t1#P#p1.MYD
191 t1#P#p1.MYI
192 t1#P#pn.MYD
193 t1#P#pn.MYI
194 t1.frm
195 t1.par
196 Table Create Table
197 t1 CREATE TABLE `t1` (
198 `x` int(11) DEFAULT NULL
199 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
200 PARTITION BY RANGE (`x`)
201 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
202 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
203 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
204 x
205 2
206 12
207 22
208 # CRASH: crash_convert_partition_7
209 t1#P#p0.MYD
210 t1#P#p0.MYI
211 t1#P#p1.MYD
212 t1#P#p1.MYI
213 t1#P#pn.MYD
214 t1#P#pn.MYI
215 t1.frm
216 t1.par
217 Table Create Table
218 t1 CREATE TABLE `t1` (
219 `x` int(11) DEFAULT NULL
220 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
221 PARTITION BY RANGE (`x`)
222 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
223 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
224 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
225 x
226 2
227 12
228 22
229 # CRASH: crash_convert_partition_8
230 t1#P#p0.MYD
231 t1#P#p0.MYI
232 t1#P#p1.MYD
233 t1#P#p1.MYI
234 t1#P#pn.MYD
235 t1#P#pn.MYI
236 t1.frm
237 t1.par
238 Table Create Table
239 t1 CREATE TABLE `t1` (
240 `x` int(11) DEFAULT NULL
241 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
242 PARTITION BY RANGE (`x`)
243 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
244 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
245 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
246 x
247 2
248 12
249 22
250 # CRASH: crash_convert_partition_9
251 t1#P#p0.MYD
252 t1#P#p0.MYI
253 t1#P#pn.MYD
254 t1#P#pn.MYI
255 t1.frm
256 t1.par
257 tp1.MYD
258 tp1.MYI
259 tp1.frm
260 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE tp1
261 Table Create Table
262 t1 CREATE TABLE `t1` (
263 `x` int(11) DEFAULT NULL
264 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
265 PARTITION BY RANGE (`x`)
266 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
267 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
268 x
269 2
270 22
271 Table Create Table
272 tp1 CREATE TABLE `tp1` (
273 `x` int(11) DEFAULT NULL
274 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
275 x
276 12
277 # CRASH: crash_convert_partition_10
278 t1#P#p0.MYD
279 t1#P#p0.MYI
280 t1#P#pn.MYD
281 t1#P#pn.MYI
282 t1.frm
283 t1.par
284 tp1.MYD
285 tp1.MYI
286 tp1.frm
287 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE tp1
288 Table Create Table
289 t1 CREATE TABLE `t1` (
290 `x` int(11) DEFAULT NULL
291 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
292 PARTITION BY RANGE (`x`)
293 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
294 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
295 x
296 2
297 22
298 Table Create Table
299 tp1 CREATE TABLE `tp1` (
300 `x` int(11) DEFAULT NULL
301 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
302 x
303 12
304 # CRASH: crash_convert_partition_11
305 t1#P#p0.MYD
306 t1#P#p0.MYI
307 t1#P#pn.MYD
308 t1#P#pn.MYI
309 t1.frm
310 t1.par
311 tp1.MYD
312 tp1.MYI
313 tp1.frm
314 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE tp1
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `x` int(11) DEFAULT NULL
318 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
319 PARTITION BY RANGE (`x`)
320 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
321 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
322 x
323 2
324 22
325 Table Create Table
326 tp1 CREATE TABLE `tp1` (
327 `x` int(11) DEFAULT NULL
328 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
329 x
330 12
331 # QUERY: ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)
332 # NO CRASH: crash_create_before_create_frm
333 t1#P#p0.MYD
334 t1#P#p0.MYI
335 t1#P#p1.MYD
336 t1#P#p1.MYI
337 t1#P#p2.MYD
338 t1#P#p2.MYI
339 t1#P#pn.MYD
340 t1#P#pn.MYI
341 t1.frm
342 t1.par
343 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)
344 Table Create Table
345 t1 CREATE TABLE `t1` (
346 `x` int(11) DEFAULT NULL
347 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
348 PARTITION BY RANGE (`x`)
349 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
350 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
351 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE,
352 PARTITION `p2` VALUES LESS THAN (40) ENGINE = DEFAULT_ENGINE)
353 x
354 2
355 12
356 22
357 32
358 39
359 # NO CRASH: crash_alter_partition_after_create_frm
360 t1#P#p0.MYD
361 t1#P#p0.MYI
362 t1#P#p1.MYD
363 t1#P#p1.MYI
364 t1#P#p2.MYD
365 t1#P#p2.MYI
366 t1#P#pn.MYD
367 t1#P#pn.MYI
368 t1.frm
369 t1.par
370 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)
371 Table Create Table
372 t1 CREATE TABLE `t1` (
373 `x` int(11) DEFAULT NULL
374 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
375 PARTITION BY RANGE (`x`)
376 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
377 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
378 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE,
379 PARTITION `p2` VALUES LESS THAN (40) ENGINE = DEFAULT_ENGINE)
380 x
381 2
382 12
383 22
384 32
385 39
386 # NO CRASH: crash_alter_partition_after_write_frm
387 t1#P#p0.MYD
388 t1#P#p0.MYI
389 t1#P#p1.MYD
390 t1#P#p1.MYI
391 t1#P#p2.MYD
392 t1#P#p2.MYI
393 t1#P#pn.MYD
394 t1#P#pn.MYI
395 t1.frm
396 t1.par
397 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)
398 Table Create Table
399 t1 CREATE TABLE `t1` (
400 `x` int(11) DEFAULT NULL
401 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
402 PARTITION BY RANGE (`x`)
403 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
404 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
405 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE,
406 PARTITION `p2` VALUES LESS THAN (40) ENGINE = DEFAULT_ENGINE)
407 x
408 2
409 12
410 22
411 32
412 39
413 # CRASH: crash_convert_partition_1
414 t1#P#p0.MYD
415 t1#P#p0.MYI
416 t1#P#p1.MYD
417 t1#P#p1.MYI
418 t1#P#pn.MYD
419 t1#P#pn.MYI
420 t1.frm
421 t1.par
422 tp2.MYD
423 tp2.MYI
424 tp2.frm
425 Table Create Table
426 t1 CREATE TABLE `t1` (
427 `x` int(11) DEFAULT NULL
428 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
429 PARTITION BY RANGE (`x`)
430 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
431 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
432 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
433 x
434 2
435 12
436 22
437 Table Create Table
438 tp2 CREATE TABLE `tp2` (
439 `x` int(11) DEFAULT NULL
440 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
441 x
442 32
443 39
444 # CRASH: crash_convert_partition_2
445 t1#P#p0.MYD
446 t1#P#p0.MYI
447 t1#P#p1.MYD
448 t1#P#p1.MYI
449 t1#P#pn.MYD
450 t1#P#pn.MYI
451 t1.frm
452 t1.par
453 tp2.MYD
454 tp2.MYI
455 tp2.frm
456 Table Create Table
457 t1 CREATE TABLE `t1` (
458 `x` int(11) DEFAULT NULL
459 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
460 PARTITION BY RANGE (`x`)
461 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
462 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
463 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
464 x
465 2
466 12
467 22
468 Table Create Table
469 tp2 CREATE TABLE `tp2` (
470 `x` int(11) DEFAULT NULL
471 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
472 x
473 32
474 39
475 # CRASH: crash_convert_partition_3
476 t1#P#p0.MYD
477 t1#P#p0.MYI
478 t1#P#p1.MYD
479 t1#P#p1.MYI
480 t1#P#pn.MYD
481 t1#P#pn.MYI
482 t1.frm
483 t1.par
484 tp2.MYD
485 tp2.MYI
486 tp2.frm
487 Table Create Table
488 t1 CREATE TABLE `t1` (
489 `x` int(11) DEFAULT NULL
490 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
491 PARTITION BY RANGE (`x`)
492 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
493 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
494 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
495 x
496 2
497 12
498 22
499 Table Create Table
500 tp2 CREATE TABLE `tp2` (
501 `x` int(11) DEFAULT NULL
502 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
503 x
504 32
505 39
506 # CRASH: crash_convert_partition_4
507 t1#P#p0.MYD
508 t1#P#p0.MYI
509 t1#P#p1.MYD
510 t1#P#p1.MYI
511 t1#P#pn.MYD
512 t1#P#pn.MYI
513 t1.frm
514 t1.par
515 tp2.MYD
516 tp2.MYI
517 tp2.frm
518 Table Create Table
519 t1 CREATE TABLE `t1` (
520 `x` int(11) DEFAULT NULL
521 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
522 PARTITION BY RANGE (`x`)
523 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
524 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
525 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
526 x
527 2
528 12
529 22
530 Table Create Table
531 tp2 CREATE TABLE `tp2` (
532 `x` int(11) DEFAULT NULL
533 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
534 x
535 32
536 39
537 # CRASH: crash_convert_partition_5
538 t1#P#p0.MYD
539 t1#P#p0.MYI
540 t1#P#p1.MYD
541 t1#P#p1.MYI
542 t1#P#pn.MYD
543 t1#P#pn.MYI
544 t1.frm
545 t1.par
546 tp2.MYD
547 tp2.MYI
548 tp2.frm
549 Table Create Table
550 t1 CREATE TABLE `t1` (
551 `x` int(11) DEFAULT NULL
552 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
553 PARTITION BY RANGE (`x`)
554 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
555 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
556 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
557 x
558 2
559 12
560 22
561 Table Create Table
562 tp2 CREATE TABLE `tp2` (
563 `x` int(11) DEFAULT NULL
564 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
565 x
566 32
567 39
568 # CRASH: crash_convert_partition_6
569 t1#P#p0.MYD
570 t1#P#p0.MYI
571 t1#P#p1.MYD
572 t1#P#p1.MYI
573 t1#P#pn.MYD
574 t1#P#pn.MYI
575 t1.frm
576 t1.par
577 tp2.MYD
578 tp2.MYI
579 tp2.frm
580 Table Create Table
581 t1 CREATE TABLE `t1` (
582 `x` int(11) DEFAULT NULL
583 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
584 PARTITION BY RANGE (`x`)
585 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
586 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
587 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
588 x
589 2
590 12
591 22
592 Table Create Table
593 tp2 CREATE TABLE `tp2` (
594 `x` int(11) DEFAULT NULL
595 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
596 x
597 32
598 39
599 # CRASH: crash_convert_partition_7
600 t1#P#p0.MYD
601 t1#P#p0.MYI
602 t1#P#p1.MYD
603 t1#P#p1.MYI
604 t1#P#pn.MYD
605 t1#P#pn.MYI
606 t1.frm
607 t1.par
608 tp2.MYD
609 tp2.MYI
610 tp2.frm
611 Table Create Table
612 t1 CREATE TABLE `t1` (
613 `x` int(11) DEFAULT NULL
614 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
615 PARTITION BY RANGE (`x`)
616 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
617 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
618 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
619 x
620 2
621 12
622 22
623 Table Create Table
624 tp2 CREATE TABLE `tp2` (
625 `x` int(11) DEFAULT NULL
626 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
627 x
628 32
629 39
630 # CRASH: crash_convert_partition_8
631 t1#P#p0.MYD
632 t1#P#p0.MYI
633 t1#P#p1.MYD
634 t1#P#p1.MYI
635 t1#P#pn.MYD
636 t1#P#pn.MYI
637 t1.frm
638 t1.par
639 tp2.MYD
640 tp2.MYI
641 tp2.frm
642 Table Create Table
643 t1 CREATE TABLE `t1` (
644 `x` int(11) DEFAULT NULL
645 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
646 PARTITION BY RANGE (`x`)
647 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
648 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
649 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE)
650 x
651 2
652 12
653 22
654 Table Create Table
655 tp2 CREATE TABLE `tp2` (
656 `x` int(11) DEFAULT NULL
657 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
658 x
659 32
660 39
661 # CRASH: crash_convert_partition_9
662 t1#P#p0.MYD
663 t1#P#p0.MYI
664 t1#P#p1.MYD
665 t1#P#p1.MYI
666 t1#P#p2.MYD
667 t1#P#p2.MYI
668 t1#P#pn.MYD
669 t1#P#pn.MYI
670 t1.frm
671 t1.par
672 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)
673 Table Create Table
674 t1 CREATE TABLE `t1` (
675 `x` int(11) DEFAULT NULL
676 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
677 PARTITION BY RANGE (`x`)
678 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
679 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
680 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE,
681 PARTITION `p2` VALUES LESS THAN (40) ENGINE = DEFAULT_ENGINE)
682 x
683 2
684 12
685 22
686 32
687 39
688 # CRASH: crash_convert_partition_10
689 t1#P#p0.MYD
690 t1#P#p0.MYI
691 t1#P#p1.MYD
692 t1#P#p1.MYI
693 t1#P#p2.MYD
694 t1#P#p2.MYI
695 t1#P#pn.MYD
696 t1#P#pn.MYI
697 t1.frm
698 t1.par
699 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)
700 Table Create Table
701 t1 CREATE TABLE `t1` (
702 `x` int(11) DEFAULT NULL
703 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
704 PARTITION BY RANGE (`x`)
705 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
706 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
707 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE,
708 PARTITION `p2` VALUES LESS THAN (40) ENGINE = DEFAULT_ENGINE)
709 x
710 2
711 12
712 22
713 32
714 39
715 # CRASH: crash_convert_partition_11
716 t1#P#p0.MYD
717 t1#P#p0.MYI
718 t1#P#p1.MYD
719 t1#P#p1.MYI
720 t1#P#p2.MYD
721 t1#P#p2.MYI
722 t1#P#pn.MYD
723 t1#P#pn.MYI
724 t1.frm
725 t1.par
726 master-bin.000001 # Query # # use `test`; ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)
727 Table Create Table
728 t1 CREATE TABLE `t1` (
729 `x` int(11) DEFAULT NULL
730 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
731 PARTITION BY RANGE (`x`)
732 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = DEFAULT_ENGINE,
733 PARTITION `p1` VALUES LESS THAN (20) ENGINE = DEFAULT_ENGINE,
734 PARTITION `pn` VALUES LESS THAN (30) ENGINE = DEFAULT_ENGINE,
735 PARTITION `p2` VALUES LESS THAN (40) ENGINE = DEFAULT_ENGINE)
736 x
737 2
738 12
739 22
740 32
741 39
742 Warnings:
743 Note 1051 Unknown table 'test.t1'