Debian Codegraph @

mysql-test/suite/parts/t/partition_reorg_merge.test

raw
1 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
2 PARTITION p0 VALUES LESS THAN (10),
3 PARTITION p1 VALUES LESS THAN (20),
4 PARTITION p2 VALUES LESS THAN (30),
5 PARTITION p3 VALUES LESS THAN MAXVALUE);
6 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
7 SELECT * FROM t1 ORDER BY c1;
8 --error ER_REORG_OUTSIDE_RANGE
9 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
10 PARTITION m0 VALUES LESS THAN (29));
11 --error ER_REORG_OUTSIDE_RANGE
12 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
13 PARTITION m0 VALUES LESS THAN (31));
14 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
15 PARTITION m0 VALUES LESS THAN (30));
16 SELECT * FROM t1 ORDER BY c1;
17 SHOW TABLES;
18 SHOW CREATE TABLE t1;
19 --error ER_DROP_PARTITION_NON_EXISTENT
20 ALTER TABLE t1 DROP PARTITION m1;
21 ALTER TABLE t1 DROP PARTITION m0;
22 SELECT * FROM t1 ORDER BY c1;
23 SHOW TABLES;
24 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
25 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
26 PARTITION p0 VALUES LESS THAN (10),
27 PARTITION p1 VALUES LESS THAN (20),
28 PARTITION p2 VALUES LESS THAN (30),
29 PARTITION p3 VALUES LESS THAN MAXVALUE);
30 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
31 SELECT * FROM t1 ORDER BY c1;
32 --error ER_REORG_OUTSIDE_RANGE
33 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
34 PARTITION m0 VALUES LESS THAN (29));
35 --error ER_REORG_OUTSIDE_RANGE
36 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
37 PARTITION m0 VALUES LESS THAN (31));
38 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
39 PARTITION m0 VALUES LESS THAN (30));
40 SELECT * FROM t1 ORDER BY c1;
41 SHOW TABLES;
42 SHOW CREATE TABLE t1;
43 --error ER_DROP_PARTITION_NON_EXISTENT
44 ALTER TABLE t1 DROP PARTITION m1;
45 ALTER TABLE t1 DROP PARTITION m0;
46 SELECT * FROM t1 ORDER BY c1;
47 SHOW TABLES;
48 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
49 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
50 PARTITION p0 VALUES LESS THAN (10),
51 PARTITION p1 VALUES LESS THAN (20),
52 PARTITION p2 VALUES LESS THAN (30),
53 PARTITION p3 VALUES LESS THAN MAXVALUE);
54 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
55 SELECT * FROM t1 ORDER BY c1;
56 --error ER_REORG_OUTSIDE_RANGE
57 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
58 PARTITION m0 VALUES LESS THAN (29));
59 --error ER_REORG_OUTSIDE_RANGE
60 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
61 PARTITION m0 VALUES LESS THAN (31));
62 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
63 PARTITION m0 VALUES LESS THAN (30));
64 SELECT * FROM t1 ORDER BY c1;
65 SHOW TABLES;
66 SHOW CREATE TABLE t1;
67 --error ER_DROP_PARTITION_NON_EXISTENT
68 ALTER TABLE t1 DROP PARTITION m1;
69 ALTER TABLE t1 DROP PARTITION m0;
70 SELECT * FROM t1 ORDER BY c1;
71 SHOW TABLES;
72 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
73 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
74 PARTITION p0 VALUES LESS THAN (10),
75 PARTITION p1 VALUES LESS THAN (20),
76 PARTITION p2 VALUES LESS THAN (30),
77 PARTITION p3 VALUES LESS THAN MAXVALUE);
78 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
79 SELECT * FROM t1 ORDER BY c1;
80 --error ER_REORG_OUTSIDE_RANGE
81 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
82 PARTITION m0 VALUES LESS THAN (29));
83 --error ER_REORG_OUTSIDE_RANGE
84 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
85 PARTITION m0 VALUES LESS THAN (31));
86 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
87 PARTITION m0 VALUES LESS THAN (30));
88 SELECT * FROM t1 ORDER BY c1;
89 SHOW TABLES;
90 SHOW CREATE TABLE t1;
91 --error ER_DROP_PARTITION_NON_EXISTENT
92 ALTER TABLE t1 DROP PARTITION m1;
93 ALTER TABLE t1 DROP PARTITION m0;
94 SELECT * FROM t1 ORDER BY c1;
95 SHOW TABLES;
96 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
97 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
98 PARTITION p0 VALUES LESS THAN (10),
99 PARTITION p1 VALUES LESS THAN (20),
100 PARTITION p2 VALUES LESS THAN (30),
101 PARTITION p3 VALUES LESS THAN MAXVALUE);
102 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
103 SELECT * FROM t1 ORDER BY c1;
104 --error ER_REORG_OUTSIDE_RANGE
105 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
106 PARTITION m0 VALUES LESS THAN (29));
107 --error ER_REORG_OUTSIDE_RANGE
108 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
109 PARTITION m0 VALUES LESS THAN (31));
110 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
111 PARTITION m0 VALUES LESS THAN (30));
112 SELECT * FROM t1 ORDER BY c1;
113 SHOW TABLES;
114 SHOW CREATE TABLE t1;
115 --error ER_DROP_PARTITION_NON_EXISTENT
116 ALTER TABLE t1 DROP PARTITION m1;
117 ALTER TABLE t1 DROP PARTITION m0;
118 SELECT * FROM t1 ORDER BY c1;
119 SHOW TABLES;
120 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
121 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
122 PARTITION p0 VALUES LESS THAN (10),
123 PARTITION p1 VALUES LESS THAN (20),
124 PARTITION p2 VALUES LESS THAN (30),
125 PARTITION p3 VALUES LESS THAN MAXVALUE);
126 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
127 SELECT * FROM t1 ORDER BY c1;
128 --error ER_REORG_OUTSIDE_RANGE
129 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
130 PARTITION m0 VALUES LESS THAN (29));
131 --error ER_REORG_OUTSIDE_RANGE
132 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
133 PARTITION m0 VALUES LESS THAN (31));
134 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (
135 PARTITION m0 VALUES LESS THAN (30));
136 SELECT * FROM t1 ORDER BY c1;
137 SHOW TABLES;
138 SHOW CREATE TABLE t1;
139 --error ER_DROP_PARTITION_NON_EXISTENT
140 ALTER TABLE t1 DROP PARTITION m1;
141 ALTER TABLE t1 DROP PARTITION m0;
142 SELECT * FROM t1 ORDER BY c1;
143 SHOW TABLES;
144 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;