Debian Codegraph @

mysql-test/suite/engines/funcs/t/tc_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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
22 --replace_result $ENGINE ENGINE
23 SHOW CREATE TABLE t1;
24 --error ER_PARTITION_DOES_NOT_EXIST
25 ALTER TABLE t1 DROP PARTITION s2;
26 ALTER TABLE t1 DROP PARTITION s1;
27 SELECT * FROM t1 ORDER BY c1;
28 SHOW TABLES;
29 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
30 --replace_result $ENGINE ENGINE
31 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
32 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
33 PARTITION p0 VALUES LESS THAN (10),
34 PARTITION p1 VALUES LESS THAN (20),
35 PARTITION p2 VALUES LESS THAN (30),
36 PARTITION p3 VALUES LESS THAN MAXVALUE);
37 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
38 SELECT * FROM t1 ORDER BY c1;
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 (7));
43 --error ER_REORG_OUTSIDE_RANGE
44 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
45 PARTITION s0 VALUES LESS THAN (3),
46 PARTITION s1 VALUES LESS THAN (11));
47 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
48 PARTITION s0 VALUES LESS THAN (3),
49 PARTITION s1 VALUES LESS THAN (10));
50 SELECT * FROM t1 ORDER BY c1;
51 SHOW TABLES;
52 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
53 --replace_result $ENGINE ENGINE
54 SHOW CREATE TABLE t1;
55 --error ER_PARTITION_DOES_NOT_EXIST
56 ALTER TABLE t1 DROP PARTITION s2;
57 ALTER TABLE t1 DROP PARTITION s1;
58 SELECT * FROM t1 ORDER BY c1;
59 SHOW TABLES;
60 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
61 --replace_result $ENGINE ENGINE
62 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
63 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
64 PARTITION p0 VALUES LESS THAN (10),
65 PARTITION p1 VALUES LESS THAN (20),
66 PARTITION p2 VALUES LESS THAN (30),
67 PARTITION p3 VALUES LESS THAN MAXVALUE);
68 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
69 SELECT * FROM t1 ORDER BY c1;
70 --error ER_REORG_OUTSIDE_RANGE
71 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
72 PARTITION s0 VALUES LESS THAN (3),
73 PARTITION s1 VALUES LESS THAN (7));
74 --error ER_REORG_OUTSIDE_RANGE
75 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
76 PARTITION s0 VALUES LESS THAN (3),
77 PARTITION s1 VALUES LESS THAN (11));
78 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
79 PARTITION s0 VALUES LESS THAN (3),
80 PARTITION s1 VALUES LESS THAN (10));
81 SELECT * FROM t1 ORDER BY c1;
82 SHOW TABLES;
83 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
84 --replace_result $ENGINE ENGINE
85 SHOW CREATE TABLE t1;
86 --error ER_PARTITION_DOES_NOT_EXIST
87 ALTER TABLE t1 DROP PARTITION s2;
88 ALTER TABLE t1 DROP PARTITION s1;
89 SELECT * FROM t1 ORDER BY c1;
90 SHOW TABLES;
91 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
92 --replace_result $ENGINE ENGINE
93 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
94 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
95 PARTITION p0 VALUES LESS THAN (10),
96 PARTITION p1 VALUES LESS THAN (20),
97 PARTITION p2 VALUES LESS THAN (30),
98 PARTITION p3 VALUES LESS THAN MAXVALUE);
99 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
100 SELECT * FROM t1 ORDER BY c1;
101 --error ER_REORG_OUTSIDE_RANGE
102 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
103 PARTITION s0 VALUES LESS THAN (3),
104 PARTITION s1 VALUES LESS THAN (7));
105 --error ER_REORG_OUTSIDE_RANGE
106 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
107 PARTITION s0 VALUES LESS THAN (3),
108 PARTITION s1 VALUES LESS THAN (11));
109 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
110 PARTITION s0 VALUES LESS THAN (3),
111 PARTITION s1 VALUES LESS THAN (10));
112 SELECT * FROM t1 ORDER BY c1;
113 SHOW TABLES;
114 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
115 --replace_result $ENGINE ENGINE
116 SHOW CREATE TABLE t1;
117 --error ER_PARTITION_DOES_NOT_EXIST
118 ALTER TABLE t1 DROP PARTITION s2;
119 ALTER TABLE t1 DROP PARTITION s1;
120 SELECT * FROM t1 ORDER BY c1;
121 SHOW TABLES;
122 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
123 --replace_result $ENGINE ENGINE
124 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
125 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
126 PARTITION p0 VALUES LESS THAN (10),
127 PARTITION p1 VALUES LESS THAN (20),
128 PARTITION p2 VALUES LESS THAN (30),
129 PARTITION p3 VALUES LESS THAN MAXVALUE);
130 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
131 SELECT * FROM t1 ORDER BY c1;
132 --error ER_REORG_OUTSIDE_RANGE
133 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
134 PARTITION s0 VALUES LESS THAN (3),
135 PARTITION s1 VALUES LESS THAN (7));
136 --error ER_REORG_OUTSIDE_RANGE
137 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
138 PARTITION s0 VALUES LESS THAN (3),
139 PARTITION s1 VALUES LESS THAN (11));
140 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
141 PARTITION s0 VALUES LESS THAN (3),
142 PARTITION s1 VALUES LESS THAN (10));
143 SELECT * FROM t1 ORDER BY c1;
144 SHOW TABLES;
145 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
146 --replace_result $ENGINE ENGINE
147 SHOW CREATE TABLE t1;
148 --error ER_PARTITION_DOES_NOT_EXIST
149 ALTER TABLE t1 DROP PARTITION s2;
150 ALTER TABLE t1 DROP PARTITION s1;
151 SELECT * FROM t1 ORDER BY c1;
152 SHOW TABLES;
153 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
154 --replace_result $ENGINE ENGINE
155 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
156 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
157 PARTITION p0 VALUES LESS THAN (10),
158 PARTITION p1 VALUES LESS THAN (20),
159 PARTITION p2 VALUES LESS THAN (30),
160 PARTITION p3 VALUES LESS THAN MAXVALUE);
161 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
162 SELECT * FROM t1 ORDER BY c1;
163 --error ER_REORG_OUTSIDE_RANGE
164 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
165 PARTITION s0 VALUES LESS THAN (3),
166 PARTITION s1 VALUES LESS THAN (7));
167 --error ER_REORG_OUTSIDE_RANGE
168 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
169 PARTITION s0 VALUES LESS THAN (3),
170 PARTITION s1 VALUES LESS THAN (11));
171 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (
172 PARTITION s0 VALUES LESS THAN (3),
173 PARTITION s1 VALUES LESS THAN (10));
174 SELECT * FROM t1 ORDER BY c1;
175 SHOW TABLES;
176 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
177 --replace_result $ENGINE ENGINE
178 SHOW CREATE TABLE t1;
179 --error ER_PARTITION_DOES_NOT_EXIST
180 ALTER TABLE t1 DROP PARTITION s2;
181 ALTER TABLE t1 DROP PARTITION s1;
182 SELECT * FROM t1 ORDER BY c1;
183 SHOW TABLES;
184 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
185 --replace_result $ENGINE ENGINE
186 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
187