Debian Codegraph @

mysql-test/suite/parts/r/partition_debug_innodb.result

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