Debian Codegraph @

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