Debian Codegraph @

mysql-test/suite/parts/r/alter_table,list.rdiff

raw
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