Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_partition_value.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 ( c1 SMALLINT, c2 INT) PARTITION BY RANGE (c1) (
3 PARTITION p0 VALUES LESS THAN (1991),
4 PARTITION p1 VALUES LESS THAN (1995),
5 PARTITION p2 VALUES LESS THAN (1999),
6 PARTITION p3 VALUES LESS THAN (2002),
7 PARTITION p4 VALUES LESS THAN (2006),
8 PARTITION p5 VALUES LESS THAN MAXVALUE);
9 SHOW TABLES;
10 Tables_in_test
11 t1
12 SHOW CREATE TABLE t1;
13 Table Create Table
14 t1 CREATE TABLE `t1` (
15 `c1` smallint(6) DEFAULT NULL,
16 `c2` int(11) DEFAULT NULL
17 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
18 PARTITION BY RANGE (`c1`)
19 (PARTITION `p0` VALUES LESS THAN (1991) ENGINE = ENGINE,
20 PARTITION `p1` VALUES LESS THAN (1995) ENGINE = ENGINE,
21 PARTITION `p2` VALUES LESS THAN (1999) ENGINE = ENGINE,
22 PARTITION `p3` VALUES LESS THAN (2002) ENGINE = ENGINE,
23 PARTITION `p4` VALUES LESS THAN (2006) ENGINE = ENGINE,
24 PARTITION `p5` VALUES LESS THAN MAXVALUE ENGINE = ENGINE)
25 DROP TABLE t1;
26 SHOW TABLES;
27 Tables_in_test
28 CREATE TABLE t1 ( c1 MEDIUMINT, c2 INT) PARTITION BY RANGE (c1) (
29 PARTITION p0 VALUES LESS THAN (1991),
30 PARTITION p1 VALUES LESS THAN (1995),
31 PARTITION p2 VALUES LESS THAN (1999),
32 PARTITION p3 VALUES LESS THAN (2002),
33 PARTITION p4 VALUES LESS THAN (2006),
34 PARTITION p5 VALUES LESS THAN MAXVALUE);
35 SHOW TABLES;
36 Tables_in_test
37 t1
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `c1` mediumint(9) DEFAULT NULL,
42 `c2` int(11) DEFAULT NULL
43 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
44 PARTITION BY RANGE (`c1`)
45 (PARTITION `p0` VALUES LESS THAN (1991) ENGINE = ENGINE,
46 PARTITION `p1` VALUES LESS THAN (1995) ENGINE = ENGINE,
47 PARTITION `p2` VALUES LESS THAN (1999) ENGINE = ENGINE,
48 PARTITION `p3` VALUES LESS THAN (2002) ENGINE = ENGINE,
49 PARTITION `p4` VALUES LESS THAN (2006) ENGINE = ENGINE,
50 PARTITION `p5` VALUES LESS THAN MAXVALUE ENGINE = ENGINE)
51 DROP TABLE t1;
52 SHOW TABLES;
53 Tables_in_test
54 CREATE TABLE t1 ( c1 INT, c2 INT) PARTITION BY RANGE (c1) (
55 PARTITION p0 VALUES LESS THAN (1991),
56 PARTITION p1 VALUES LESS THAN (1995),
57 PARTITION p2 VALUES LESS THAN (1999),
58 PARTITION p3 VALUES LESS THAN (2002),
59 PARTITION p4 VALUES LESS THAN (2006),
60 PARTITION p5 VALUES LESS THAN MAXVALUE);
61 SHOW TABLES;
62 Tables_in_test
63 t1
64 SHOW CREATE TABLE t1;
65 Table Create Table
66 t1 CREATE TABLE `t1` (
67 `c1` int(11) DEFAULT NULL,
68 `c2` int(11) DEFAULT NULL
69 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
70 PARTITION BY RANGE (`c1`)
71 (PARTITION `p0` VALUES LESS THAN (1991) ENGINE = ENGINE,
72 PARTITION `p1` VALUES LESS THAN (1995) ENGINE = ENGINE,
73 PARTITION `p2` VALUES LESS THAN (1999) ENGINE = ENGINE,
74 PARTITION `p3` VALUES LESS THAN (2002) ENGINE = ENGINE,
75 PARTITION `p4` VALUES LESS THAN (2006) ENGINE = ENGINE,
76 PARTITION `p5` VALUES LESS THAN MAXVALUE ENGINE = ENGINE)
77 DROP TABLE t1;
78 SHOW TABLES;
79 Tables_in_test
80 CREATE TABLE t1 ( c1 INTEGER, c2 INT) PARTITION BY RANGE (c1) (
81 PARTITION p0 VALUES LESS THAN (1991),
82 PARTITION p1 VALUES LESS THAN (1995),
83 PARTITION p2 VALUES LESS THAN (1999),
84 PARTITION p3 VALUES LESS THAN (2002),
85 PARTITION p4 VALUES LESS THAN (2006),
86 PARTITION p5 VALUES LESS THAN MAXVALUE);
87 SHOW TABLES;
88 Tables_in_test
89 t1
90 SHOW CREATE TABLE t1;
91 Table Create Table
92 t1 CREATE TABLE `t1` (
93 `c1` int(11) DEFAULT NULL,
94 `c2` int(11) DEFAULT NULL
95 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
96 PARTITION BY RANGE (`c1`)
97 (PARTITION `p0` VALUES LESS THAN (1991) ENGINE = ENGINE,
98 PARTITION `p1` VALUES LESS THAN (1995) ENGINE = ENGINE,
99 PARTITION `p2` VALUES LESS THAN (1999) ENGINE = ENGINE,
100 PARTITION `p3` VALUES LESS THAN (2002) ENGINE = ENGINE,
101 PARTITION `p4` VALUES LESS THAN (2006) ENGINE = ENGINE,
102 PARTITION `p5` VALUES LESS THAN MAXVALUE ENGINE = ENGINE)
103 DROP TABLE t1;
104 SHOW TABLES;
105 Tables_in_test
106 CREATE TABLE t1 ( c1 BIGINT, c2 INT) PARTITION BY RANGE (c1) (
107 PARTITION p0 VALUES LESS THAN (1991),
108 PARTITION p1 VALUES LESS THAN (1995),
109 PARTITION p2 VALUES LESS THAN (1999),
110 PARTITION p3 VALUES LESS THAN (2002),
111 PARTITION p4 VALUES LESS THAN (2006),
112 PARTITION p5 VALUES LESS THAN MAXVALUE);
113 SHOW TABLES;
114 Tables_in_test
115 t1
116 SHOW CREATE TABLE t1;
117 Table Create Table
118 t1 CREATE TABLE `t1` (
119 `c1` bigint(20) DEFAULT NULL,
120 `c2` int(11) DEFAULT NULL
121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
122 PARTITION BY RANGE (`c1`)
123 (PARTITION `p0` VALUES LESS THAN (1991) ENGINE = ENGINE,
124 PARTITION `p1` VALUES LESS THAN (1995) ENGINE = ENGINE,
125 PARTITION `p2` VALUES LESS THAN (1999) ENGINE = ENGINE,
126 PARTITION `p3` VALUES LESS THAN (2002) ENGINE = ENGINE,
127 PARTITION `p4` VALUES LESS THAN (2006) ENGINE = ENGINE,
128 PARTITION `p5` VALUES LESS THAN MAXVALUE ENGINE = ENGINE)
129 DROP TABLE t1;
130 SHOW TABLES;
131 Tables_in_test