Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_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(11) NOT NULL,
24 `c2` char(10) DEFAULT NULL,
25 PRIMARY KEY (`c1`)
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
27 PARTITION BY RANGE (`c1`)
28 (PARTITION `p0` VALUES LESS THAN (100) ENGINE = ENGINE,
29 PARTITION `p1` VALUES LESS THAN (200) ENGINE = ENGINE,
30 PARTITION `p2` VALUES LESS THAN (300) ENGINE = ENGINE,
31 PARTITION `p3` VALUES LESS THAN (400) ENGINE = ENGINE,
32 PARTITION `p4` VALUES LESS THAN (500) ENGINE = ENGINE,
33 PARTITION `p5` VALUES LESS THAN MAXVALUE ENGINE = ENGINE)
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(11) NOT NULL,
48 `c2` char(10) DEFAULT NULL,
49 PRIMARY KEY (`c1`)
50 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
51 PARTITION BY RANGE (`c1`)
52 (PARTITION `p0` VALUES LESS THAN (100) ENGINE = ENGINE,
53 PARTITION `p1` VALUES LESS THAN (200) ENGINE = ENGINE,
54 PARTITION `p2` VALUES LESS THAN (300) ENGINE = ENGINE,
55 PARTITION `p3` VALUES LESS THAN (400) ENGINE = ENGINE,
56 PARTITION `p4` VALUES LESS THAN (500) ENGINE = ENGINE,
57 PARTITION `p5` VALUES LESS THAN MAXVALUE ENGINE = ENGINE)
58 DROP TABLE t1;
59 SHOW TABLES;
60 Tables_in_test