Debian Codegraph @

mysql-test/suite/mariabackup/partition_partial.result

raw
1 CREATE TABLE t1(i INT) ENGINE INNODB
2 PARTITION BY RANGE (i)
3 (PARTITION p1 VALUES LESS THAN (100),
4 PARTITION p2 VALUES LESS THAN (200),
5 PARTITION p3 VALUES LESS THAN (300),
6 PARTITION p4 VALUES LESS THAN (400));
7 INSERT INTO t1 VALUES (1), (101), (201), (301);
8 # xtrabackup backup
9 INSERT INTO t1 VALUES (1), (101), (201), (301);
10 # xtrabackup prepare
11 CREATE TABLE t1_placeholder (i INT) ENGINE INNODB;
12 ALTER TABLE t1_placeholder DISCARD TABLESPACE;
13 ALTER TABLE t1_placeholder IMPORT TABLESPACE;
14 ALTER TABLE t1 EXCHANGE PARTITION p4 WITH TABLE t1_placeholder;
15 ALTER TABLE t1_placeholder DISCARD TABLESPACE;
16 ALTER TABLE t1_placeholder IMPORT TABLESPACE;
17 ALTER TABLE t1 EXCHANGE PARTITION p3 WITH TABLE t1_placeholder;
18 ALTER TABLE t1_placeholder DISCARD TABLESPACE;
19 ALTER TABLE t1_placeholder IMPORT TABLESPACE;
20 ALTER TABLE t1 EXCHANGE PARTITION p2 WITH TABLE t1_placeholder;
21 ALTER TABLE t1_placeholder DISCARD TABLESPACE;
22 ALTER TABLE t1_placeholder IMPORT TABLESPACE;
23 ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t1_placeholder;
24 SELECT * FROM t1;
25 i
26 1
27 101
28 201
29 301
30 DROP TABLE t1;
31 DROP TABLE t1_placeholder;