Debian Codegraph @

mysql-test/suite/parts/r/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 DEFAULT NULL,
16 `c2` int DEFAULT NULL
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
18 /*!50100 PARTITION BY RANGE (`c1`)
19 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = InnoDB,
20 PARTITION p1 VALUES LESS THAN (1995) ENGINE = InnoDB,
21 PARTITION p2 VALUES LESS THAN (1999) ENGINE = InnoDB,
22 PARTITION p3 VALUES LESS THAN (2002) ENGINE = InnoDB,
23 PARTITION p4 VALUES LESS THAN (2006) ENGINE = InnoDB,
24 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
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 DEFAULT NULL,
42 `c2` int DEFAULT NULL
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
44 /*!50100 PARTITION BY RANGE (`c1`)
45 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = InnoDB,
46 PARTITION p1 VALUES LESS THAN (1995) ENGINE = InnoDB,
47 PARTITION p2 VALUES LESS THAN (1999) ENGINE = InnoDB,
48 PARTITION p3 VALUES LESS THAN (2002) ENGINE = InnoDB,
49 PARTITION p4 VALUES LESS THAN (2006) ENGINE = InnoDB,
50 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
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 DEFAULT NULL,
68 `c2` int DEFAULT NULL
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
70 /*!50100 PARTITION BY RANGE (`c1`)
71 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = InnoDB,
72 PARTITION p1 VALUES LESS THAN (1995) ENGINE = InnoDB,
73 PARTITION p2 VALUES LESS THAN (1999) ENGINE = InnoDB,
74 PARTITION p3 VALUES LESS THAN (2002) ENGINE = InnoDB,
75 PARTITION p4 VALUES LESS THAN (2006) ENGINE = InnoDB,
76 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
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 DEFAULT NULL,
94 `c2` int DEFAULT NULL
95 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
96 /*!50100 PARTITION BY RANGE (`c1`)
97 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = InnoDB,
98 PARTITION p1 VALUES LESS THAN (1995) ENGINE = InnoDB,
99 PARTITION p2 VALUES LESS THAN (1999) ENGINE = InnoDB,
100 PARTITION p3 VALUES LESS THAN (2002) ENGINE = InnoDB,
101 PARTITION p4 VALUES LESS THAN (2006) ENGINE = InnoDB,
102 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
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 DEFAULT NULL,
120 `c2` int DEFAULT NULL
121 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
122 /*!50100 PARTITION BY RANGE (`c1`)
123 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = InnoDB,
124 PARTITION p1 VALUES LESS THAN (1995) ENGINE = InnoDB,
125 PARTITION p2 VALUES LESS THAN (1999) ENGINE = InnoDB,
126 PARTITION p3 VALUES LESS THAN (2002) ENGINE = InnoDB,
127 PARTITION p4 VALUES LESS THAN (2006) ENGINE = InnoDB,
128 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
129 DROP TABLE t1;
130 SHOW TABLES;
131 Tables_in_test