| 1 |
@@ -142,13 +142,13 @@ |
| 2 |
partition pn values less than maxvalue); |
| 3 |
ERROR HY000: Partitioned tables do not support CREATE TEMPORARY TABLE |
| 4 |
create or replace table t1 (x int) |
| 5 |
-partition by range(x) ( |
| 6 |
-partition p1 values less than (10), |
| 7 |
-partition p2 values less than (20), |
| 8 |
-partition p3 values less than (30), |
| 9 |
-partition p4 values less than (40), |
| 10 |
-partition p5 values less than (50), |
| 11 |
-partition pn values less than maxvalue); |
| 12 |
+partition by list(x) ( |
| 13 |
+partition p1 values in (2, 3, 4), |
| 14 |
+partition p2 values in (12, 13, 14), |
| 15 |
+partition p3 values in (22, 23, 24), |
| 16 |
+partition p4 values in (32, 33, 34), |
| 17 |
+partition p5 values in (42, 43, 44), |
| 18 |
+partition pn values in (52, 53, 54)); |
| 19 |
insert into t1 values (2), (12), (22), (32), (42), (52); |
| 20 |
create or replace table tp2 (y int); |
| 21 |
insert tp2 values (88); |
| 22 |
@@ -188,12 +188,12 @@ |
| 23 |
t1 CREATE TABLE `t1` ( |
| 24 |
`x` int(11) DEFAULT NULL |
| 25 |
) ENGINE=X DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci |
| 26 |
- PARTITION BY RANGE (`x`) |
| 27 |
-(PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, |
| 28 |
- PARTITION `p3` VALUES LESS THAN (30) ENGINE = X, |
| 29 |
- PARTITION `p4` VALUES LESS THAN (40) ENGINE = X, |
| 30 |
- PARTITION `p5` VALUES LESS THAN (50) ENGINE = X, |
| 31 |
- PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = X) |
| 32 |
+ PARTITION BY LIST (`x`) |
| 33 |
+(PARTITION `p1` VALUES IN (2,3,4) ENGINE = X, |
| 34 |
+ PARTITION `p3` VALUES IN (22,23,24) ENGINE = X, |
| 35 |
+ PARTITION `p4` VALUES IN (32,33,34) ENGINE = X, |
| 36 |
+ PARTITION `p5` VALUES IN (42,43,44) ENGINE = X, |
| 37 |
+ PARTITION `pn` VALUES IN (52,53,54) ENGINE = X) |
| 38 |
select * from t1 order by x; |
| 39 |
x |
| 40 |
2 |
| 41 |
@@ -218,11 +218,11 @@ |
| 42 |
t1 CREATE TABLE `t1` ( |
| 43 |
`x` int(11) DEFAULT NULL |
| 44 |
) ENGINE=X DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci |
| 45 |
- PARTITION BY RANGE (`x`) |
| 46 |
-(PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, |
| 47 |
- PARTITION `p4` VALUES LESS THAN (40) ENGINE = X, |
| 48 |
- PARTITION `p5` VALUES LESS THAN (50) ENGINE = X, |
| 49 |
- PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = X) |
| 50 |
+ PARTITION BY LIST (`x`) |
| 51 |
+(PARTITION `p1` VALUES IN (2,3,4) ENGINE = X, |
| 52 |
+ PARTITION `p4` VALUES IN (32,33,34) ENGINE = X, |
| 53 |
+ PARTITION `p5` VALUES IN (42,43,44) ENGINE = X, |
| 54 |
+ PARTITION `pn` VALUES IN (52,53,54) ENGINE = X) |
| 55 |
select * from t1 order by x; |
| 56 |
x |
| 57 |
2 |
| 58 |
@@ -248,10 +248,10 @@ |
| 59 |
t1 CREATE TABLE `t1` ( |
| 60 |
`x` int(11) DEFAULT NULL |
| 61 |
) ENGINE=X DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci |
| 62 |
- PARTITION BY RANGE (`x`) |
| 63 |
-(PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, |
| 64 |
- PARTITION `p5` VALUES LESS THAN (50) ENGINE = X, |
| 65 |
- PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = X) |
| 66 |
+ PARTITION BY LIST (`x`) |
| 67 |
+(PARTITION `p1` VALUES IN (2,3,4) ENGINE = X, |
| 68 |
+ PARTITION `p5` VALUES IN (42,43,44) ENGINE = X, |
| 69 |
+ PARTITION `pn` VALUES IN (52,53,54) ENGINE = X) |
| 70 |
select * from t1 order by x; |
| 71 |
x |
| 72 |
2 |
| 73 |
@@ -273,9 +273,9 @@ |
| 74 |
t1 CREATE TABLE `t1` ( |
| 75 |
`x` int(11) DEFAULT NULL |
| 76 |
) ENGINE=X DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci |
| 77 |
- PARTITION BY RANGE (`x`) |
| 78 |
-(PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, |
| 79 |
- PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = X) |
| 80 |
+ PARTITION BY LIST (`x`) |
| 81 |
+(PARTITION `p1` VALUES IN (2,3,4) ENGINE = X, |
| 82 |
+ PARTITION `pn` VALUES IN (52,53,54) ENGINE = X) |
| 83 |
select * from t1 order by x; |
| 84 |
x |
| 85 |
2 |