Debian Codegraph @

mysql-test/suite/parts/r/partition_check.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 CHECK PARTITION p1,p2;
35 Table Op Msg_type Msg_text
36 test.t1 check status OK
37 SELECT * FROM t1 ORDER BY c1;
38 c1 c2
39 0 abc
40 100 abc
41 200 abc
42 300 abc
43 400 abc
44 SHOW CREATE TABLE t1;
45 Table Create Table
46 t1 CREATE TABLE `t1` (
47 `c1` int NOT NULL,
48 `c2` char(10) DEFAULT NULL,
49 PRIMARY KEY (`c1`)
50 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 /*!50100 PARTITION BY RANGE (`c1`)
52 (PARTITION p0 VALUES LESS THAN (100) ENGINE = InnoDB,
53 PARTITION p1 VALUES LESS THAN (200) ENGINE = InnoDB,
54 PARTITION p2 VALUES LESS THAN (300) ENGINE = InnoDB,
55 PARTITION p3 VALUES LESS THAN (400) ENGINE = InnoDB,
56 PARTITION p4 VALUES LESS THAN (500) ENGINE = InnoDB,
57 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
58 DROP TABLE t1;
59 SHOW TABLES;
60 Tables_in_test