Debian Codegraph @

mysql-test/suite/parts/r/partition_reorganize_innodb.result

raw
1 SET default_storage_engine=InnoDB;
2 SET SESSION innodb_strict_mode = ON;
3 SET GLOBAL innodb_file_per_table=ON;
4 #
5 # CREATE a table with SUBPARTITIONS
6 #
7 CREATE TABLE emp (
8 id INT NOT NULL,
9 store_name VARCHAR(30),
10 parts VARCHAR(30),
11 store_id INT
12 ) engine InnoDB
13 PARTITION BY RANGE(store_id) SUBPARTITION BY HASH(store_id)
14 (
15 PARTITION northeast VALUES LESS THAN (50)
16 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast'
17 (SUBPARTITION ne0, SUBPARTITION ne1),
18 PARTITION southwest VALUES LESS THAN (100)
19 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest'
20 (SUBPARTITION sw2, SUBPARTITION sw3)
21 );
22 INSERT INTO emp values(1,'Oracle','NUT',10);
23 INSERT INTO emp values(2,'SAP','BOLT',40);
24 INSERT INTO emp values(3,'IBM','NAIL',60);
25 INSERT INTO emp values(4,'SUN','SCREW',90);
26 SELECT * FROM emp;
27 id store_name parts store_id
28 1 Oracle NUT 10
29 2 SAP BOLT 40
30 3 IBM NAIL 60
31 4 SUN SCREW 90
32 SHOW CREATE TABLE emp;
33 Table Create Table
34 emp CREATE TABLE `emp` (
35 `id` int NOT NULL,
36 `store_name` varchar(30) DEFAULT NULL,
37 `parts` varchar(30) DEFAULT NULL,
38 `store_id` int DEFAULT NULL
39 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
40 /*!50100 PARTITION BY RANGE (`store_id`)
41 SUBPARTITION BY HASH (`store_id`)
42 (PARTITION northeast VALUES LESS THAN (50)
43 (SUBPARTITION ne0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast/' ENGINE = InnoDB,
44 SUBPARTITION ne1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast/' ENGINE = InnoDB),
45 PARTITION southwest VALUES LESS THAN (100)
46 (SUBPARTITION sw2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest/' ENGINE = InnoDB,
47 SUBPARTITION sw3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest/' ENGINE = InnoDB)) */
48 === information_schema.innodb_tables and innodb_tablespaces ===
49 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
50 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
51 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
52 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
53 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
54 test/emp#p#northeast#sp#ne0 test/emp#p#northeast#sp#ne0 97 7 Dynamic 0 Single
55 test/emp#p#northeast#sp#ne1 test/emp#p#northeast#sp#ne1 97 7 Dynamic 0 Single
56 test/emp#p#southwest#sp#sw2 test/emp#p#southwest#sp#sw2 97 7 Dynamic 0 Single
57 test/emp#p#southwest#sp#sw3 test/emp#p#southwest#sp#sw3 97 7 Dynamic 0 Single
58 === information_schema.innodb_tablespaces and innodb_datafiles ===
59 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
60 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
61 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
62 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
63 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
64 test/emp#p#northeast#sp#ne0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_northeast/test/emp#p#northeast#sp#ne0.ibd
65 test/emp#p#northeast#sp#ne1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_northeast/test/emp#p#northeast#sp#ne1.ibd
66 test/emp#p#southwest#sp#sw2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_southwest/test/emp#p#southwest#sp#sw2.ibd
67 test/emp#p#southwest#sp#sw3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_southwest/test/emp#p#southwest#sp#sw3.ibd
68 === information_schema.files ===
69 Space_Name File_Type Engine Status Tablespace_Name Path
70 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
71 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
72 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
73 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
74 test/emp#p#northeast#sp#ne0 TABLESPACE InnoDB NORMAL test/emp#p#northeast#sp#ne0 MYSQL_TMP_DIR/alt_dir_northeast/test/emp#p#northeast#sp#ne0.ibd
75 test/emp#p#northeast#sp#ne1 TABLESPACE InnoDB NORMAL test/emp#p#northeast#sp#ne1 MYSQL_TMP_DIR/alt_dir_northeast/test/emp#p#northeast#sp#ne1.ibd
76 test/emp#p#southwest#sp#sw2 TABLESPACE InnoDB NORMAL test/emp#p#southwest#sp#sw2 MYSQL_TMP_DIR/alt_dir_southwest/test/emp#p#southwest#sp#sw2.ibd
77 test/emp#p#southwest#sp#sw3 TABLESPACE InnoDB NORMAL test/emp#p#southwest#sp#sw3 MYSQL_TMP_DIR/alt_dir_southwest/test/emp#p#southwest#sp#sw3.ibd
78 ---- MYSQLD_DATADIR/test
79 ---- MYSQL_TMP_DIR/alt_dir_northeast/test
80 emp#p#northeast#sp#ne0.ibd
81 emp#p#northeast#sp#ne1.ibd
82 ---- MYSQL_TMP_DIR/alt_dir_southwest/test
83 emp#p#southwest#sp#sw2.ibd
84 emp#p#southwest#sp#sw3.ibd
85 #
86 # REORGANIZE the PARTITIONS and SUBPARTITIONS
87 #
88 ALTER TABLE emp REORGANIZE PARTITION northeast INTO
89 (
90 PARTITION east VALUES LESS THAN (25)
91 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east'
92 (SUBPARTITION e0, SUBPARTITION e1),
93 PARTITION north VALUES LESS THAN (50)
94 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north'
95 (SUBPARTITION n0, SUBPARTITION n1)
96 );
97 ALTER TABLE emp REORGANIZE PARTITION southwest INTO
98 (
99 PARTITION west VALUES LESS THAN (75)
100 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west'
101 (SUBPARTITION w0, SUBPARTITION w1),
102 PARTITION south VALUES LESS THAN (100)
103 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south'
104 (SUBPARTITION s0, SUBPARTITION s1)
105 );
106 SELECT * FROM emp;
107 id store_name parts store_id
108 1 Oracle NUT 10
109 2 SAP BOLT 40
110 3 IBM NAIL 60
111 4 SUN SCREW 90
112 SHOW CREATE TABLE emp;
113 Table Create Table
114 emp CREATE TABLE `emp` (
115 `id` int NOT NULL,
116 `store_name` varchar(30) DEFAULT NULL,
117 `parts` varchar(30) DEFAULT NULL,
118 `store_id` int DEFAULT NULL
119 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
120 /*!50100 PARTITION BY RANGE (`store_id`)
121 SUBPARTITION BY HASH (`store_id`)
122 (PARTITION east VALUES LESS THAN (25)
123 (SUBPARTITION e0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east' ENGINE = InnoDB,
124 SUBPARTITION e1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east' ENGINE = InnoDB),
125 PARTITION north VALUES LESS THAN (50)
126 (SUBPARTITION n0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north' ENGINE = InnoDB,
127 SUBPARTITION n1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north' ENGINE = InnoDB),
128 PARTITION west VALUES LESS THAN (75)
129 (SUBPARTITION w0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west' ENGINE = InnoDB,
130 SUBPARTITION w1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west' ENGINE = InnoDB),
131 PARTITION south VALUES LESS THAN (100)
132 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south' ENGINE = InnoDB,
133 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south' ENGINE = InnoDB)) */
134 === information_schema.innodb_tables and innodb_tablespaces ===
135 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
136 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
137 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
138 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
139 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
140 test/emp#p#east#sp#e0 test/emp#p#east#sp#e0 97 7 Dynamic 0 Single
141 test/emp#p#east#sp#e1 test/emp#p#east#sp#e1 97 7 Dynamic 0 Single
142 test/emp#p#north#sp#n0 test/emp#p#north#sp#n0 97 7 Dynamic 0 Single
143 test/emp#p#north#sp#n1 test/emp#p#north#sp#n1 97 7 Dynamic 0 Single
144 test/emp#p#south#sp#s0 test/emp#p#south#sp#s0 97 7 Dynamic 0 Single
145 test/emp#p#south#sp#s1 test/emp#p#south#sp#s1 97 7 Dynamic 0 Single
146 test/emp#p#west#sp#w0 test/emp#p#west#sp#w0 97 7 Dynamic 0 Single
147 test/emp#p#west#sp#w1 test/emp#p#west#sp#w1 97 7 Dynamic 0 Single
148 === information_schema.innodb_tablespaces and innodb_datafiles ===
149 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
150 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
151 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
152 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
153 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
154 test/emp#p#east#sp#e0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_east/test/emp#p#east#sp#e0.ibd
155 test/emp#p#east#sp#e1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_east/test/emp#p#east#sp#e1.ibd
156 test/emp#p#north#sp#n0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_north/test/emp#p#north#sp#n0.ibd
157 test/emp#p#north#sp#n1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_north/test/emp#p#north#sp#n1.ibd
158 test/emp#p#south#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_south/test/emp#p#south#sp#s0.ibd
159 test/emp#p#south#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_south/test/emp#p#south#sp#s1.ibd
160 test/emp#p#west#sp#w0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_west/test/emp#p#west#sp#w0.ibd
161 test/emp#p#west#sp#w1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_west/test/emp#p#west#sp#w1.ibd
162 === information_schema.files ===
163 Space_Name File_Type Engine Status Tablespace_Name Path
164 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
165 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
166 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
167 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
168 test/emp#p#east#sp#e0 TABLESPACE InnoDB NORMAL test/emp#p#east#sp#e0 MYSQL_TMP_DIR/alt_dir_east/test/emp#p#east#sp#e0.ibd
169 test/emp#p#east#sp#e1 TABLESPACE InnoDB NORMAL test/emp#p#east#sp#e1 MYSQL_TMP_DIR/alt_dir_east/test/emp#p#east#sp#e1.ibd
170 test/emp#p#north#sp#n0 TABLESPACE InnoDB NORMAL test/emp#p#north#sp#n0 MYSQL_TMP_DIR/alt_dir_north/test/emp#p#north#sp#n0.ibd
171 test/emp#p#north#sp#n1 TABLESPACE InnoDB NORMAL test/emp#p#north#sp#n1 MYSQL_TMP_DIR/alt_dir_north/test/emp#p#north#sp#n1.ibd
172 test/emp#p#south#sp#s0 TABLESPACE InnoDB NORMAL test/emp#p#south#sp#s0 MYSQL_TMP_DIR/alt_dir_south/test/emp#p#south#sp#s0.ibd
173 test/emp#p#south#sp#s1 TABLESPACE InnoDB NORMAL test/emp#p#south#sp#s1 MYSQL_TMP_DIR/alt_dir_south/test/emp#p#south#sp#s1.ibd
174 test/emp#p#west#sp#w0 TABLESPACE InnoDB NORMAL test/emp#p#west#sp#w0 MYSQL_TMP_DIR/alt_dir_west/test/emp#p#west#sp#w0.ibd
175 test/emp#p#west#sp#w1 TABLESPACE InnoDB NORMAL test/emp#p#west#sp#w1 MYSQL_TMP_DIR/alt_dir_west/test/emp#p#west#sp#w1.ibd
176 ---- MYSQLD_DATADIR/test
177 ---- MYSQL_TMP_DIR/alt_dir_northeast/test
178 ---- MYSQL_TMP_DIR/alt_dir_southwest/test
179 ---- MYSQL_TMP_DIR/alt_dir_east/test
180 emp#p#east#sp#e0.ibd
181 emp#p#east#sp#e1.ibd
182 ---- MYSQL_TMP_DIR/alt_dir_north/test
183 emp#p#north#sp#n0.ibd
184 emp#p#north#sp#n1.ibd
185 ---- MYSQL_TMP_DIR/alt_dir_west/test
186 emp#p#west#sp#w0.ibd
187 emp#p#west#sp#w1.ibd
188 ---- MYSQL_TMP_DIR/alt_dir_south/test
189 emp#p#south#sp#s0.ibd
190 emp#p#south#sp#s1.ibd
191 DROP TABLE emp;
192 #
193 # Cleanup
194 #
195 CREATE TABLE t1 (a INT) ENGINE = InnoDB
196 PARTITION BY RANGE (a)
197 (partition p0 values less than MAXVALUE);
198 INSERT INTO t1 VALUES (1), (11), (21), (33);
199 SELECT * FROM t1;
200 a
201 1
202 11
203 21
204 33
205 SHOW CREATE TABLE t1;
206 Table Create Table
207 t1 CREATE TABLE `t1` (
208 `a` int DEFAULT NULL
209 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 /*!50100 PARTITION BY RANGE (`a`)
211 (PARTITION p0 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
212 ---- MYSQLD_DATADIR/test
213 t1#p#p0.ibd
214 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO
215 (PARTITION p0 VALUES LESS THAN (10),
216 PARTITION p10 VALUES LESS THAN MAXVALUE);
217 SHOW CREATE TABLE t1;
218 Table Create Table
219 t1 CREATE TABLE `t1` (
220 `a` int DEFAULT NULL
221 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
222 /*!50100 PARTITION BY RANGE (`a`)
223 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
224 PARTITION p10 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
225 SELECT * FROM t1;
226 a
227 1
228 11
229 21
230 33
231 ---- MYSQLD_DATADIR/test
232 t1#p#p0.ibd
233 t1#p#p10.ibd
234 DROP TABLE t1;
235 CREATE TABLE tsp (
236 a INT,
237 b VARCHAR(55),
238 PRIMARY KEY (a))
239 ENGINE = InnoDB
240 PARTITION BY RANGE (a)
241 SUBPARTITION BY HASH(a)
242 (PARTITION p0 VALUES LESS THAN (10)
243 (SUBPARTITION sp00,
244 SUBPARTITION sp01,
245 SUBPARTITION sp02,
246 SUBPARTITION sp03,
247 SUBPARTITION sp04),
248 PARTITION p1 VALUES LESS THAN (20)
249 (SUBPARTITION sp10,
250 SUBPARTITION sp11,
251 SUBPARTITION sp12,
252 SUBPARTITION sp13,
253 SUBPARTITION sp14),
254 PARTITION p2 VALUES LESS THAN (100)
255 (SUBPARTITION sp20,
256 SUBPARTITION sp21,
257 SUBPARTITION sp22,
258 SUBPARTITION sp23,
259 SUBPARTITION sp24));
260 INSERT INTO tsp VALUES(1, 'one'), (5, 'five'), (15, 'fifteen'), (30, 'thirty'), (40, 'forty'), (61, 'sixty one'), (75, 'seventy five'), (79, 'seventy nine'), (81, 'eighty one'), (83, 'eighty three'), (99, 'ninety nine');
261 SELECT * FROM tsp PARTITION(p2);
262 a b
263 30 thirty
264 40 forty
265 75 seventy five
266 61 sixty one
267 81 eighty one
268 83 eighty three
269 79 seventy nine
270 99 ninety nine
271 ---- MYSQLD_DATADIR/test
272 tsp#p#p0#sp#sp00.ibd
273 tsp#p#p0#sp#sp01.ibd
274 tsp#p#p0#sp#sp02.ibd
275 tsp#p#p0#sp#sp03.ibd
276 tsp#p#p0#sp#sp04.ibd
277 tsp#p#p1#sp#sp10.ibd
278 tsp#p#p1#sp#sp11.ibd
279 tsp#p#p1#sp#sp12.ibd
280 tsp#p#p1#sp#sp13.ibd
281 tsp#p#p1#sp#sp14.ibd
282 tsp#p#p2#sp#sp20.ibd
283 tsp#p#p2#sp#sp21.ibd
284 tsp#p#p2#sp#sp22.ibd
285 tsp#p#p2#sp#sp23.ibd
286 tsp#p#p2#sp#sp24.ibd
287 ALTER TABLE tsp REORGANIZE PARTITION p2 INTO(
288 PARTITION p20 VALUES LESS THAN(60) (SUBPARTITION sp200, SUBPARTITION sp201, SUBPARTITION sp202, SUBPARTITION sp203, SUBPARTITION sp204),
289 PARTITION p2 VALUES LESS THAN(100) (SUBPARTITION sp20, SUBPARTITION sp211, SUBPARTITION sp22, SUBPARTITION sp213, SUBPARTITION sp24));
290 SHOW CREATE TABLE tsp;
291 Table Create Table
292 tsp CREATE TABLE `tsp` (
293 `a` int NOT NULL,
294 `b` varchar(55) DEFAULT NULL,
295 PRIMARY KEY (`a`)
296 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297 /*!50100 PARTITION BY RANGE (`a`)
298 SUBPARTITION BY HASH (`a`)
299 (PARTITION p0 VALUES LESS THAN (10)
300 (SUBPARTITION sp00 ENGINE = InnoDB,
301 SUBPARTITION sp01 ENGINE = InnoDB,
302 SUBPARTITION sp02 ENGINE = InnoDB,
303 SUBPARTITION sp03 ENGINE = InnoDB,
304 SUBPARTITION sp04 ENGINE = InnoDB),
305 PARTITION p1 VALUES LESS THAN (20)
306 (SUBPARTITION sp10 ENGINE = InnoDB,
307 SUBPARTITION sp11 ENGINE = InnoDB,
308 SUBPARTITION sp12 ENGINE = InnoDB,
309 SUBPARTITION sp13 ENGINE = InnoDB,
310 SUBPARTITION sp14 ENGINE = InnoDB),
311 PARTITION p20 VALUES LESS THAN (60)
312 (SUBPARTITION sp200 ENGINE = InnoDB,
313 SUBPARTITION sp201 ENGINE = InnoDB,
314 SUBPARTITION sp202 ENGINE = InnoDB,
315 SUBPARTITION sp203 ENGINE = InnoDB,
316 SUBPARTITION sp204 ENGINE = InnoDB),
317 PARTITION p2 VALUES LESS THAN (100)
318 (SUBPARTITION sp20 ENGINE = InnoDB,
319 SUBPARTITION sp211 ENGINE = InnoDB,
320 SUBPARTITION sp22 ENGINE = InnoDB,
321 SUBPARTITION sp213 ENGINE = InnoDB,
322 SUBPARTITION sp24 ENGINE = InnoDB)) */
323 ---- MYSQLD_DATADIR/test
324 tsp#p#p0#sp#sp00.ibd
325 tsp#p#p0#sp#sp01.ibd
326 tsp#p#p0#sp#sp02.ibd
327 tsp#p#p0#sp#sp03.ibd
328 tsp#p#p0#sp#sp04.ibd
329 tsp#p#p1#sp#sp10.ibd
330 tsp#p#p1#sp#sp11.ibd
331 tsp#p#p1#sp#sp12.ibd
332 tsp#p#p1#sp#sp13.ibd
333 tsp#p#p1#sp#sp14.ibd
334 tsp#p#p2#sp#sp20.ibd
335 tsp#p#p2#sp#sp211.ibd
336 tsp#p#p2#sp#sp213.ibd
337 tsp#p#p2#sp#sp22.ibd
338 tsp#p#p2#sp#sp24.ibd
339 tsp#p#p20#sp#sp200.ibd
340 tsp#p#p20#sp#sp201.ibd
341 tsp#p#p20#sp#sp202.ibd
342 tsp#p#p20#sp#sp203.ibd
343 tsp#p#p20#sp#sp204.ibd
344 SELECT * FROM tsp PARTITION(p2);
345 a b
346 75 seventy five
347 61 sixty one
348 81 eighty one
349 83 eighty three
350 79 seventy nine
351 99 ninety nine
352 SELECT * FROM tsp PARTITION(p20);
353 a b
354 30 thirty
355 40 forty
356 DROP TABLE tsp;