Debian Codegraph @

mysql-test/suite/innodb/r/partition_upgrade_8019_mac_lctn_1.result

raw
1 # Test Upgrade from old version 8019
2 # Stop DB server which was created by MTR default
3 # Copy and unzip old version data directory.
4 # Copy and unzip external directory
5 List all files before upgrade
6 -----------------------------
7 table_part_1#p#p0.ibd
8 table_part_1#p#p1.ibd
9 table_part_1#p#p2.ibd
10 table_part_1#p#p3.ibd
11 table_part_1#p#p4.ibd
12 table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd
13 table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd
14 table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd
15 table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd
16 table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd
17 table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd
18 table_part_cap_6#p#p0.ibd
19 table_part_cap_6#p#p1.ibd
20 table_part_cap_6#p#p2.ibd
21 table_part_cap_6#p#p3.ibd
22 table_part_cap_6#p#p4.ibd
23 table_part_sub_1#p#part_1#sp#part_1sp0.ibd
24 table_part_sub_1#p#part_1#sp#part_1sp1.ibd
25 table_part_sub_1#p#part_2#sp#part_2sp0.ibd
26 table_part_sub_1#p#part_2#sp#part_2sp1.ibd
27 table_part_sub_1#p#part_3#sp#part_3sp0.ibd
28 table_part_sub_1#p#part_3#sp#part_3sp1.ibd
29 table_part_sub_1#p#part_4#sp#part_4sp0.ibd
30 table_part_sub_1#p#part_4#sp#part_4sp1.ibd
31 table_part_sub_2#p#part_1#sp#sub_1.ibd
32 table_part_sub_2#p#part_1#sp#sub_2.ibd
33 table_part_sub_2#p#part_2#sp#sub_4.ibd
34 table_part_sub_2#p#part_3#sp#sub_5.ibd
35 table_part_sub_2#p#part_3#sp#sub_6.ibd
36
37 List all files in external directory
38 ------------------------------------
39 table_part_2#p#p0.ibd
40 table_part_2#p#p1.ibd
41 table_part_2#p#p2.ibd
42 table_part_2#p#p3.ibd
43 table_part_2#p#p4.ibd
44 table_part_sub_2#p#part_2#sp#sub_3.ibd
45
46 List files outside database directory (empty)
47 ---------------------------------------------
48 test
49
50 # Upgrade to latest mysql version
51
52 List all files of upgraded data
53 -------------------------------
54 table_part_1#p#p0.ibd
55 table_part_1#p#p1.ibd
56 table_part_1#p#p2.ibd
57 table_part_1#p#p3.ibd
58 table_part_1#p#p4.ibd
59 table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd
60 table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd
61 table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd
62 table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd
63 table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd
64 table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd
65 table_part_cap_6#p#p0.ibd
66 table_part_cap_6#p#p1.ibd
67 table_part_cap_6#p#p2.ibd
68 table_part_cap_6#p#p3.ibd
69 table_part_cap_6#p#p4.ibd
70 table_part_sub_1#p#part_1#sp#part_1sp0.ibd
71 table_part_sub_1#p#part_1#sp#part_1sp1.ibd
72 table_part_sub_1#p#part_2#sp#part_2sp0.ibd
73 table_part_sub_1#p#part_2#sp#part_2sp1.ibd
74 table_part_sub_1#p#part_3#sp#part_3sp0.ibd
75 table_part_sub_1#p#part_3#sp#part_3sp1.ibd
76 table_part_sub_1#p#part_4#sp#part_4sp0.ibd
77 table_part_sub_1#p#part_4#sp#part_4sp1.ibd
78 table_part_sub_2#p#part_1#sp#sub_1.ibd
79 table_part_sub_2#p#part_1#sp#sub_2.ibd
80 table_part_sub_2#p#part_2#sp#sub_4.ibd
81 table_part_sub_2#p#part_3#sp#sub_5.ibd
82 table_part_sub_2#p#part_3#sp#sub_6.ibd
83
84 List all files in external directory
85 ------------------------------------
86 table_part_2#p#p0.ibd
87 table_part_2#p#p1.ibd
88 table_part_2#p#p2.ibd
89 table_part_2#p#p3.ibd
90 table_part_2#p#p4.ibd
91 table_part_sub_2#p#part_2#sp#sub_3.ibd
92
93 List files outside database directory (empty)
94 ---------------------------------------------
95 test
96
97 # A. Validate upgraded tables and data
98 # 1. Check table metadata and data
99 Checking partitioned tables
100 ---------------------------
101 SET NAMES utf8mb4 COLLATE utf8mb4_0900_as_cs;
102
103 CHECK TABLE table_part_1;
104 Table Op Msg_type Msg_text
105 test.table_part_1 check status OK
106
107 SHOW CREATE TABLE table_part_1;
108 Table Create Table
109 table_part_1 CREATE TABLE `table_part_1` (
110 `id` int NOT NULL,
111 `value` int DEFAULT NULL,
112 `name` varchar(32) DEFAULT NULL,
113 `data` blob,
114 PRIMARY KEY (`id`),
115 KEY `k1` (`value`)
116 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
117 /*!50100 PARTITION BY HASH (`id`)
118 PARTITIONS 5 */
119
120 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_1 order by id;
121 id value name SUBSTRING(data, 1024, 32)
122 0 55 Row - 0 ta - 0Large Column Data - 0Large
123 1 155 Row - 1 ta - 1Large Column Data - 1Large
124 2 255 Row - 2 ta - 2Large Column Data - 2Large
125 3 355 Row - 3 ta - 3Large Column Data - 3Large
126 4 455 Row - 4 ta - 4Large Column Data - 4Large
127 5 555 Row - 5 ta - 5Large Column Data - 5Large
128 6 655 Row - 6 ta - 6Large Column Data - 6Large
129 7 755 Row - 7 ta - 7Large Column Data - 7Large
130 8 855 Row - 8 ta - 8Large Column Data - 8Large
131 9 955 Row - 9 ta - 9Large Column Data - 9Large
132
133 CHECK TABLE table_part_sub_1;
134 Table Op Msg_type Msg_text
135 test.table_part_sub_1 check status OK
136
137 SHOW CREATE TABLE table_part_sub_1;
138 Table Create Table
139 table_part_sub_1 CREATE TABLE `table_part_sub_1` (
140 `id` int NOT NULL,
141 `value` int NOT NULL,
142 `name` varchar(32) DEFAULT NULL,
143 `data` blob,
144 PRIMARY KEY (`id`,`value`),
145 KEY `k1` (`value`)
146 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
147 /*!50100 PARTITION BY RANGE (`value`)
148 SUBPARTITION BY HASH (`id`)
149 SUBPARTITIONS 2
150 (PARTITION Part_1 VALUES LESS THAN (101) ENGINE = InnoDB,
151 PARTITION pArt_2 VALUES LESS THAN (401) ENGINE = InnoDB,
152 PARTITION part_3 VALUES LESS THAN (701) ENGINE = InnoDB,
153 PARTITION PART_4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
154
155 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_1 order by id;
156 id value name SUBSTRING(data, 1024, 32)
157 0 55 Row - 0 ta - 0Large Column Data - 0Large
158 1 155 Row - 1 ta - 1Large Column Data - 1Large
159 2 255 Row - 2 ta - 2Large Column Data - 2Large
160 3 355 Row - 3 ta - 3Large Column Data - 3Large
161 4 455 Row - 4 ta - 4Large Column Data - 4Large
162 5 555 Row - 5 ta - 5Large Column Data - 5Large
163 6 655 Row - 6 ta - 6Large Column Data - 6Large
164 7 755 Row - 7 ta - 7Large Column Data - 7Large
165 8 855 Row - 8 ta - 8Large Column Data - 8Large
166 9 955 Row - 9 ta - 9Large Column Data - 9Large
167
168 CHECK TABLE table_part_sub_2;
169 Table Op Msg_type Msg_text
170 test.table_part_sub_2 check status OK
171
172 SHOW CREATE TABLE table_part_sub_2;
173 Table Create Table
174 table_part_sub_2 CREATE TABLE `table_part_sub_2` (
175 `id` int NOT NULL,
176 `value` int NOT NULL,
177 `name` varchar(32) DEFAULT NULL,
178 `data` blob,
179 PRIMARY KEY (`id`,`value`),
180 KEY `k1` (`value`)
181 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
182 /*!50100 PARTITION BY RANGE (`value`)
183 SUBPARTITION BY HASH (`id`)
184 (PARTITION Part_1 VALUES LESS THAN (101)
185 (SUBPARTITION Sub_1 ENGINE = InnoDB,
186 SUBPARTITION sUb_2 ENGINE = InnoDB),
187 PARTITION pArt_2 VALUES LESS THAN (501)
188 (SUBPARTITION suB_3 DATA DIRECTORY = '/tmp/mysql_wl13352_data' ENGINE = InnoDB,
189 SUBPARTITION SUB_4 ENGINE = InnoDB),
190 PARTITION PART_3 VALUES LESS THAN MAXVALUE
191 (SUBPARTITION SUB_5 ENGINE = InnoDB,
192 SUBPARTITION sub_6 ENGINE = InnoDB)) */
193
194 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_2 order by id;
195 id value name SUBSTRING(data, 1024, 32)
196 0 55 Row - 0 ta - 0Large Column Data - 0Large
197 1 155 Row - 1 ta - 1Large Column Data - 1Large
198 2 255 Row - 2 ta - 2Large Column Data - 2Large
199 3 355 Row - 3 ta - 3Large Column Data - 3Large
200 4 455 Row - 4 ta - 4Large Column Data - 4Large
201 5 555 Row - 5 ta - 5Large Column Data - 5Large
202 6 655 Row - 6 ta - 6Large Column Data - 6Large
203 7 755 Row - 7 ta - 7Large Column Data - 7Large
204 8 855 Row - 8 ta - 8Large Column Data - 8Large
205 9 955 Row - 9 ta - 9Large Column Data - 9Large
206
207 CHECK TABLE `table_part_\_special_/_sub_?_3`;
208 Table Op Msg_type Msg_text
209 test.table_part_\_special_/_sub_?_3 check status OK
210
211 SHOW CREATE TABLE `table_part_\_special_/_sub_?_3`;
212 Table Create Table
213 table_part_\_special_/_sub_?_3 CREATE TABLE `table_part_\_special_/_sub_?_3` (
214 `id` int NOT NULL,
215 `value` int NOT NULL,
216 `name` varchar(32) DEFAULT NULL,
217 `data` blob,
218 PRIMARY KEY (`id`,`value`),
219 KEY `k1` (`value`)
220 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
221 /*!50100 PARTITION BY RANGE (`value`)
222 SUBPARTITION BY HASH (`id`)
223 (PARTITION `Part_?_1` VALUES LESS THAN (201)
224 (SUBPARTITION `Sub_?_1` ENGINE = InnoDB,
225 SUBPARTITION `sUb_/_2` ENGINE = InnoDB),
226 PARTITION `pArt_\_2` VALUES LESS THAN (501)
227 (SUBPARTITION `suB_\_3` ENGINE = InnoDB,
228 SUBPARTITION `SUB_?\_4` ENGINE = InnoDB),
229 PARTITION `PART_/_3` VALUES LESS THAN MAXVALUE
230 (SUBPARTITION `SUB_?/_5` ENGINE = InnoDB,
231 SUBPARTITION `sub_\/?_6` ENGINE = InnoDB)) */
232
233 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM `table_part_\_special_/_sub_?_3` order by id;
234 id value name SUBSTRING(data, 1024, 32)
235 0 55 Row - 0 ta - 0Large Column Data - 0Large
236 1 155 Row - 1 ta - 1Large Column Data - 1Large
237 2 255 Row - 2 ta - 2Large Column Data - 2Large
238 3 355 Row - 3 ta - 3Large Column Data - 3Large
239 4 455 Row - 4 ta - 4Large Column Data - 4Large
240 5 555 Row - 5 ta - 5Large Column Data - 5Large
241 6 655 Row - 6 ta - 6Large Column Data - 6Large
242 7 755 Row - 7 ta - 7Large Column Data - 7Large
243 8 855 Row - 8 ta - 8Large Column Data - 8Large
244 9 955 Row - 9 ta - 9Large Column Data - 9Large
245
246 CHECK TABLE table_part_2;
247 Table Op Msg_type Msg_text
248 test.table_part_2 check status OK
249
250 SHOW CREATE TABLE table_part_2;
251 Table Create Table
252 table_part_2 CREATE TABLE `table_part_2` (
253 `id` int NOT NULL,
254 `value` int DEFAULT NULL,
255 `name` varchar(32) DEFAULT NULL,
256 `data` blob,
257 PRIMARY KEY (`id`),
258 KEY `k1` (`value`)
259 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
260 /*!50100 PARTITION BY HASH (`id`)
261 PARTITIONS 5 */
262
263 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_2 order by id;
264 id value name SUBSTRING(data, 1024, 32)
265 0 55 Row - 0 ta - 0Large Column Data - 0Large
266 1 155 Row - 1 ta - 1Large Column Data - 1Large
267 2 255 Row - 2 ta - 2Large Column Data - 2Large
268 3 355 Row - 3 ta - 3Large Column Data - 3Large
269 4 455 Row - 4 ta - 4Large Column Data - 4Large
270 5 555 Row - 5 ta - 5Large Column Data - 5Large
271 6 655 Row - 6 ta - 6Large Column Data - 6Large
272 7 755 Row - 7 ta - 7Large Column Data - 7Large
273 8 855 Row - 8 ta - 8Large Column Data - 8Large
274 9 955 Row - 9 ta - 9Large Column Data - 9Large
275
276 CHECK TABLE table_part_CAP_6;
277 Table Op Msg_type Msg_text
278 test.table_part_cap_6 check status OK
279
280 SHOW CREATE TABLE table_part_CAP_6;
281 Table Create Table
282 table_part_CAP_6 CREATE TABLE `table_part_cap_6` (
283 `id` int NOT NULL,
284 `value` int DEFAULT NULL,
285 `name` varchar(32) DEFAULT NULL,
286 `data` blob,
287 PRIMARY KEY (`id`),
288 KEY `k1` (`value`)
289 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
290 /*!50100 PARTITION BY HASH (`id`)
291 PARTITIONS 5 */
292
293 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_CAP_6 order by id;
294 id value name SUBSTRING(data, 1024, 32)
295 0 55 Row - 0 ta - 0Large Column Data - 0Large
296 1 155 Row - 1 ta - 1Large Column Data - 1Large
297 2 255 Row - 2 ta - 2Large Column Data - 2Large
298 3 355 Row - 3 ta - 3Large Column Data - 3Large
299 4 455 Row - 4 ta - 4Large Column Data - 4Large
300 5 555 Row - 5 ta - 5Large Column Data - 5Large
301 6 655 Row - 6 ta - 6Large Column Data - 6Large
302 7 755 Row - 7 ta - 7Large Column Data - 7Large
303 8 855 Row - 8 ta - 8Large Column Data - 8Large
304 9 955 Row - 9 ta - 9Large Column Data - 9Large
305
306 CHECK TABLE table_part_NOPART_CAP_7;
307 Table Op Msg_type Msg_text
308 test.table_part_nopart_cap_7 check status OK
309
310 SHOW CREATE TABLE table_part_NOPART_CAP_7;
311 Table Create Table
312 table_part_NOPART_CAP_7 CREATE TABLE `table_part_nopart_cap_7` (
313 `id` int NOT NULL,
314 `value` int DEFAULT NULL,
315 `name` varchar(32) DEFAULT NULL,
316 `data` blob,
317 PRIMARY KEY (`id`),
318 KEY `k1` (`value`)
319 ) /*!50100 TABLESPACE `SPACE_part` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
320
321 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_NOPART_CAP_7 order by id;
322 id value name SUBSTRING(data, 1024, 32)
323 0 55 Row - 0 ta - 0Large Column Data - 0Large
324 1 155 Row - 1 ta - 1Large Column Data - 1Large
325 2 255 Row - 2 ta - 2Large Column Data - 2Large
326 3 355 Row - 3 ta - 3Large Column Data - 3Large
327 4 455 Row - 4 ta - 4Large Column Data - 4Large
328 5 555 Row - 5 ta - 5Large Column Data - 5Large
329 6 655 Row - 6 ta - 6Large Column Data - 6Large
330 7 755 Row - 7 ta - 7Large Column Data - 7Large
331 8 855 Row - 8 ta - 8Large Column Data - 8Large
332 9 955 Row - 9 ta - 9Large Column Data - 9Large
333
334 Checking IFS views
335 ------------------
336 select table_schema, table_name from information_schema.tables
337 where table_name LIKE '%table_part%' order by table_schema, table_name;
338 TABLE_SCHEMA TABLE_NAME
339 test table_part_1
340 test table_part_2
341 test table_part_\_special_/_sub_?_3
342 test table_part_cap_6
343 test table_part_nopart_cap_7
344 test table_part_sub_1
345 test table_part_sub_2
346
347 select name, space_type from information_schema.innodb_tables
348 where name LIKE '%table_part%' order by name, space_type;
349 name space_type
350 test/table_part_1#p#p0 Single
351 test/table_part_1#p#p1 Single
352 test/table_part_1#p#p2 Single
353 test/table_part_1#p#p3 Single
354 test/table_part_1#p#p4 Single
355 test/table_part_2#p#p0 Single
356 test/table_part_2#p#p1 Single
357 test/table_part_2#p#p2 Single
358 test/table_part_2#p#p3 Single
359 test/table_part_2#p#p4 Single
360 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5 Single
361 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6 Single
362 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2 Single
363 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1 Single
364 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4 Single
365 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3 Single
366 test/table_part_cap_6#p#p0 Single
367 test/table_part_cap_6#p#p1 Single
368 test/table_part_cap_6#p#p2 Single
369 test/table_part_cap_6#p#p3 Single
370 test/table_part_cap_6#p#p4 Single
371 test/table_part_nopart_cap_7 General
372 test/table_part_sub_1#p#part_1#sp#part_1sp0 Single
373 test/table_part_sub_1#p#part_1#sp#part_1sp1 Single
374 test/table_part_sub_1#p#part_2#sp#part_2sp0 Single
375 test/table_part_sub_1#p#part_2#sp#part_2sp1 Single
376 test/table_part_sub_1#p#part_3#sp#part_3sp0 Single
377 test/table_part_sub_1#p#part_3#sp#part_3sp1 Single
378 test/table_part_sub_1#p#part_4#sp#part_4sp0 Single
379 test/table_part_sub_1#p#part_4#sp#part_4sp1 Single
380 test/table_part_sub_2#p#part_1#sp#sub_1 Single
381 test/table_part_sub_2#p#part_1#sp#sub_2 Single
382 test/table_part_sub_2#p#part_2#sp#sub_3 Single
383 test/table_part_sub_2#p#part_2#sp#sub_4 Single
384 test/table_part_sub_2#p#part_3#sp#sub_5 Single
385 test/table_part_sub_2#p#part_3#sp#sub_6 Single
386
387 select table_schema, table_name, partition_name, subpartition_name
388 from information_schema.partitions
389 where table_name LIKE '%table_part%'
390 order by table_schema, table_name, partition_name, subpartition_name;
391 TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME
392 test table_part_1 p0 NULL
393 test table_part_1 p1 NULL
394 test table_part_1 p2 NULL
395 test table_part_1 p3 NULL
396 test table_part_1 p4 NULL
397 test table_part_2 p0 NULL
398 test table_part_2 p1 NULL
399 test table_part_2 p2 NULL
400 test table_part_2 p3 NULL
401 test table_part_2 p4 NULL
402 test table_part_\_special_/_sub_?_3 PART_/_3 SUB_?/_5
403 test table_part_\_special_/_sub_?_3 PART_/_3 sub_\/?_6
404 test table_part_\_special_/_sub_?_3 Part_?_1 sUb_/_2
405 test table_part_\_special_/_sub_?_3 Part_?_1 Sub_?_1
406 test table_part_\_special_/_sub_?_3 pArt_\_2 SUB_?\_4
407 test table_part_\_special_/_sub_?_3 pArt_\_2 suB_\_3
408 test table_part_cap_6 p0 NULL
409 test table_part_cap_6 p1 NULL
410 test table_part_cap_6 p2 NULL
411 test table_part_cap_6 p3 NULL
412 test table_part_cap_6 p4 NULL
413 test table_part_nopart_cap_7 NULL NULL
414 test table_part_sub_1 Part_1 Part_1sp0
415 test table_part_sub_1 Part_1 Part_1sp1
416 test table_part_sub_1 pArt_2 pArt_2sp0
417 test table_part_sub_1 pArt_2 pArt_2sp1
418 test table_part_sub_1 part_3 part_3sp0
419 test table_part_sub_1 part_3 part_3sp1
420 test table_part_sub_1 PART_4 PART_4sp0
421 test table_part_sub_1 PART_4 PART_4sp1
422 test table_part_sub_2 Part_1 Sub_1
423 test table_part_sub_2 Part_1 sUb_2
424 test table_part_sub_2 pArt_2 suB_3
425 test table_part_sub_2 pArt_2 SUB_4
426 test table_part_sub_2 PART_3 SUB_5
427 test table_part_sub_2 PART_3 sub_6
428
429 select name from information_schema.innodb_tablespaces
430 where name LIKE '%table_part%' order by name;
431 name
432 test/table_part_1#p#p0
433 test/table_part_1#p#p1
434 test/table_part_1#p#p2
435 test/table_part_1#p#p3
436 test/table_part_1#p#p4
437 test/table_part_2#p#p0
438 test/table_part_2#p#p1
439 test/table_part_2#p#p2
440 test/table_part_2#p#p3
441 test/table_part_2#p#p4
442 test/table_part_cap_6#p#p0
443 test/table_part_cap_6#p#p1
444 test/table_part_cap_6#p#p2
445 test/table_part_cap_6#p#p3
446 test/table_part_cap_6#p#p4
447 test/table_part_sub_1#p#part_1#sp#part_1sp0
448 test/table_part_sub_1#p#part_1#sp#part_1sp1
449 test/table_part_sub_1#p#part_2#sp#part_2sp0
450 test/table_part_sub_1#p#part_2#sp#part_2sp1
451 test/table_part_sub_1#p#part_3#sp#part_3sp0
452 test/table_part_sub_1#p#part_3#sp#part_3sp1
453 test/table_part_sub_1#p#part_4#sp#part_4sp0
454 test/table_part_sub_1#p#part_4#sp#part_4sp1
455 test/table_part_sub_2#p#part_1#sp#sub_1
456 test/table_part_sub_2#p#part_1#sp#sub_2
457 test/table_part_sub_2#p#part_2#sp#sub_3
458 test/table_part_sub_2#p#part_2#sp#sub_4
459 test/table_part_sub_2#p#part_3#sp#sub_5
460 test/table_part_sub_2#p#part_3#sp#sub_6
461 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
462 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
463 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
464 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
465 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
466 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
467
468 select file_type, status, file_name, tablespace_name from information_schema.files
469 where file_name LIKE '%table_part%'
470 order by file_type, status, file_name, tablespace_name;
471 FILE_TYPE STATUS FILE_NAME TABLESPACE_NAME
472 TABLESPACE NORMAL ./test/table_part_1#p#p0.ibd test/table_part_1#p#p0
473 TABLESPACE NORMAL ./test/table_part_1#p#p1.ibd test/table_part_1#p#p1
474 TABLESPACE NORMAL ./test/table_part_1#p#p2.ibd test/table_part_1#p#p2
475 TABLESPACE NORMAL ./test/table_part_1#p#p3.ibd test/table_part_1#p#p3
476 TABLESPACE NORMAL ./test/table_part_1#p#p4.ibd test/table_part_1#p#p4
477 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
478 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
479 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
480 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
481 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
482 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
483 TABLESPACE NORMAL ./test/table_part_cap_6#p#p0.ibd test/table_part_cap_6#p#p0
484 TABLESPACE NORMAL ./test/table_part_cap_6#p#p1.ibd test/table_part_cap_6#p#p1
485 TABLESPACE NORMAL ./test/table_part_cap_6#p#p2.ibd test/table_part_cap_6#p#p2
486 TABLESPACE NORMAL ./test/table_part_cap_6#p#p3.ibd test/table_part_cap_6#p#p3
487 TABLESPACE NORMAL ./test/table_part_cap_6#p#p4.ibd test/table_part_cap_6#p#p4
488 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_1#sp#part_1sp0.ibd test/table_part_sub_1#p#part_1#sp#part_1sp0
489 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_1#sp#part_1sp1.ibd test/table_part_sub_1#p#part_1#sp#part_1sp1
490 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_2#sp#part_2sp0.ibd test/table_part_sub_1#p#part_2#sp#part_2sp0
491 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_2#sp#part_2sp1.ibd test/table_part_sub_1#p#part_2#sp#part_2sp1
492 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_3#sp#part_3sp0.ibd test/table_part_sub_1#p#part_3#sp#part_3sp0
493 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_3#sp#part_3sp1.ibd test/table_part_sub_1#p#part_3#sp#part_3sp1
494 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_4#sp#part_4sp0.ibd test/table_part_sub_1#p#part_4#sp#part_4sp0
495 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_4#sp#part_4sp1.ibd test/table_part_sub_1#p#part_4#sp#part_4sp1
496 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_1#sp#sub_1.ibd test/table_part_sub_2#p#part_1#sp#sub_1
497 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_1#sp#sub_2.ibd test/table_part_sub_2#p#part_1#sp#sub_2
498 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_2#sp#sub_4.ibd test/table_part_sub_2#p#part_2#sp#sub_4
499 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_3#sp#sub_5.ibd test/table_part_sub_2#p#part_3#sp#sub_5
500 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_3#sp#sub_6.ibd test/table_part_sub_2#p#part_3#sp#sub_6
501 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p0.ibd test/table_part_2#p#p0
502 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p1.ibd test/table_part_2#p#p1
503 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p2.ibd test/table_part_2#p#p2
504 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p3.ibd test/table_part_2#p#p3
505 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p4.ibd test/table_part_2#p#p4
506 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_sub_2#p#part_2#sp#sub_3.ibd test/table_part_sub_2#p#part_2#sp#sub_3
507
508 Checking Innodb stat tables
509 ---------------------------
510 select database_name, table_name from mysql.innodb_table_stats
511 where table_name like '%table_part%' order by database_name, table_name;
512 database_name table_name
513 test table_part_1#p#p0
514 test table_part_1#p#p1
515 test table_part_1#p#p2
516 test table_part_1#p#p3
517 test table_part_1#p#p4
518 test table_part_2#p#p0
519 test table_part_2#p#p1
520 test table_part_2#p#p2
521 test table_part_2#p#p3
522 test table_part_2#p#p4
523 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
524 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
525 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
526 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
527 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
528 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
529 test table_part_cap_6#p#p0
530 test table_part_cap_6#p#p1
531 test table_part_cap_6#p#p2
532 test table_part_cap_6#p#p3
533 test table_part_cap_6#p#p4
534 test table_part_nopart_cap_7
535 test table_part_sub_1#p#part_1#sp#part_1sp0
536 test table_part_sub_1#p#part_1#sp#part_1sp1
537 test table_part_sub_1#p#part_2#sp#part_2sp0
538 test table_part_sub_1#p#part_2#sp#part_2sp1
539 test table_part_sub_1#p#part_3#sp#part_3sp0
540 test table_part_sub_1#p#part_3#sp#part_3sp1
541 test table_part_sub_1#p#part_4#sp#part_4sp0
542 test table_part_sub_1#p#part_4#sp#part_4sp1
543 test table_part_sub_2#p#part_1#sp#sub_1
544 test table_part_sub_2#p#part_1#sp#sub_2
545 test table_part_sub_2#p#part_2#sp#sub_3
546 test table_part_sub_2#p#part_2#sp#sub_4
547 test table_part_sub_2#p#part_3#sp#sub_5
548 test table_part_sub_2#p#part_3#sp#sub_6
549
550 select database_name, table_name, index_name, stat_name from mysql.innodb_index_stats
551 where table_name like '%table_part%'
552 order by database_name, table_name, index_name, stat_name;
553 database_name table_name index_name stat_name
554 test table_part_1#p#p0 PRIMARY n_diff_pfx01
555 test table_part_1#p#p0 PRIMARY n_leaf_pages
556 test table_part_1#p#p0 PRIMARY size
557 test table_part_1#p#p0 k1 n_diff_pfx01
558 test table_part_1#p#p0 k1 n_diff_pfx02
559 test table_part_1#p#p0 k1 n_leaf_pages
560 test table_part_1#p#p0 k1 size
561 test table_part_1#p#p1 PRIMARY n_diff_pfx01
562 test table_part_1#p#p1 PRIMARY n_leaf_pages
563 test table_part_1#p#p1 PRIMARY size
564 test table_part_1#p#p1 k1 n_diff_pfx01
565 test table_part_1#p#p1 k1 n_diff_pfx02
566 test table_part_1#p#p1 k1 n_leaf_pages
567 test table_part_1#p#p1 k1 size
568 test table_part_1#p#p2 PRIMARY n_diff_pfx01
569 test table_part_1#p#p2 PRIMARY n_leaf_pages
570 test table_part_1#p#p2 PRIMARY size
571 test table_part_1#p#p2 k1 n_diff_pfx01
572 test table_part_1#p#p2 k1 n_diff_pfx02
573 test table_part_1#p#p2 k1 n_leaf_pages
574 test table_part_1#p#p2 k1 size
575 test table_part_1#p#p3 PRIMARY n_diff_pfx01
576 test table_part_1#p#p3 PRIMARY n_leaf_pages
577 test table_part_1#p#p3 PRIMARY size
578 test table_part_1#p#p3 k1 n_diff_pfx01
579 test table_part_1#p#p3 k1 n_diff_pfx02
580 test table_part_1#p#p3 k1 n_leaf_pages
581 test table_part_1#p#p3 k1 size
582 test table_part_1#p#p4 PRIMARY n_diff_pfx01
583 test table_part_1#p#p4 PRIMARY n_leaf_pages
584 test table_part_1#p#p4 PRIMARY size
585 test table_part_1#p#p4 k1 n_diff_pfx01
586 test table_part_1#p#p4 k1 n_diff_pfx02
587 test table_part_1#p#p4 k1 n_leaf_pages
588 test table_part_1#p#p4 k1 size
589 test table_part_2#p#p0 PRIMARY n_diff_pfx01
590 test table_part_2#p#p0 PRIMARY n_leaf_pages
591 test table_part_2#p#p0 PRIMARY size
592 test table_part_2#p#p0 k1 n_diff_pfx01
593 test table_part_2#p#p0 k1 n_diff_pfx02
594 test table_part_2#p#p0 k1 n_leaf_pages
595 test table_part_2#p#p0 k1 size
596 test table_part_2#p#p1 PRIMARY n_diff_pfx01
597 test table_part_2#p#p1 PRIMARY n_leaf_pages
598 test table_part_2#p#p1 PRIMARY size
599 test table_part_2#p#p1 k1 n_diff_pfx01
600 test table_part_2#p#p1 k1 n_diff_pfx02
601 test table_part_2#p#p1 k1 n_leaf_pages
602 test table_part_2#p#p1 k1 size
603 test table_part_2#p#p2 PRIMARY n_diff_pfx01
604 test table_part_2#p#p2 PRIMARY n_leaf_pages
605 test table_part_2#p#p2 PRIMARY size
606 test table_part_2#p#p2 k1 n_diff_pfx01
607 test table_part_2#p#p2 k1 n_diff_pfx02
608 test table_part_2#p#p2 k1 n_leaf_pages
609 test table_part_2#p#p2 k1 size
610 test table_part_2#p#p3 PRIMARY n_diff_pfx01
611 test table_part_2#p#p3 PRIMARY n_leaf_pages
612 test table_part_2#p#p3 PRIMARY size
613 test table_part_2#p#p3 k1 n_diff_pfx01
614 test table_part_2#p#p3 k1 n_diff_pfx02
615 test table_part_2#p#p3 k1 n_leaf_pages
616 test table_part_2#p#p3 k1 size
617 test table_part_2#p#p4 PRIMARY n_diff_pfx01
618 test table_part_2#p#p4 PRIMARY n_leaf_pages
619 test table_part_2#p#p4 PRIMARY size
620 test table_part_2#p#p4 k1 n_diff_pfx01
621 test table_part_2#p#p4 k1 n_diff_pfx02
622 test table_part_2#p#p4 k1 n_leaf_pages
623 test table_part_2#p#p4 k1 size
624 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx01
625 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx02
626 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_leaf_pages
627 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY size
628 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx01
629 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx02
630 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_leaf_pages
631 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 size
632 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx01
633 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx02
634 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_leaf_pages
635 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY size
636 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx01
637 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx02
638 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_leaf_pages
639 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 size
640 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx01
641 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx02
642 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_leaf_pages
643 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY size
644 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx01
645 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx02
646 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_leaf_pages
647 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 size
648 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx01
649 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx02
650 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_leaf_pages
651 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY size
652 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx01
653 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx02
654 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_leaf_pages
655 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 size
656 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx01
657 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx02
658 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_leaf_pages
659 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY size
660 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx01
661 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx02
662 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_leaf_pages
663 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 size
664 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx01
665 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx02
666 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_leaf_pages
667 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY size
668 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx01
669 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx02
670 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_leaf_pages
671 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 size
672 test table_part_cap_6#p#p0 PRIMARY n_diff_pfx01
673 test table_part_cap_6#p#p0 PRIMARY n_leaf_pages
674 test table_part_cap_6#p#p0 PRIMARY size
675 test table_part_cap_6#p#p0 k1 n_diff_pfx01
676 test table_part_cap_6#p#p0 k1 n_diff_pfx02
677 test table_part_cap_6#p#p0 k1 n_leaf_pages
678 test table_part_cap_6#p#p0 k1 size
679 test table_part_cap_6#p#p1 PRIMARY n_diff_pfx01
680 test table_part_cap_6#p#p1 PRIMARY n_leaf_pages
681 test table_part_cap_6#p#p1 PRIMARY size
682 test table_part_cap_6#p#p1 k1 n_diff_pfx01
683 test table_part_cap_6#p#p1 k1 n_diff_pfx02
684 test table_part_cap_6#p#p1 k1 n_leaf_pages
685 test table_part_cap_6#p#p1 k1 size
686 test table_part_cap_6#p#p2 PRIMARY n_diff_pfx01
687 test table_part_cap_6#p#p2 PRIMARY n_leaf_pages
688 test table_part_cap_6#p#p2 PRIMARY size
689 test table_part_cap_6#p#p2 k1 n_diff_pfx01
690 test table_part_cap_6#p#p2 k1 n_diff_pfx02
691 test table_part_cap_6#p#p2 k1 n_leaf_pages
692 test table_part_cap_6#p#p2 k1 size
693 test table_part_cap_6#p#p3 PRIMARY n_diff_pfx01
694 test table_part_cap_6#p#p3 PRIMARY n_leaf_pages
695 test table_part_cap_6#p#p3 PRIMARY size
696 test table_part_cap_6#p#p3 k1 n_diff_pfx01
697 test table_part_cap_6#p#p3 k1 n_diff_pfx02
698 test table_part_cap_6#p#p3 k1 n_leaf_pages
699 test table_part_cap_6#p#p3 k1 size
700 test table_part_cap_6#p#p4 PRIMARY n_diff_pfx01
701 test table_part_cap_6#p#p4 PRIMARY n_leaf_pages
702 test table_part_cap_6#p#p4 PRIMARY size
703 test table_part_cap_6#p#p4 k1 n_diff_pfx01
704 test table_part_cap_6#p#p4 k1 n_diff_pfx02
705 test table_part_cap_6#p#p4 k1 n_leaf_pages
706 test table_part_cap_6#p#p4 k1 size
707 test table_part_nopart_cap_7 PRIMARY n_diff_pfx01
708 test table_part_nopart_cap_7 PRIMARY n_leaf_pages
709 test table_part_nopart_cap_7 PRIMARY size
710 test table_part_nopart_cap_7 k1 n_diff_pfx01
711 test table_part_nopart_cap_7 k1 n_diff_pfx02
712 test table_part_nopart_cap_7 k1 n_leaf_pages
713 test table_part_nopart_cap_7 k1 size
714 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx01
715 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx02
716 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_leaf_pages
717 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY size
718 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx01
719 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx02
720 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_leaf_pages
721 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 size
722 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx01
723 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx02
724 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_leaf_pages
725 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY size
726 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx01
727 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx02
728 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_leaf_pages
729 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 size
730 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx01
731 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx02
732 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_leaf_pages
733 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY size
734 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx01
735 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx02
736 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_leaf_pages
737 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 size
738 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx01
739 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx02
740 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_leaf_pages
741 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY size
742 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx01
743 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx02
744 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_leaf_pages
745 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 size
746 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx01
747 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx02
748 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_leaf_pages
749 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY size
750 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx01
751 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx02
752 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_leaf_pages
753 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 size
754 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx01
755 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx02
756 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_leaf_pages
757 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY size
758 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx01
759 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx02
760 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_leaf_pages
761 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 size
762 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx01
763 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx02
764 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_leaf_pages
765 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY size
766 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx01
767 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx02
768 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_leaf_pages
769 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 size
770 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx01
771 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx02
772 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_leaf_pages
773 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY size
774 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx01
775 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx02
776 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_leaf_pages
777 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 size
778 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx01
779 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx02
780 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_leaf_pages
781 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY size
782 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx01
783 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx02
784 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_leaf_pages
785 test table_part_sub_2#p#part_1#sp#sub_1 k1 size
786 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx01
787 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx02
788 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_leaf_pages
789 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY size
790 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx01
791 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx02
792 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_leaf_pages
793 test table_part_sub_2#p#part_1#sp#sub_2 k1 size
794 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx01
795 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx02
796 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_leaf_pages
797 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY size
798 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx01
799 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx02
800 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_leaf_pages
801 test table_part_sub_2#p#part_2#sp#sub_3 k1 size
802 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx01
803 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx02
804 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_leaf_pages
805 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY size
806 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx01
807 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx02
808 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_leaf_pages
809 test table_part_sub_2#p#part_2#sp#sub_4 k1 size
810 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx01
811 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx02
812 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_leaf_pages
813 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY size
814 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx01
815 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx02
816 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_leaf_pages
817 test table_part_sub_2#p#part_3#sp#sub_5 k1 size
818 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx01
819 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx02
820 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_leaf_pages
821 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY size
822 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx01
823 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx02
824 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_leaf_pages
825 test table_part_sub_2#p#part_3#sp#sub_6 k1 size
826 SET NAMES DEFAULT;
827 # 2. Do DML insert/update/delete on upgraded tables
828 DML on partitioned tables
829 -------------------------
830
831 insert into table_part_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
832
833 update table_part_1 set name = 'Row - updated' where value > 500;
834
835 delete from table_part_1 where id = 7;
836
837 insert into table_part_sub_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
838
839 update table_part_sub_1 set name = 'Row - updated' where value > 500;
840
841 delete from table_part_sub_1 where id = 7;
842
843 insert into table_part_sub_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
844
845 update table_part_sub_2 set name = 'Row - updated' where value > 500;
846
847 delete from table_part_sub_2 where id = 7;
848
849 insert into `table_part_\_special_/_sub_?_3` values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
850
851 update `table_part_\_special_/_sub_?_3` set name = 'Row - updated' where value > 500;
852
853 delete from `table_part_\_special_/_sub_?_3` where id = 7;
854
855 insert into table_part_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
856
857 update table_part_2 set name = 'Row - updated' where value > 500;
858
859 delete from table_part_2 where id = 7;
860
861 insert into table_part_CAP_6 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
862
863 update table_part_CAP_6 set name = 'Row - updated' where value > 500;
864
865 delete from table_part_CAP_6 where id = 7;
866
867 insert into table_part_NOPART_CAP_7 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
868
869 update table_part_NOPART_CAP_7 set name = 'Row - updated' where value > 500;
870
871 delete from table_part_NOPART_CAP_7 where id = 7;
872 # 3. Do DDL ALTER/DROP on upgraded tables
873 DDL on partitioned tables
874 -------------------------
875 ALTER TABLE table_part_1 TRUNCATE PARTITION p0;
876
877 ALTER TABLE table_part_1 COALESCE PARTITION 2;
878
879 SHOW CREATE TABLE table_part_1;
880 Table Create Table
881 table_part_1 CREATE TABLE `table_part_1` (
882 `id` int NOT NULL,
883 `value` int DEFAULT NULL,
884 `name` varchar(32) DEFAULT NULL,
885 `data` blob,
886 PRIMARY KEY (`id`),
887 KEY `k1` (`value`)
888 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
889 /*!50100 PARTITION BY HASH (`id`)
890 PARTITIONS 3 */
891
892 ALTER TABLE table_part_sub_1 TRUNCATE PARTITION part_1;
893
894 ALTER TABLE table_part_sub_2 TRUNCATE PARTITION part_3;
895
896 CREATE TABLE test_table LIKE table_part_sub_2;
897
898 ALTER TABLE test_table REMOVE PARTITIONING;
899 insert into test_table values(2, 265, "Row - 2", REPEAT('Large Column Data - 2' , 256));
900
901 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
902 id value name
903 2 255 Row - 2
904 4 455 Row - 4
905
906 SELECT id, value, name FROM test_table order by id;
907 id value name
908 2 265 Row - 2
909
910 ALTER TABLE table_part_sub_2 EXCHANGE PARTITION sub_3 WITH TABLE test_table;
911
912 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
913 id value name
914 2 265 Row - 2
915
916 SELECT id, value, name FROM test_table order by id;
917 id value name
918 2 255 Row - 2
919 4 455 Row - 4
920
921 DROP TABLE test_table;
922
923 ALTER TABLE table_part_sub_2 RENAME renamed_table;;
924 SHOW CREATE TABLE renamed_table;
925 Table Create Table
926 renamed_table CREATE TABLE `renamed_table` (
927 `id` int NOT NULL,
928 `value` int NOT NULL,
929 `name` varchar(32) DEFAULT NULL,
930 `data` blob,
931 PRIMARY KEY (`id`,`value`),
932 KEY `k1` (`value`)
933 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
934 /*!50100 PARTITION BY RANGE (`value`)
935 SUBPARTITION BY HASH (`id`)
936 (PARTITION Part_1 VALUES LESS THAN (101)
937 (SUBPARTITION Sub_1 ENGINE = InnoDB,
938 SUBPARTITION sUb_2 ENGINE = InnoDB),
939 PARTITION pArt_2 VALUES LESS THAN (501)
940 (SUBPARTITION suB_3 ENGINE = InnoDB,
941 SUBPARTITION SUB_4 ENGINE = InnoDB),
942 PARTITION PART_3 VALUES LESS THAN MAXVALUE
943 (SUBPARTITION SUB_5 ENGINE = InnoDB,
944 SUBPARTITION sub_6 ENGINE = InnoDB)) */
945
946 ALTER TABLE renamed_table RENAME table_part_sub_2;;
947
948 ALTER TABLE table_part_1 ENGINE = InnoDB;;
949
950 ALTER TABLE table_part_1 ADD COLUMN new_id int AFTER id;
951
952 ALTER TABLE table_part_1 REMOVE PARTITIONING;
953
954 ALTER TABLE table_part_sub_1 ENGINE = InnoDB;;
955
956 ALTER TABLE table_part_sub_1 ADD COLUMN new_id int AFTER id;
957
958 ALTER TABLE table_part_sub_1 REMOVE PARTITIONING;
959
960 ALTER TABLE table_part_sub_2 ENGINE = InnoDB;;
961
962 ALTER TABLE table_part_sub_2 ADD COLUMN new_id int AFTER id;
963
964 ALTER TABLE table_part_sub_2 REMOVE PARTITIONING;
965
966 ALTER TABLE `table_part_\_special_/_sub_?_3` ENGINE = InnoDB;;
967
968 ALTER TABLE `table_part_\_special_/_sub_?_3` ADD COLUMN new_id int AFTER id;
969
970 ALTER TABLE `table_part_\_special_/_sub_?_3` REMOVE PARTITIONING;
971
972 ALTER TABLE table_part_2 ENGINE = InnoDB;;
973
974 ALTER TABLE table_part_2 ADD COLUMN new_id int AFTER id;
975
976 ALTER TABLE table_part_2 REMOVE PARTITIONING;
977
978 ALTER TABLE table_part_CAP_6 ENGINE = InnoDB;;
979
980 ALTER TABLE table_part_CAP_6 ADD COLUMN new_id int AFTER id;
981
982 ALTER TABLE table_part_CAP_6 REMOVE PARTITIONING;
983
984 ALTER TABLE table_part_NOPART_CAP_7 ENGINE = InnoDB;;
985
986 ALTER TABLE table_part_NOPART_CAP_7 ADD COLUMN new_id int AFTER id;
987
988
989 # B. Create all the tables again and validate
990 Dropping partitioned tables
991 ---------------------------
992 DROP TABLE table_part_1;
993 DROP TABLE table_part_sub_1;
994 DROP TABLE table_part_sub_2;
995 DROP TABLE `table_part_\_special_/_sub_?_3`;
996 DROP TABLE table_part_2;
997 DROP TABLE table_part_CAP_6;
998 DROP TABLE table_part_NOPART_CAP_7;
999 DROP TABLESPACE SPACE_part;
1000 Creating partitioned tables
1001 ---------------------------
1002 CREATE TABLE table_part_1(
1003 id int primary key, value int, name varchar(32), data BLOB,
1004 key k1(value)) partition by hash (id) partitions 5;
1005
1006 CREATE TABLE table_part_2(
1007 id int primary key, value int, name varchar(32), data BLOB,
1008 key k1(value)) DATA DIRECTORY = '/tmp/mysql_wl13352_data/'
1009 partition by hash (id) partitions 5;
1010
1011 CREATE TABLE table_part_sub_1(
1012 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
1013 key k1(value)) partition by range (value) subpartition by hash (id)
1014 subpartitions 2 ( partition Part_1 values less than (101),
1015 partition pArt_2 values less than (401),
1016 partition part_3 values less than (701),
1017 partition PART_4 values less than MAXVALUE);
1018
1019 CREATE TABLE table_part_sub_2(
1020 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
1021 key k1(value)) partition by range (value) subpartition by hash (id)
1022 ( partition Part_1 values less than (101)(
1023 subpartition Sub_1,
1024 subpartition sUb_2),
1025 partition pArt_2 values less than (501)(
1026 subpartition suB_3 DATA DIRECTORY = '/tmp/mysql_wl13352_data/',
1027 subpartition SUB_4),
1028 partition PART_3 values less than MAXVALUE(
1029 subpartition SUB_5,
1030 subpartition sub_6));
1031
1032 CREATE TABLE `table_part_\_special_/_sub_?_3`(
1033 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
1034 key k1(value)) partition by range (value) subpartition by hash (id)
1035 ( partition `Part_?_1` values less than (201)(
1036 subpartition `Sub_?_1`,
1037 subpartition `sUb_/_2`),
1038 partition `pArt_\_2` values less than (501)(
1039 subpartition `suB_\_3`,
1040 subpartition `SUB_?\_4`),
1041 partition `PART_/_3` values less than MAXVALUE(
1042 subpartition `SUB_?/_5`,
1043 subpartition `sub_\/?_6`));
1044 CREATE TABLESPACE SPACE_part add datafile 'SPACE_part_1.ibd';
1045 CREATE TABLE table_part_CAP_6(
1046 id int primary key, value int, name varchar(32), data BLOB,
1047 key k1(value)) partition by hash (id) partitions 5;
1048 CREATE TABLE table_part_NOPART_CAP_7(
1049 id int primary key, value int, name varchar(32), data BLOB,
1050 key k1(value)) TABLESPACE SPACE_part;
1051
1052 Inserting 10 rows to table_part_1
1053 ---------------------------------------
1054 insert into table_part_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1055 insert into table_part_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1056 insert into table_part_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1057 insert into table_part_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1058 insert into table_part_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1059 insert into table_part_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1060 insert into table_part_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1061 insert into table_part_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1062 insert into table_part_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1063 insert into table_part_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1064
1065 Inserting 10 rows to table_part_sub_1
1066 ---------------------------------------
1067 insert into table_part_sub_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1068 insert into table_part_sub_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1069 insert into table_part_sub_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1070 insert into table_part_sub_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1071 insert into table_part_sub_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1072 insert into table_part_sub_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1073 insert into table_part_sub_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1074 insert into table_part_sub_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1075 insert into table_part_sub_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1076 insert into table_part_sub_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1077
1078 Inserting 10 rows to table_part_sub_2
1079 ---------------------------------------
1080 insert into table_part_sub_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1081 insert into table_part_sub_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1082 insert into table_part_sub_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1083 insert into table_part_sub_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1084 insert into table_part_sub_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1085 insert into table_part_sub_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1086 insert into table_part_sub_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1087 insert into table_part_sub_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1088 insert into table_part_sub_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1089 insert into table_part_sub_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1090
1091 Inserting 10 rows to `table_part_\_special_/_sub_?_3`
1092 ---------------------------------------
1093 insert into `table_part_\_special_/_sub_?_3` VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1094 insert into `table_part_\_special_/_sub_?_3` VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1095 insert into `table_part_\_special_/_sub_?_3` VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1096 insert into `table_part_\_special_/_sub_?_3` VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1097 insert into `table_part_\_special_/_sub_?_3` VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1098 insert into `table_part_\_special_/_sub_?_3` VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1099 insert into `table_part_\_special_/_sub_?_3` VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1100 insert into `table_part_\_special_/_sub_?_3` VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1101 insert into `table_part_\_special_/_sub_?_3` VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1102 insert into `table_part_\_special_/_sub_?_3` VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1103
1104 Inserting 10 rows to table_part_2
1105 ---------------------------------------
1106 insert into table_part_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1107 insert into table_part_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1108 insert into table_part_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1109 insert into table_part_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1110 insert into table_part_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1111 insert into table_part_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1112 insert into table_part_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1113 insert into table_part_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1114 insert into table_part_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1115 insert into table_part_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1116
1117 Inserting 10 rows to table_part_CAP_6
1118 ---------------------------------------
1119 insert into table_part_CAP_6 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1120 insert into table_part_CAP_6 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1121 insert into table_part_CAP_6 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1122 insert into table_part_CAP_6 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1123 insert into table_part_CAP_6 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1124 insert into table_part_CAP_6 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1125 insert into table_part_CAP_6 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1126 insert into table_part_CAP_6 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1127 insert into table_part_CAP_6 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1128 insert into table_part_CAP_6 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1129
1130 Inserting 10 rows to table_part_NOPART_CAP_7
1131 ---------------------------------------
1132 insert into table_part_NOPART_CAP_7 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1133 insert into table_part_NOPART_CAP_7 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1134 insert into table_part_NOPART_CAP_7 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1135 insert into table_part_NOPART_CAP_7 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1136 insert into table_part_NOPART_CAP_7 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1137 insert into table_part_NOPART_CAP_7 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1138 insert into table_part_NOPART_CAP_7 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1139 insert into table_part_NOPART_CAP_7 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1140 insert into table_part_NOPART_CAP_7 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1141 insert into table_part_NOPART_CAP_7 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1142 select id, value, name from table_part_sub_2 partition (sub_1) order by id;
1143 id value name
1144 0 55 Row - 0
1145 select id, value, name from table_part_sub_2 partition (sub_2) order by id;
1146 id value name
1147 select id, value, name from table_part_sub_2 partition (sub_3) order by id;
1148 id value name
1149 2 255 Row - 2
1150 4 455 Row - 4
1151 select id, value, name from table_part_sub_2 partition (sub_4) order by id;
1152 id value name
1153 1 155 Row - 1
1154 3 355 Row - 3
1155 select id, value, name from table_part_sub_2 partition (sub_5) order by id;
1156 id value name
1157 6 655 Row - 6
1158 8 855 Row - 8
1159 select id, value, name from table_part_sub_2 partition (sub_6) order by id;
1160 id value name
1161 5 555 Row - 5
1162 7 755 Row - 7
1163 9 955 Row - 9
1164
1165 # 1. Check table metadata and data
1166 Checking partitioned tables
1167 ---------------------------
1168 SET NAMES utf8mb4 COLLATE utf8mb4_0900_as_cs;
1169
1170 CHECK TABLE table_part_1;
1171 Table Op Msg_type Msg_text
1172 test.table_part_1 check status OK
1173
1174 SHOW CREATE TABLE table_part_1;
1175 Table Create Table
1176 table_part_1 CREATE TABLE `table_part_1` (
1177 `id` int NOT NULL,
1178 `value` int DEFAULT NULL,
1179 `name` varchar(32) DEFAULT NULL,
1180 `data` blob,
1181 PRIMARY KEY (`id`),
1182 KEY `k1` (`value`)
1183 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1184 /*!50100 PARTITION BY HASH (`id`)
1185 PARTITIONS 5 */
1186
1187 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_1 order by id;
1188 id value name SUBSTRING(data, 1024, 32)
1189 0 55 Row - 0 ta - 0Large Column Data - 0Large
1190 1 155 Row - 1 ta - 1Large Column Data - 1Large
1191 2 255 Row - 2 ta - 2Large Column Data - 2Large
1192 3 355 Row - 3 ta - 3Large Column Data - 3Large
1193 4 455 Row - 4 ta - 4Large Column Data - 4Large
1194 5 555 Row - 5 ta - 5Large Column Data - 5Large
1195 6 655 Row - 6 ta - 6Large Column Data - 6Large
1196 7 755 Row - 7 ta - 7Large Column Data - 7Large
1197 8 855 Row - 8 ta - 8Large Column Data - 8Large
1198 9 955 Row - 9 ta - 9Large Column Data - 9Large
1199
1200 CHECK TABLE table_part_sub_1;
1201 Table Op Msg_type Msg_text
1202 test.table_part_sub_1 check status OK
1203
1204 SHOW CREATE TABLE table_part_sub_1;
1205 Table Create Table
1206 table_part_sub_1 CREATE TABLE `table_part_sub_1` (
1207 `id` int NOT NULL,
1208 `value` int NOT NULL,
1209 `name` varchar(32) DEFAULT NULL,
1210 `data` blob,
1211 PRIMARY KEY (`id`,`value`),
1212 KEY `k1` (`value`)
1213 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1214 /*!50100 PARTITION BY RANGE (`value`)
1215 SUBPARTITION BY HASH (`id`)
1216 SUBPARTITIONS 2
1217 (PARTITION Part_1 VALUES LESS THAN (101) ENGINE = InnoDB,
1218 PARTITION pArt_2 VALUES LESS THAN (401) ENGINE = InnoDB,
1219 PARTITION part_3 VALUES LESS THAN (701) ENGINE = InnoDB,
1220 PARTITION PART_4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
1221
1222 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_1 order by id;
1223 id value name SUBSTRING(data, 1024, 32)
1224 0 55 Row - 0 ta - 0Large Column Data - 0Large
1225 1 155 Row - 1 ta - 1Large Column Data - 1Large
1226 2 255 Row - 2 ta - 2Large Column Data - 2Large
1227 3 355 Row - 3 ta - 3Large Column Data - 3Large
1228 4 455 Row - 4 ta - 4Large Column Data - 4Large
1229 5 555 Row - 5 ta - 5Large Column Data - 5Large
1230 6 655 Row - 6 ta - 6Large Column Data - 6Large
1231 7 755 Row - 7 ta - 7Large Column Data - 7Large
1232 8 855 Row - 8 ta - 8Large Column Data - 8Large
1233 9 955 Row - 9 ta - 9Large Column Data - 9Large
1234
1235 CHECK TABLE table_part_sub_2;
1236 Table Op Msg_type Msg_text
1237 test.table_part_sub_2 check status OK
1238
1239 SHOW CREATE TABLE table_part_sub_2;
1240 Table Create Table
1241 table_part_sub_2 CREATE TABLE `table_part_sub_2` (
1242 `id` int NOT NULL,
1243 `value` int NOT NULL,
1244 `name` varchar(32) DEFAULT NULL,
1245 `data` blob,
1246 PRIMARY KEY (`id`,`value`),
1247 KEY `k1` (`value`)
1248 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1249 /*!50100 PARTITION BY RANGE (`value`)
1250 SUBPARTITION BY HASH (`id`)
1251 (PARTITION Part_1 VALUES LESS THAN (101)
1252 (SUBPARTITION Sub_1 ENGINE = InnoDB,
1253 SUBPARTITION sUb_2 ENGINE = InnoDB),
1254 PARTITION pArt_2 VALUES LESS THAN (501)
1255 (SUBPARTITION suB_3 DATA DIRECTORY = '/tmp/mysql_wl13352_data/' ENGINE = InnoDB,
1256 SUBPARTITION SUB_4 ENGINE = InnoDB),
1257 PARTITION PART_3 VALUES LESS THAN MAXVALUE
1258 (SUBPARTITION SUB_5 ENGINE = InnoDB,
1259 SUBPARTITION sub_6 ENGINE = InnoDB)) */
1260
1261 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_2 order by id;
1262 id value name SUBSTRING(data, 1024, 32)
1263 0 55 Row - 0 ta - 0Large Column Data - 0Large
1264 1 155 Row - 1 ta - 1Large Column Data - 1Large
1265 2 255 Row - 2 ta - 2Large Column Data - 2Large
1266 3 355 Row - 3 ta - 3Large Column Data - 3Large
1267 4 455 Row - 4 ta - 4Large Column Data - 4Large
1268 5 555 Row - 5 ta - 5Large Column Data - 5Large
1269 6 655 Row - 6 ta - 6Large Column Data - 6Large
1270 7 755 Row - 7 ta - 7Large Column Data - 7Large
1271 8 855 Row - 8 ta - 8Large Column Data - 8Large
1272 9 955 Row - 9 ta - 9Large Column Data - 9Large
1273
1274 CHECK TABLE `table_part_\_special_/_sub_?_3`;
1275 Table Op Msg_type Msg_text
1276 test.table_part_\_special_/_sub_?_3 check status OK
1277
1278 SHOW CREATE TABLE `table_part_\_special_/_sub_?_3`;
1279 Table Create Table
1280 table_part_\_special_/_sub_?_3 CREATE TABLE `table_part_\_special_/_sub_?_3` (
1281 `id` int NOT NULL,
1282 `value` int NOT NULL,
1283 `name` varchar(32) DEFAULT NULL,
1284 `data` blob,
1285 PRIMARY KEY (`id`,`value`),
1286 KEY `k1` (`value`)
1287 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1288 /*!50100 PARTITION BY RANGE (`value`)
1289 SUBPARTITION BY HASH (`id`)
1290 (PARTITION `Part_?_1` VALUES LESS THAN (201)
1291 (SUBPARTITION `Sub_?_1` ENGINE = InnoDB,
1292 SUBPARTITION `sUb_/_2` ENGINE = InnoDB),
1293 PARTITION `pArt_\_2` VALUES LESS THAN (501)
1294 (SUBPARTITION `suB_\_3` ENGINE = InnoDB,
1295 SUBPARTITION `SUB_?\_4` ENGINE = InnoDB),
1296 PARTITION `PART_/_3` VALUES LESS THAN MAXVALUE
1297 (SUBPARTITION `SUB_?/_5` ENGINE = InnoDB,
1298 SUBPARTITION `sub_\/?_6` ENGINE = InnoDB)) */
1299
1300 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM `table_part_\_special_/_sub_?_3` order by id;
1301 id value name SUBSTRING(data, 1024, 32)
1302 0 55 Row - 0 ta - 0Large Column Data - 0Large
1303 1 155 Row - 1 ta - 1Large Column Data - 1Large
1304 2 255 Row - 2 ta - 2Large Column Data - 2Large
1305 3 355 Row - 3 ta - 3Large Column Data - 3Large
1306 4 455 Row - 4 ta - 4Large Column Data - 4Large
1307 5 555 Row - 5 ta - 5Large Column Data - 5Large
1308 6 655 Row - 6 ta - 6Large Column Data - 6Large
1309 7 755 Row - 7 ta - 7Large Column Data - 7Large
1310 8 855 Row - 8 ta - 8Large Column Data - 8Large
1311 9 955 Row - 9 ta - 9Large Column Data - 9Large
1312
1313 CHECK TABLE table_part_2;
1314 Table Op Msg_type Msg_text
1315 test.table_part_2 check status OK
1316
1317 SHOW CREATE TABLE table_part_2;
1318 Table Create Table
1319 table_part_2 CREATE TABLE `table_part_2` (
1320 `id` int NOT NULL,
1321 `value` int DEFAULT NULL,
1322 `name` varchar(32) DEFAULT NULL,
1323 `data` blob,
1324 PRIMARY KEY (`id`),
1325 KEY `k1` (`value`)
1326 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1327 /*!50100 PARTITION BY HASH (`id`)
1328 PARTITIONS 5 */
1329
1330 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_2 order by id;
1331 id value name SUBSTRING(data, 1024, 32)
1332 0 55 Row - 0 ta - 0Large Column Data - 0Large
1333 1 155 Row - 1 ta - 1Large Column Data - 1Large
1334 2 255 Row - 2 ta - 2Large Column Data - 2Large
1335 3 355 Row - 3 ta - 3Large Column Data - 3Large
1336 4 455 Row - 4 ta - 4Large Column Data - 4Large
1337 5 555 Row - 5 ta - 5Large Column Data - 5Large
1338 6 655 Row - 6 ta - 6Large Column Data - 6Large
1339 7 755 Row - 7 ta - 7Large Column Data - 7Large
1340 8 855 Row - 8 ta - 8Large Column Data - 8Large
1341 9 955 Row - 9 ta - 9Large Column Data - 9Large
1342
1343 CHECK TABLE table_part_CAP_6;
1344 Table Op Msg_type Msg_text
1345 test.table_part_cap_6 check status OK
1346
1347 SHOW CREATE TABLE table_part_CAP_6;
1348 Table Create Table
1349 table_part_CAP_6 CREATE TABLE `table_part_cap_6` (
1350 `id` int NOT NULL,
1351 `value` int DEFAULT NULL,
1352 `name` varchar(32) DEFAULT NULL,
1353 `data` blob,
1354 PRIMARY KEY (`id`),
1355 KEY `k1` (`value`)
1356 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1357 /*!50100 PARTITION BY HASH (`id`)
1358 PARTITIONS 5 */
1359
1360 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_CAP_6 order by id;
1361 id value name SUBSTRING(data, 1024, 32)
1362 0 55 Row - 0 ta - 0Large Column Data - 0Large
1363 1 155 Row - 1 ta - 1Large Column Data - 1Large
1364 2 255 Row - 2 ta - 2Large Column Data - 2Large
1365 3 355 Row - 3 ta - 3Large Column Data - 3Large
1366 4 455 Row - 4 ta - 4Large Column Data - 4Large
1367 5 555 Row - 5 ta - 5Large Column Data - 5Large
1368 6 655 Row - 6 ta - 6Large Column Data - 6Large
1369 7 755 Row - 7 ta - 7Large Column Data - 7Large
1370 8 855 Row - 8 ta - 8Large Column Data - 8Large
1371 9 955 Row - 9 ta - 9Large Column Data - 9Large
1372
1373 CHECK TABLE table_part_NOPART_CAP_7;
1374 Table Op Msg_type Msg_text
1375 test.table_part_nopart_cap_7 check status OK
1376
1377 SHOW CREATE TABLE table_part_NOPART_CAP_7;
1378 Table Create Table
1379 table_part_NOPART_CAP_7 CREATE TABLE `table_part_nopart_cap_7` (
1380 `id` int NOT NULL,
1381 `value` int DEFAULT NULL,
1382 `name` varchar(32) DEFAULT NULL,
1383 `data` blob,
1384 PRIMARY KEY (`id`),
1385 KEY `k1` (`value`)
1386 ) /*!50100 TABLESPACE `SPACE_part` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1387
1388 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_NOPART_CAP_7 order by id;
1389 id value name SUBSTRING(data, 1024, 32)
1390 0 55 Row - 0 ta - 0Large Column Data - 0Large
1391 1 155 Row - 1 ta - 1Large Column Data - 1Large
1392 2 255 Row - 2 ta - 2Large Column Data - 2Large
1393 3 355 Row - 3 ta - 3Large Column Data - 3Large
1394 4 455 Row - 4 ta - 4Large Column Data - 4Large
1395 5 555 Row - 5 ta - 5Large Column Data - 5Large
1396 6 655 Row - 6 ta - 6Large Column Data - 6Large
1397 7 755 Row - 7 ta - 7Large Column Data - 7Large
1398 8 855 Row - 8 ta - 8Large Column Data - 8Large
1399 9 955 Row - 9 ta - 9Large Column Data - 9Large
1400
1401 Checking IFS views
1402 ------------------
1403 select table_schema, table_name from information_schema.tables
1404 where table_name LIKE '%table_part%' order by table_schema, table_name;
1405 TABLE_SCHEMA TABLE_NAME
1406 test table_part_1
1407 test table_part_2
1408 test table_part_\_special_/_sub_?_3
1409 test table_part_cap_6
1410 test table_part_nopart_cap_7
1411 test table_part_sub_1
1412 test table_part_sub_2
1413
1414 select name, space_type from information_schema.innodb_tables
1415 where name LIKE '%table_part%' order by name, space_type;
1416 name space_type
1417 test/table_part_1#p#p0 Single
1418 test/table_part_1#p#p1 Single
1419 test/table_part_1#p#p2 Single
1420 test/table_part_1#p#p3 Single
1421 test/table_part_1#p#p4 Single
1422 test/table_part_2#p#p0 Single
1423 test/table_part_2#p#p1 Single
1424 test/table_part_2#p#p2 Single
1425 test/table_part_2#p#p3 Single
1426 test/table_part_2#p#p4 Single
1427 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5 Single
1428 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6 Single
1429 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2 Single
1430 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1 Single
1431 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4 Single
1432 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3 Single
1433 test/table_part_cap_6#p#p0 Single
1434 test/table_part_cap_6#p#p1 Single
1435 test/table_part_cap_6#p#p2 Single
1436 test/table_part_cap_6#p#p3 Single
1437 test/table_part_cap_6#p#p4 Single
1438 test/table_part_nopart_cap_7 General
1439 test/table_part_sub_1#p#part_1#sp#part_1sp0 Single
1440 test/table_part_sub_1#p#part_1#sp#part_1sp1 Single
1441 test/table_part_sub_1#p#part_2#sp#part_2sp0 Single
1442 test/table_part_sub_1#p#part_2#sp#part_2sp1 Single
1443 test/table_part_sub_1#p#part_3#sp#part_3sp0 Single
1444 test/table_part_sub_1#p#part_3#sp#part_3sp1 Single
1445 test/table_part_sub_1#p#part_4#sp#part_4sp0 Single
1446 test/table_part_sub_1#p#part_4#sp#part_4sp1 Single
1447 test/table_part_sub_2#p#part_1#sp#sub_1 Single
1448 test/table_part_sub_2#p#part_1#sp#sub_2 Single
1449 test/table_part_sub_2#p#part_2#sp#sub_3 Single
1450 test/table_part_sub_2#p#part_2#sp#sub_4 Single
1451 test/table_part_sub_2#p#part_3#sp#sub_5 Single
1452 test/table_part_sub_2#p#part_3#sp#sub_6 Single
1453
1454 select table_schema, table_name, partition_name, subpartition_name
1455 from information_schema.partitions
1456 where table_name LIKE '%table_part%'
1457 order by table_schema, table_name, partition_name, subpartition_name;
1458 TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME
1459 test table_part_1 p0 NULL
1460 test table_part_1 p1 NULL
1461 test table_part_1 p2 NULL
1462 test table_part_1 p3 NULL
1463 test table_part_1 p4 NULL
1464 test table_part_2 p0 NULL
1465 test table_part_2 p1 NULL
1466 test table_part_2 p2 NULL
1467 test table_part_2 p3 NULL
1468 test table_part_2 p4 NULL
1469 test table_part_\_special_/_sub_?_3 PART_/_3 SUB_?/_5
1470 test table_part_\_special_/_sub_?_3 PART_/_3 sub_\/?_6
1471 test table_part_\_special_/_sub_?_3 Part_?_1 sUb_/_2
1472 test table_part_\_special_/_sub_?_3 Part_?_1 Sub_?_1
1473 test table_part_\_special_/_sub_?_3 pArt_\_2 SUB_?\_4
1474 test table_part_\_special_/_sub_?_3 pArt_\_2 suB_\_3
1475 test table_part_cap_6 p0 NULL
1476 test table_part_cap_6 p1 NULL
1477 test table_part_cap_6 p2 NULL
1478 test table_part_cap_6 p3 NULL
1479 test table_part_cap_6 p4 NULL
1480 test table_part_nopart_cap_7 NULL NULL
1481 test table_part_sub_1 Part_1 Part_1sp0
1482 test table_part_sub_1 Part_1 Part_1sp1
1483 test table_part_sub_1 pArt_2 pArt_2sp0
1484 test table_part_sub_1 pArt_2 pArt_2sp1
1485 test table_part_sub_1 part_3 part_3sp0
1486 test table_part_sub_1 part_3 part_3sp1
1487 test table_part_sub_1 PART_4 PART_4sp0
1488 test table_part_sub_1 PART_4 PART_4sp1
1489 test table_part_sub_2 Part_1 Sub_1
1490 test table_part_sub_2 Part_1 sUb_2
1491 test table_part_sub_2 pArt_2 suB_3
1492 test table_part_sub_2 pArt_2 SUB_4
1493 test table_part_sub_2 PART_3 SUB_5
1494 test table_part_sub_2 PART_3 sub_6
1495
1496 select name from information_schema.innodb_tablespaces
1497 where name LIKE '%table_part%' order by name;
1498 name
1499 test/table_part_1#p#p0
1500 test/table_part_1#p#p1
1501 test/table_part_1#p#p2
1502 test/table_part_1#p#p3
1503 test/table_part_1#p#p4
1504 test/table_part_2#p#p0
1505 test/table_part_2#p#p1
1506 test/table_part_2#p#p2
1507 test/table_part_2#p#p3
1508 test/table_part_2#p#p4
1509 test/table_part_cap_6#p#p0
1510 test/table_part_cap_6#p#p1
1511 test/table_part_cap_6#p#p2
1512 test/table_part_cap_6#p#p3
1513 test/table_part_cap_6#p#p4
1514 test/table_part_sub_1#p#part_1#sp#part_1sp0
1515 test/table_part_sub_1#p#part_1#sp#part_1sp1
1516 test/table_part_sub_1#p#part_2#sp#part_2sp0
1517 test/table_part_sub_1#p#part_2#sp#part_2sp1
1518 test/table_part_sub_1#p#part_3#sp#part_3sp0
1519 test/table_part_sub_1#p#part_3#sp#part_3sp1
1520 test/table_part_sub_1#p#part_4#sp#part_4sp0
1521 test/table_part_sub_1#p#part_4#sp#part_4sp1
1522 test/table_part_sub_2#p#part_1#sp#sub_1
1523 test/table_part_sub_2#p#part_1#sp#sub_2
1524 test/table_part_sub_2#p#part_2#sp#sub_3
1525 test/table_part_sub_2#p#part_2#sp#sub_4
1526 test/table_part_sub_2#p#part_3#sp#sub_5
1527 test/table_part_sub_2#p#part_3#sp#sub_6
1528 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
1529 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
1530 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
1531 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
1532 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
1533 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
1534
1535 select file_type, status, file_name, tablespace_name from information_schema.files
1536 where file_name LIKE '%table_part%'
1537 order by file_type, status, file_name, tablespace_name;
1538 FILE_TYPE STATUS FILE_NAME TABLESPACE_NAME
1539 TABLESPACE NORMAL ./test/table_part_1#p#p0.ibd test/table_part_1#p#p0
1540 TABLESPACE NORMAL ./test/table_part_1#p#p1.ibd test/table_part_1#p#p1
1541 TABLESPACE NORMAL ./test/table_part_1#p#p2.ibd test/table_part_1#p#p2
1542 TABLESPACE NORMAL ./test/table_part_1#p#p3.ibd test/table_part_1#p#p3
1543 TABLESPACE NORMAL ./test/table_part_1#p#p4.ibd test/table_part_1#p#p4
1544 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
1545 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
1546 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
1547 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
1548 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
1549 TABLESPACE NORMAL ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
1550 TABLESPACE NORMAL ./test/table_part_cap_6#p#p0.ibd test/table_part_cap_6#p#p0
1551 TABLESPACE NORMAL ./test/table_part_cap_6#p#p1.ibd test/table_part_cap_6#p#p1
1552 TABLESPACE NORMAL ./test/table_part_cap_6#p#p2.ibd test/table_part_cap_6#p#p2
1553 TABLESPACE NORMAL ./test/table_part_cap_6#p#p3.ibd test/table_part_cap_6#p#p3
1554 TABLESPACE NORMAL ./test/table_part_cap_6#p#p4.ibd test/table_part_cap_6#p#p4
1555 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_1#sp#part_1sp0.ibd test/table_part_sub_1#p#part_1#sp#part_1sp0
1556 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_1#sp#part_1sp1.ibd test/table_part_sub_1#p#part_1#sp#part_1sp1
1557 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_2#sp#part_2sp0.ibd test/table_part_sub_1#p#part_2#sp#part_2sp0
1558 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_2#sp#part_2sp1.ibd test/table_part_sub_1#p#part_2#sp#part_2sp1
1559 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_3#sp#part_3sp0.ibd test/table_part_sub_1#p#part_3#sp#part_3sp0
1560 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_3#sp#part_3sp1.ibd test/table_part_sub_1#p#part_3#sp#part_3sp1
1561 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_4#sp#part_4sp0.ibd test/table_part_sub_1#p#part_4#sp#part_4sp0
1562 TABLESPACE NORMAL ./test/table_part_sub_1#p#part_4#sp#part_4sp1.ibd test/table_part_sub_1#p#part_4#sp#part_4sp1
1563 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_1#sp#sub_1.ibd test/table_part_sub_2#p#part_1#sp#sub_1
1564 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_1#sp#sub_2.ibd test/table_part_sub_2#p#part_1#sp#sub_2
1565 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_2#sp#sub_4.ibd test/table_part_sub_2#p#part_2#sp#sub_4
1566 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_3#sp#sub_5.ibd test/table_part_sub_2#p#part_3#sp#sub_5
1567 TABLESPACE NORMAL ./test/table_part_sub_2#p#part_3#sp#sub_6.ibd test/table_part_sub_2#p#part_3#sp#sub_6
1568 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p0.ibd test/table_part_2#p#p0
1569 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p1.ibd test/table_part_2#p#p1
1570 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p2.ibd test/table_part_2#p#p2
1571 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p3.ibd test/table_part_2#p#p3
1572 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p4.ibd test/table_part_2#p#p4
1573 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_sub_2#p#part_2#sp#sub_3.ibd test/table_part_sub_2#p#part_2#sp#sub_3
1574
1575 Checking Innodb stat tables
1576 ---------------------------
1577 select database_name, table_name from mysql.innodb_table_stats
1578 where table_name like '%table_part%' order by database_name, table_name;
1579 database_name table_name
1580 test table_part_1#p#p0
1581 test table_part_1#p#p1
1582 test table_part_1#p#p2
1583 test table_part_1#p#p3
1584 test table_part_1#p#p4
1585 test table_part_2#p#p0
1586 test table_part_2#p#p1
1587 test table_part_2#p#p2
1588 test table_part_2#p#p3
1589 test table_part_2#p#p4
1590 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
1591 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
1592 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
1593 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
1594 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
1595 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
1596 test table_part_cap_6#p#p0
1597 test table_part_cap_6#p#p1
1598 test table_part_cap_6#p#p2
1599 test table_part_cap_6#p#p3
1600 test table_part_cap_6#p#p4
1601 test table_part_nopart_cap_7
1602 test table_part_sub_1#p#part_1#sp#part_1sp0
1603 test table_part_sub_1#p#part_1#sp#part_1sp1
1604 test table_part_sub_1#p#part_2#sp#part_2sp0
1605 test table_part_sub_1#p#part_2#sp#part_2sp1
1606 test table_part_sub_1#p#part_3#sp#part_3sp0
1607 test table_part_sub_1#p#part_3#sp#part_3sp1
1608 test table_part_sub_1#p#part_4#sp#part_4sp0
1609 test table_part_sub_1#p#part_4#sp#part_4sp1
1610 test table_part_sub_2#p#part_1#sp#sub_1
1611 test table_part_sub_2#p#part_1#sp#sub_2
1612 test table_part_sub_2#p#part_2#sp#sub_3
1613 test table_part_sub_2#p#part_2#sp#sub_4
1614 test table_part_sub_2#p#part_3#sp#sub_5
1615 test table_part_sub_2#p#part_3#sp#sub_6
1616
1617 select database_name, table_name, index_name, stat_name from mysql.innodb_index_stats
1618 where table_name like '%table_part%'
1619 order by database_name, table_name, index_name, stat_name;
1620 database_name table_name index_name stat_name
1621 test table_part_1#p#p0 PRIMARY n_diff_pfx01
1622 test table_part_1#p#p0 PRIMARY n_leaf_pages
1623 test table_part_1#p#p0 PRIMARY size
1624 test table_part_1#p#p0 k1 n_diff_pfx01
1625 test table_part_1#p#p0 k1 n_diff_pfx02
1626 test table_part_1#p#p0 k1 n_leaf_pages
1627 test table_part_1#p#p0 k1 size
1628 test table_part_1#p#p1 PRIMARY n_diff_pfx01
1629 test table_part_1#p#p1 PRIMARY n_leaf_pages
1630 test table_part_1#p#p1 PRIMARY size
1631 test table_part_1#p#p1 k1 n_diff_pfx01
1632 test table_part_1#p#p1 k1 n_diff_pfx02
1633 test table_part_1#p#p1 k1 n_leaf_pages
1634 test table_part_1#p#p1 k1 size
1635 test table_part_1#p#p2 PRIMARY n_diff_pfx01
1636 test table_part_1#p#p2 PRIMARY n_leaf_pages
1637 test table_part_1#p#p2 PRIMARY size
1638 test table_part_1#p#p2 k1 n_diff_pfx01
1639 test table_part_1#p#p2 k1 n_diff_pfx02
1640 test table_part_1#p#p2 k1 n_leaf_pages
1641 test table_part_1#p#p2 k1 size
1642 test table_part_1#p#p3 PRIMARY n_diff_pfx01
1643 test table_part_1#p#p3 PRIMARY n_leaf_pages
1644 test table_part_1#p#p3 PRIMARY size
1645 test table_part_1#p#p3 k1 n_diff_pfx01
1646 test table_part_1#p#p3 k1 n_diff_pfx02
1647 test table_part_1#p#p3 k1 n_leaf_pages
1648 test table_part_1#p#p3 k1 size
1649 test table_part_1#p#p4 PRIMARY n_diff_pfx01
1650 test table_part_1#p#p4 PRIMARY n_leaf_pages
1651 test table_part_1#p#p4 PRIMARY size
1652 test table_part_1#p#p4 k1 n_diff_pfx01
1653 test table_part_1#p#p4 k1 n_diff_pfx02
1654 test table_part_1#p#p4 k1 n_leaf_pages
1655 test table_part_1#p#p4 k1 size
1656 test table_part_2#p#p0 PRIMARY n_diff_pfx01
1657 test table_part_2#p#p0 PRIMARY n_leaf_pages
1658 test table_part_2#p#p0 PRIMARY size
1659 test table_part_2#p#p0 k1 n_diff_pfx01
1660 test table_part_2#p#p0 k1 n_diff_pfx02
1661 test table_part_2#p#p0 k1 n_leaf_pages
1662 test table_part_2#p#p0 k1 size
1663 test table_part_2#p#p1 PRIMARY n_diff_pfx01
1664 test table_part_2#p#p1 PRIMARY n_leaf_pages
1665 test table_part_2#p#p1 PRIMARY size
1666 test table_part_2#p#p1 k1 n_diff_pfx01
1667 test table_part_2#p#p1 k1 n_diff_pfx02
1668 test table_part_2#p#p1 k1 n_leaf_pages
1669 test table_part_2#p#p1 k1 size
1670 test table_part_2#p#p2 PRIMARY n_diff_pfx01
1671 test table_part_2#p#p2 PRIMARY n_leaf_pages
1672 test table_part_2#p#p2 PRIMARY size
1673 test table_part_2#p#p2 k1 n_diff_pfx01
1674 test table_part_2#p#p2 k1 n_diff_pfx02
1675 test table_part_2#p#p2 k1 n_leaf_pages
1676 test table_part_2#p#p2 k1 size
1677 test table_part_2#p#p3 PRIMARY n_diff_pfx01
1678 test table_part_2#p#p3 PRIMARY n_leaf_pages
1679 test table_part_2#p#p3 PRIMARY size
1680 test table_part_2#p#p3 k1 n_diff_pfx01
1681 test table_part_2#p#p3 k1 n_diff_pfx02
1682 test table_part_2#p#p3 k1 n_leaf_pages
1683 test table_part_2#p#p3 k1 size
1684 test table_part_2#p#p4 PRIMARY n_diff_pfx01
1685 test table_part_2#p#p4 PRIMARY n_leaf_pages
1686 test table_part_2#p#p4 PRIMARY size
1687 test table_part_2#p#p4 k1 n_diff_pfx01
1688 test table_part_2#p#p4 k1 n_diff_pfx02
1689 test table_part_2#p#p4 k1 n_leaf_pages
1690 test table_part_2#p#p4 k1 size
1691 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx01
1692 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx02
1693 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_leaf_pages
1694 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY size
1695 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx01
1696 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx02
1697 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_leaf_pages
1698 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 size
1699 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx01
1700 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx02
1701 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_leaf_pages
1702 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY size
1703 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx01
1704 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx02
1705 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_leaf_pages
1706 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 size
1707 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx01
1708 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx02
1709 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_leaf_pages
1710 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY size
1711 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx01
1712 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx02
1713 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_leaf_pages
1714 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 size
1715 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx01
1716 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx02
1717 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_leaf_pages
1718 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY size
1719 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx01
1720 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx02
1721 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_leaf_pages
1722 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 size
1723 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx01
1724 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx02
1725 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_leaf_pages
1726 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY size
1727 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx01
1728 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx02
1729 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_leaf_pages
1730 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 size
1731 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx01
1732 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx02
1733 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_leaf_pages
1734 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY size
1735 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx01
1736 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx02
1737 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_leaf_pages
1738 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 size
1739 test table_part_cap_6#p#p0 PRIMARY n_diff_pfx01
1740 test table_part_cap_6#p#p0 PRIMARY n_leaf_pages
1741 test table_part_cap_6#p#p0 PRIMARY size
1742 test table_part_cap_6#p#p0 k1 n_diff_pfx01
1743 test table_part_cap_6#p#p0 k1 n_diff_pfx02
1744 test table_part_cap_6#p#p0 k1 n_leaf_pages
1745 test table_part_cap_6#p#p0 k1 size
1746 test table_part_cap_6#p#p1 PRIMARY n_diff_pfx01
1747 test table_part_cap_6#p#p1 PRIMARY n_leaf_pages
1748 test table_part_cap_6#p#p1 PRIMARY size
1749 test table_part_cap_6#p#p1 k1 n_diff_pfx01
1750 test table_part_cap_6#p#p1 k1 n_diff_pfx02
1751 test table_part_cap_6#p#p1 k1 n_leaf_pages
1752 test table_part_cap_6#p#p1 k1 size
1753 test table_part_cap_6#p#p2 PRIMARY n_diff_pfx01
1754 test table_part_cap_6#p#p2 PRIMARY n_leaf_pages
1755 test table_part_cap_6#p#p2 PRIMARY size
1756 test table_part_cap_6#p#p2 k1 n_diff_pfx01
1757 test table_part_cap_6#p#p2 k1 n_diff_pfx02
1758 test table_part_cap_6#p#p2 k1 n_leaf_pages
1759 test table_part_cap_6#p#p2 k1 size
1760 test table_part_cap_6#p#p3 PRIMARY n_diff_pfx01
1761 test table_part_cap_6#p#p3 PRIMARY n_leaf_pages
1762 test table_part_cap_6#p#p3 PRIMARY size
1763 test table_part_cap_6#p#p3 k1 n_diff_pfx01
1764 test table_part_cap_6#p#p3 k1 n_diff_pfx02
1765 test table_part_cap_6#p#p3 k1 n_leaf_pages
1766 test table_part_cap_6#p#p3 k1 size
1767 test table_part_cap_6#p#p4 PRIMARY n_diff_pfx01
1768 test table_part_cap_6#p#p4 PRIMARY n_leaf_pages
1769 test table_part_cap_6#p#p4 PRIMARY size
1770 test table_part_cap_6#p#p4 k1 n_diff_pfx01
1771 test table_part_cap_6#p#p4 k1 n_diff_pfx02
1772 test table_part_cap_6#p#p4 k1 n_leaf_pages
1773 test table_part_cap_6#p#p4 k1 size
1774 test table_part_nopart_cap_7 PRIMARY n_diff_pfx01
1775 test table_part_nopart_cap_7 PRIMARY n_leaf_pages
1776 test table_part_nopart_cap_7 PRIMARY size
1777 test table_part_nopart_cap_7 k1 n_diff_pfx01
1778 test table_part_nopart_cap_7 k1 n_diff_pfx02
1779 test table_part_nopart_cap_7 k1 n_leaf_pages
1780 test table_part_nopart_cap_7 k1 size
1781 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx01
1782 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx02
1783 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_leaf_pages
1784 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY size
1785 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx01
1786 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx02
1787 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_leaf_pages
1788 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 size
1789 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx01
1790 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx02
1791 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_leaf_pages
1792 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY size
1793 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx01
1794 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx02
1795 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_leaf_pages
1796 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 size
1797 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx01
1798 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx02
1799 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_leaf_pages
1800 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY size
1801 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx01
1802 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx02
1803 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_leaf_pages
1804 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 size
1805 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx01
1806 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx02
1807 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_leaf_pages
1808 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY size
1809 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx01
1810 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx02
1811 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_leaf_pages
1812 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 size
1813 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx01
1814 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx02
1815 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_leaf_pages
1816 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY size
1817 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx01
1818 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx02
1819 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_leaf_pages
1820 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 size
1821 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx01
1822 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx02
1823 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_leaf_pages
1824 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY size
1825 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx01
1826 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx02
1827 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_leaf_pages
1828 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 size
1829 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx01
1830 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx02
1831 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_leaf_pages
1832 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY size
1833 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx01
1834 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx02
1835 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_leaf_pages
1836 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 size
1837 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx01
1838 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx02
1839 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_leaf_pages
1840 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY size
1841 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx01
1842 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx02
1843 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_leaf_pages
1844 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 size
1845 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx01
1846 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx02
1847 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_leaf_pages
1848 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY size
1849 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx01
1850 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx02
1851 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_leaf_pages
1852 test table_part_sub_2#p#part_1#sp#sub_1 k1 size
1853 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx01
1854 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx02
1855 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_leaf_pages
1856 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY size
1857 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx01
1858 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx02
1859 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_leaf_pages
1860 test table_part_sub_2#p#part_1#sp#sub_2 k1 size
1861 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx01
1862 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx02
1863 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_leaf_pages
1864 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY size
1865 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx01
1866 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx02
1867 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_leaf_pages
1868 test table_part_sub_2#p#part_2#sp#sub_3 k1 size
1869 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx01
1870 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx02
1871 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_leaf_pages
1872 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY size
1873 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx01
1874 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx02
1875 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_leaf_pages
1876 test table_part_sub_2#p#part_2#sp#sub_4 k1 size
1877 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx01
1878 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx02
1879 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_leaf_pages
1880 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY size
1881 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx01
1882 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx02
1883 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_leaf_pages
1884 test table_part_sub_2#p#part_3#sp#sub_5 k1 size
1885 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx01
1886 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx02
1887 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_leaf_pages
1888 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY size
1889 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx01
1890 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx02
1891 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_leaf_pages
1892 test table_part_sub_2#p#part_3#sp#sub_6 k1 size
1893 SET NAMES DEFAULT;
1894 # 2. Do DML insert/update/delete on upgraded tables
1895 DML on partitioned tables
1896 -------------------------
1897
1898 insert into table_part_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1899
1900 update table_part_1 set name = 'Row - updated' where value > 500;
1901
1902 delete from table_part_1 where id = 7;
1903
1904 insert into table_part_sub_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1905
1906 update table_part_sub_1 set name = 'Row - updated' where value > 500;
1907
1908 delete from table_part_sub_1 where id = 7;
1909
1910 insert into table_part_sub_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1911
1912 update table_part_sub_2 set name = 'Row - updated' where value > 500;
1913
1914 delete from table_part_sub_2 where id = 7;
1915
1916 insert into `table_part_\_special_/_sub_?_3` values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1917
1918 update `table_part_\_special_/_sub_?_3` set name = 'Row - updated' where value > 500;
1919
1920 delete from `table_part_\_special_/_sub_?_3` where id = 7;
1921
1922 insert into table_part_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1923
1924 update table_part_2 set name = 'Row - updated' where value > 500;
1925
1926 delete from table_part_2 where id = 7;
1927
1928 insert into table_part_CAP_6 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1929
1930 update table_part_CAP_6 set name = 'Row - updated' where value > 500;
1931
1932 delete from table_part_CAP_6 where id = 7;
1933
1934 insert into table_part_NOPART_CAP_7 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1935
1936 update table_part_NOPART_CAP_7 set name = 'Row - updated' where value > 500;
1937
1938 delete from table_part_NOPART_CAP_7 where id = 7;
1939 # 3. Do DDL ALTER/DROP on upgraded tables
1940 DDL on partitioned tables
1941 -------------------------
1942 ALTER TABLE table_part_1 TRUNCATE PARTITION p0;
1943
1944 ALTER TABLE table_part_1 COALESCE PARTITION 2;
1945
1946 SHOW CREATE TABLE table_part_1;
1947 Table Create Table
1948 table_part_1 CREATE TABLE `table_part_1` (
1949 `id` int NOT NULL,
1950 `value` int DEFAULT NULL,
1951 `name` varchar(32) DEFAULT NULL,
1952 `data` blob,
1953 PRIMARY KEY (`id`),
1954 KEY `k1` (`value`)
1955 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1956 /*!50100 PARTITION BY HASH (`id`)
1957 PARTITIONS 3 */
1958
1959 ALTER TABLE table_part_sub_1 TRUNCATE PARTITION part_1;
1960
1961 ALTER TABLE table_part_sub_2 TRUNCATE PARTITION part_3;
1962
1963 CREATE TABLE test_table LIKE table_part_sub_2;
1964
1965 ALTER TABLE test_table REMOVE PARTITIONING;
1966 insert into test_table values(2, 265, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1967
1968 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
1969 id value name
1970 2 255 Row - 2
1971 4 455 Row - 4
1972
1973 SELECT id, value, name FROM test_table order by id;
1974 id value name
1975 2 265 Row - 2
1976
1977 ALTER TABLE table_part_sub_2 EXCHANGE PARTITION sub_3 WITH TABLE test_table;
1978
1979 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
1980 id value name
1981 2 265 Row - 2
1982
1983 SELECT id, value, name FROM test_table order by id;
1984 id value name
1985 2 255 Row - 2
1986 4 455 Row - 4
1987
1988 DROP TABLE test_table;
1989
1990 ALTER TABLE table_part_sub_2 RENAME renamed_table;;
1991 SHOW CREATE TABLE renamed_table;
1992 Table Create Table
1993 renamed_table CREATE TABLE `renamed_table` (
1994 `id` int NOT NULL,
1995 `value` int NOT NULL,
1996 `name` varchar(32) DEFAULT NULL,
1997 `data` blob,
1998 PRIMARY KEY (`id`,`value`),
1999 KEY `k1` (`value`)
2000 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2001 /*!50100 PARTITION BY RANGE (`value`)
2002 SUBPARTITION BY HASH (`id`)
2003 (PARTITION Part_1 VALUES LESS THAN (101)
2004 (SUBPARTITION Sub_1 ENGINE = InnoDB,
2005 SUBPARTITION sUb_2 ENGINE = InnoDB),
2006 PARTITION pArt_2 VALUES LESS THAN (501)
2007 (SUBPARTITION suB_3 ENGINE = InnoDB,
2008 SUBPARTITION SUB_4 ENGINE = InnoDB),
2009 PARTITION PART_3 VALUES LESS THAN MAXVALUE
2010 (SUBPARTITION SUB_5 ENGINE = InnoDB,
2011 SUBPARTITION sub_6 ENGINE = InnoDB)) */
2012
2013 ALTER TABLE renamed_table RENAME table_part_sub_2;;
2014
2015 ALTER TABLE table_part_1 ENGINE = InnoDB;;
2016
2017 ALTER TABLE table_part_1 ADD COLUMN new_id int AFTER id;
2018
2019 ALTER TABLE table_part_1 REMOVE PARTITIONING;
2020
2021 ALTER TABLE table_part_sub_1 ENGINE = InnoDB;;
2022
2023 ALTER TABLE table_part_sub_1 ADD COLUMN new_id int AFTER id;
2024
2025 ALTER TABLE table_part_sub_1 REMOVE PARTITIONING;
2026
2027 ALTER TABLE table_part_sub_2 ENGINE = InnoDB;;
2028
2029 ALTER TABLE table_part_sub_2 ADD COLUMN new_id int AFTER id;
2030
2031 ALTER TABLE table_part_sub_2 REMOVE PARTITIONING;
2032
2033 ALTER TABLE `table_part_\_special_/_sub_?_3` ENGINE = InnoDB;;
2034
2035 ALTER TABLE `table_part_\_special_/_sub_?_3` ADD COLUMN new_id int AFTER id;
2036
2037 ALTER TABLE `table_part_\_special_/_sub_?_3` REMOVE PARTITIONING;
2038
2039 ALTER TABLE table_part_2 ENGINE = InnoDB;;
2040
2041 ALTER TABLE table_part_2 ADD COLUMN new_id int AFTER id;
2042
2043 ALTER TABLE table_part_2 REMOVE PARTITIONING;
2044
2045 ALTER TABLE table_part_CAP_6 ENGINE = InnoDB;;
2046
2047 ALTER TABLE table_part_CAP_6 ADD COLUMN new_id int AFTER id;
2048
2049 ALTER TABLE table_part_CAP_6 REMOVE PARTITIONING;
2050
2051 ALTER TABLE table_part_NOPART_CAP_7 ENGINE = InnoDB;;
2052
2053 ALTER TABLE table_part_NOPART_CAP_7 ADD COLUMN new_id int AFTER id;
2054
2055
2056 # Shutdown server
2057
2058 # Remove upgraded data directory.
2059
2060 # Cleanup: Restart with default options.
2061 # restart