Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 ( c1 INTEGER NOT NULL PRIMARY KEY, c2 CHAR(10)) PARTITION BY RANGE (c1) (
3 PARTITION p0 VALUES LESS THAN (100),
4 PARTITION p1 VALUES LESS THAN (200),
5 PARTITION p2 VALUES LESS THAN (300),
6 PARTITION p3 VALUES LESS THAN (400),
7 PARTITION p4 VALUES LESS THAN (500),
8 PARTITION p5 VALUES LESS THAN MAXVALUE);
9 SHOW TABLES;
10 Tables_in_test
11 t1
12 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
13 SELECT * FROM t1 ORDER BY c1;
14 c1 c2
15 0 abc
16 100 abc
17 200 abc
18 300 abc
19 400 abc
20 SHOW CREATE TABLE t1;
21 Table Create Table
22 t1 CREATE TABLE `t1` (
23 `c1` int NOT NULL,
24 `c2` char(10) DEFAULT NULL,
25 PRIMARY KEY (`c1`)
26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 /*!50100 PARTITION BY RANGE (`c1`)
28 (PARTITION p0 VALUES LESS THAN (100) ENGINE = InnoDB,
29 PARTITION p1 VALUES LESS THAN (200) ENGINE = InnoDB,
30 PARTITION p2 VALUES LESS THAN (300) ENGINE = InnoDB,
31 PARTITION p3 VALUES LESS THAN (400) ENGINE = InnoDB,
32 PARTITION p4 VALUES LESS THAN (500) ENGINE = InnoDB,
33 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
34 ALTER TABLE t1 REPAIR PARTITION p1,p2;
35 SELECT * FROM t1 ORDER BY c1;
36 c1 c2
37 0 abc
38 100 abc
39 200 abc
40 300 abc
41 400 abc
42 SHOW CREATE TABLE t1;
43 Table Create Table
44 t1 CREATE TABLE `t1` (
45 `c1` int NOT NULL,
46 `c2` char(10) DEFAULT NULL,
47 PRIMARY KEY (`c1`)
48 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
49 /*!50100 PARTITION BY RANGE (`c1`)
50 (PARTITION p0 VALUES LESS THAN (100) ENGINE = InnoDB,
51 PARTITION p1 VALUES LESS THAN (200) ENGINE = InnoDB,
52 PARTITION p2 VALUES LESS THAN (300) ENGINE = InnoDB,
53 PARTITION p3 VALUES LESS THAN (400) ENGINE = InnoDB,
54 PARTITION p4 VALUES LESS THAN (500) ENGINE = InnoDB,
55 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
56 DROP TABLE t1;
57 SHOW TABLES;
58 Tables_in_test