Debian Codegraph @

mysql-test/suite/innodb/r/partition_upgrade_8019_mac_lctn_1_debug.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
827 Checking DD tables
828 ------------------
829 SET DEBUG='+d,skip_dd_table_access_check';
830
831 select t.name as "table", p.name as "partition", p.number
832 from mysql.tables t, mysql.table_partitions p
833 where p.table_id = t.id
834 order by t.name, p.name, p.number;
835 table partition number
836 table_part_1 p0 0
837 table_part_1 p1 1
838 table_part_1 p2 2
839 table_part_1 p3 3
840 table_part_1 p4 4
841 table_part_2 p0 0
842 table_part_2 p1 1
843 table_part_2 p2 2
844 table_part_2 p3 3
845 table_part_2 p4 4
846 table_part_\_special_/_sub_?_3 PART_/_3 2
847 table_part_\_special_/_sub_?_3 Part_?_1 0
848 table_part_\_special_/_sub_?_3 pArt_\_2 1
849 table_part_\_special_/_sub_?_3 sUb_/_2 1
850 table_part_\_special_/_sub_?_3 SUB_?/_5 0
851 table_part_\_special_/_sub_?_3 SUB_?\_4 1
852 table_part_\_special_/_sub_?_3 Sub_?_1 0
853 table_part_\_special_/_sub_?_3 sub_\/?_6 1
854 table_part_\_special_/_sub_?_3 suB_\_3 0
855 table_part_cap_6 p0 0
856 table_part_cap_6 p1 1
857 table_part_cap_6 p2 2
858 table_part_cap_6 p3 3
859 table_part_cap_6 p4 4
860 table_part_sub_1 Part_1 0
861 table_part_sub_1 Part_1sp0 0
862 table_part_sub_1 Part_1sp1 1
863 table_part_sub_1 pArt_2 1
864 table_part_sub_1 pArt_2sp0 0
865 table_part_sub_1 pArt_2sp1 1
866 table_part_sub_1 part_3 2
867 table_part_sub_1 part_3sp0 0
868 table_part_sub_1 part_3sp1 1
869 table_part_sub_1 PART_4 3
870 table_part_sub_1 PART_4sp0 0
871 table_part_sub_1 PART_4sp1 1
872 table_part_sub_2 Part_1 0
873 table_part_sub_2 pArt_2 1
874 table_part_sub_2 PART_3 2
875 table_part_sub_2 Sub_1 0
876 table_part_sub_2 sUb_2 1
877 table_part_sub_2 suB_3 0
878 table_part_sub_2 SUB_4 1
879 table_part_sub_2 SUB_5 0
880 table_part_sub_2 sub_6 1
881
882 select name from mysql.tablespaces
883 where name like '%table_part%' order by name;
884 name
885 test/table_part_1#p#p0
886 test/table_part_1#p#p1
887 test/table_part_1#p#p2
888 test/table_part_1#p#p3
889 test/table_part_1#p#p4
890 test/table_part_2#p#p0
891 test/table_part_2#p#p1
892 test/table_part_2#p#p2
893 test/table_part_2#p#p3
894 test/table_part_2#p#p4
895 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
896 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
897 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
898 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
899 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
900 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
901 test/table_part_cap_6#p#p0
902 test/table_part_cap_6#p#p1
903 test/table_part_cap_6#p#p2
904 test/table_part_cap_6#p#p3
905 test/table_part_cap_6#p#p4
906 test/table_part_sub_1#p#part_1#sp#part_1sp0
907 test/table_part_sub_1#p#part_1#sp#part_1sp1
908 test/table_part_sub_1#p#part_2#sp#part_2sp0
909 test/table_part_sub_1#p#part_2#sp#part_2sp1
910 test/table_part_sub_1#p#part_3#sp#part_3sp0
911 test/table_part_sub_1#p#part_3#sp#part_3sp1
912 test/table_part_sub_1#p#part_4#sp#part_4sp0
913 test/table_part_sub_1#p#part_4#sp#part_4sp1
914 test/table_part_sub_2#p#part_1#sp#sub_1
915 test/table_part_sub_2#p#part_1#sp#sub_2
916 test/table_part_sub_2#p#part_2#sp#sub_3
917 test/table_part_sub_2#p#part_2#sp#sub_4
918 test/table_part_sub_2#p#part_3#sp#sub_5
919 test/table_part_sub_2#p#part_3#sp#sub_6
920
921 select file_name from mysql.tablespace_files
922 where file_name like '%table_part%' order by file_name;
923 file_name
924 ./test/table_part_1#p#p0.ibd
925 ./test/table_part_1#p#p1.ibd
926 ./test/table_part_1#p#p2.ibd
927 ./test/table_part_1#p#p3.ibd
928 ./test/table_part_1#p#p4.ibd
929 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd
930 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd
931 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd
932 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd
933 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd
934 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd
935 ./test/table_part_cap_6#p#p0.ibd
936 ./test/table_part_cap_6#p#p1.ibd
937 ./test/table_part_cap_6#p#p2.ibd
938 ./test/table_part_cap_6#p#p3.ibd
939 ./test/table_part_cap_6#p#p4.ibd
940 ./test/table_part_sub_1#p#part_1#sp#part_1sp0.ibd
941 ./test/table_part_sub_1#p#part_1#sp#part_1sp1.ibd
942 ./test/table_part_sub_1#p#part_2#sp#part_2sp0.ibd
943 ./test/table_part_sub_1#p#part_2#sp#part_2sp1.ibd
944 ./test/table_part_sub_1#p#part_3#sp#part_3sp0.ibd
945 ./test/table_part_sub_1#p#part_3#sp#part_3sp1.ibd
946 ./test/table_part_sub_1#p#part_4#sp#part_4sp0.ibd
947 ./test/table_part_sub_1#p#part_4#sp#part_4sp1.ibd
948 ./test/table_part_sub_2#p#part_1#sp#sub_1.ibd
949 ./test/table_part_sub_2#p#part_1#sp#sub_2.ibd
950 ./test/table_part_sub_2#p#part_2#sp#sub_4.ibd
951 ./test/table_part_sub_2#p#part_3#sp#sub_5.ibd
952 ./test/table_part_sub_2#p#part_3#sp#sub_6.ibd
953 /tmp/mysql_wl13352_data/test/table_part_2#p#p0.ibd
954 /tmp/mysql_wl13352_data/test/table_part_2#p#p1.ibd
955 /tmp/mysql_wl13352_data/test/table_part_2#p#p2.ibd
956 /tmp/mysql_wl13352_data/test/table_part_2#p#p3.ibd
957 /tmp/mysql_wl13352_data/test/table_part_2#p#p4.ibd
958 /tmp/mysql_wl13352_data/test/table_part_sub_2#p#part_2#sp#sub_3.ibd
959 SET DEBUG='-d,skip_dd_table_access_check';
960 SET NAMES DEFAULT;
961 # 2. Do DML insert/update/delete on upgraded tables
962 DML on partitioned tables
963 -------------------------
964
965 insert into table_part_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
966
967 update table_part_1 set name = 'Row - updated' where value > 500;
968
969 delete from table_part_1 where id = 7;
970
971 insert into table_part_sub_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
972
973 update table_part_sub_1 set name = 'Row - updated' where value > 500;
974
975 delete from table_part_sub_1 where id = 7;
976
977 insert into table_part_sub_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
978
979 update table_part_sub_2 set name = 'Row - updated' where value > 500;
980
981 delete from table_part_sub_2 where id = 7;
982
983 insert into `table_part_\_special_/_sub_?_3` values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
984
985 update `table_part_\_special_/_sub_?_3` set name = 'Row - updated' where value > 500;
986
987 delete from `table_part_\_special_/_sub_?_3` where id = 7;
988
989 insert into table_part_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
990
991 update table_part_2 set name = 'Row - updated' where value > 500;
992
993 delete from table_part_2 where id = 7;
994
995 insert into table_part_CAP_6 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
996
997 update table_part_CAP_6 set name = 'Row - updated' where value > 500;
998
999 delete from table_part_CAP_6 where id = 7;
1000
1001 insert into table_part_NOPART_CAP_7 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1002
1003 update table_part_NOPART_CAP_7 set name = 'Row - updated' where value > 500;
1004
1005 delete from table_part_NOPART_CAP_7 where id = 7;
1006 # 3. Do DDL ALTER/DROP on upgraded tables
1007 DDL on partitioned tables
1008 -------------------------
1009 ALTER TABLE table_part_1 TRUNCATE PARTITION p0;
1010
1011 ALTER TABLE table_part_1 COALESCE PARTITION 2;
1012
1013 SHOW CREATE TABLE table_part_1;
1014 Table Create Table
1015 table_part_1 CREATE TABLE `table_part_1` (
1016 `id` int NOT NULL,
1017 `value` int DEFAULT NULL,
1018 `name` varchar(32) DEFAULT NULL,
1019 `data` blob,
1020 PRIMARY KEY (`id`),
1021 KEY `k1` (`value`)
1022 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1023 /*!50100 PARTITION BY HASH (`id`)
1024 PARTITIONS 3 */
1025
1026 ALTER TABLE table_part_sub_1 TRUNCATE PARTITION part_1;
1027
1028 ALTER TABLE table_part_sub_2 TRUNCATE PARTITION part_3;
1029
1030 CREATE TABLE test_table LIKE table_part_sub_2;
1031
1032 ALTER TABLE test_table REMOVE PARTITIONING;
1033 insert into test_table values(2, 265, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1034
1035 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
1036 id value name
1037 2 255 Row - 2
1038 4 455 Row - 4
1039
1040 SELECT id, value, name FROM test_table order by id;
1041 id value name
1042 2 265 Row - 2
1043
1044 ALTER TABLE table_part_sub_2 EXCHANGE PARTITION sub_3 WITH TABLE test_table;
1045
1046 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
1047 id value name
1048 2 265 Row - 2
1049
1050 SELECT id, value, name FROM test_table order by id;
1051 id value name
1052 2 255 Row - 2
1053 4 455 Row - 4
1054
1055 DROP TABLE test_table;
1056
1057 ALTER TABLE table_part_sub_2 RENAME renamed_table;;
1058 SHOW CREATE TABLE renamed_table;
1059 Table Create Table
1060 renamed_table CREATE TABLE `renamed_table` (
1061 `id` int NOT NULL,
1062 `value` int NOT NULL,
1063 `name` varchar(32) DEFAULT NULL,
1064 `data` blob,
1065 PRIMARY KEY (`id`,`value`),
1066 KEY `k1` (`value`)
1067 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1068 /*!50100 PARTITION BY RANGE (`value`)
1069 SUBPARTITION BY HASH (`id`)
1070 (PARTITION Part_1 VALUES LESS THAN (101)
1071 (SUBPARTITION Sub_1 ENGINE = InnoDB,
1072 SUBPARTITION sUb_2 ENGINE = InnoDB),
1073 PARTITION pArt_2 VALUES LESS THAN (501)
1074 (SUBPARTITION suB_3 ENGINE = InnoDB,
1075 SUBPARTITION SUB_4 ENGINE = InnoDB),
1076 PARTITION PART_3 VALUES LESS THAN MAXVALUE
1077 (SUBPARTITION SUB_5 ENGINE = InnoDB,
1078 SUBPARTITION sub_6 ENGINE = InnoDB)) */
1079
1080 ALTER TABLE renamed_table RENAME table_part_sub_2;;
1081
1082 ALTER TABLE table_part_1 ENGINE = InnoDB;;
1083
1084 ALTER TABLE table_part_1 ADD COLUMN new_id int AFTER id;
1085
1086 ALTER TABLE table_part_1 REMOVE PARTITIONING;
1087
1088 ALTER TABLE table_part_sub_1 ENGINE = InnoDB;;
1089
1090 ALTER TABLE table_part_sub_1 ADD COLUMN new_id int AFTER id;
1091
1092 ALTER TABLE table_part_sub_1 REMOVE PARTITIONING;
1093
1094 ALTER TABLE table_part_sub_2 ENGINE = InnoDB;;
1095
1096 ALTER TABLE table_part_sub_2 ADD COLUMN new_id int AFTER id;
1097
1098 ALTER TABLE table_part_sub_2 REMOVE PARTITIONING;
1099
1100 ALTER TABLE `table_part_\_special_/_sub_?_3` ENGINE = InnoDB;;
1101
1102 ALTER TABLE `table_part_\_special_/_sub_?_3` ADD COLUMN new_id int AFTER id;
1103
1104 ALTER TABLE `table_part_\_special_/_sub_?_3` REMOVE PARTITIONING;
1105
1106 ALTER TABLE table_part_2 ENGINE = InnoDB;;
1107
1108 ALTER TABLE table_part_2 ADD COLUMN new_id int AFTER id;
1109
1110 ALTER TABLE table_part_2 REMOVE PARTITIONING;
1111
1112 ALTER TABLE table_part_CAP_6 ENGINE = InnoDB;;
1113
1114 ALTER TABLE table_part_CAP_6 ADD COLUMN new_id int AFTER id;
1115
1116 ALTER TABLE table_part_CAP_6 REMOVE PARTITIONING;
1117
1118 ALTER TABLE table_part_NOPART_CAP_7 ENGINE = InnoDB;;
1119
1120 ALTER TABLE table_part_NOPART_CAP_7 ADD COLUMN new_id int AFTER id;
1121
1122
1123 # B. Create all the tables again and validate
1124 Dropping partitioned tables
1125 ---------------------------
1126 DROP TABLE table_part_1;
1127 DROP TABLE table_part_sub_1;
1128 DROP TABLE table_part_sub_2;
1129 DROP TABLE `table_part_\_special_/_sub_?_3`;
1130 DROP TABLE table_part_2;
1131 DROP TABLE table_part_CAP_6;
1132 DROP TABLE table_part_NOPART_CAP_7;
1133 DROP TABLESPACE SPACE_part;
1134 Creating partitioned tables
1135 ---------------------------
1136 CREATE TABLE table_part_1(
1137 id int primary key, value int, name varchar(32), data BLOB,
1138 key k1(value)) partition by hash (id) partitions 5;
1139
1140 CREATE TABLE table_part_2(
1141 id int primary key, value int, name varchar(32), data BLOB,
1142 key k1(value)) DATA DIRECTORY = '/tmp/mysql_wl13352_data/'
1143 partition by hash (id) partitions 5;
1144
1145 CREATE TABLE table_part_sub_1(
1146 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
1147 key k1(value)) partition by range (value) subpartition by hash (id)
1148 subpartitions 2 ( partition Part_1 values less than (101),
1149 partition pArt_2 values less than (401),
1150 partition part_3 values less than (701),
1151 partition PART_4 values less than MAXVALUE);
1152
1153 CREATE TABLE table_part_sub_2(
1154 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
1155 key k1(value)) partition by range (value) subpartition by hash (id)
1156 ( partition Part_1 values less than (101)(
1157 subpartition Sub_1,
1158 subpartition sUb_2),
1159 partition pArt_2 values less than (501)(
1160 subpartition suB_3 DATA DIRECTORY = '/tmp/mysql_wl13352_data/',
1161 subpartition SUB_4),
1162 partition PART_3 values less than MAXVALUE(
1163 subpartition SUB_5,
1164 subpartition sub_6));
1165
1166 CREATE TABLE `table_part_\_special_/_sub_?_3`(
1167 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
1168 key k1(value)) partition by range (value) subpartition by hash (id)
1169 ( partition `Part_?_1` values less than (201)(
1170 subpartition `Sub_?_1`,
1171 subpartition `sUb_/_2`),
1172 partition `pArt_\_2` values less than (501)(
1173 subpartition `suB_\_3`,
1174 subpartition `SUB_?\_4`),
1175 partition `PART_/_3` values less than MAXVALUE(
1176 subpartition `SUB_?/_5`,
1177 subpartition `sub_\/?_6`));
1178 CREATE TABLESPACE SPACE_part add datafile 'SPACE_part_1.ibd';
1179 CREATE TABLE table_part_CAP_6(
1180 id int primary key, value int, name varchar(32), data BLOB,
1181 key k1(value)) partition by hash (id) partitions 5;
1182 CREATE TABLE table_part_NOPART_CAP_7(
1183 id int primary key, value int, name varchar(32), data BLOB,
1184 key k1(value)) TABLESPACE SPACE_part;
1185
1186 Inserting 10 rows to table_part_1
1187 ---------------------------------------
1188 insert into table_part_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1189 insert into table_part_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1190 insert into table_part_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1191 insert into table_part_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1192 insert into table_part_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1193 insert into table_part_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1194 insert into table_part_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1195 insert into table_part_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1196 insert into table_part_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1197 insert into table_part_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1198
1199 Inserting 10 rows to table_part_sub_1
1200 ---------------------------------------
1201 insert into table_part_sub_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1202 insert into table_part_sub_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1203 insert into table_part_sub_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1204 insert into table_part_sub_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1205 insert into table_part_sub_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1206 insert into table_part_sub_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1207 insert into table_part_sub_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1208 insert into table_part_sub_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1209 insert into table_part_sub_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1210 insert into table_part_sub_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1211
1212 Inserting 10 rows to table_part_sub_2
1213 ---------------------------------------
1214 insert into table_part_sub_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1215 insert into table_part_sub_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1216 insert into table_part_sub_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1217 insert into table_part_sub_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1218 insert into table_part_sub_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1219 insert into table_part_sub_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1220 insert into table_part_sub_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1221 insert into table_part_sub_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1222 insert into table_part_sub_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1223 insert into table_part_sub_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1224
1225 Inserting 10 rows to `table_part_\_special_/_sub_?_3`
1226 ---------------------------------------
1227 insert into `table_part_\_special_/_sub_?_3` VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1228 insert into `table_part_\_special_/_sub_?_3` VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1229 insert into `table_part_\_special_/_sub_?_3` VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1230 insert into `table_part_\_special_/_sub_?_3` VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1231 insert into `table_part_\_special_/_sub_?_3` VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1232 insert into `table_part_\_special_/_sub_?_3` VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1233 insert into `table_part_\_special_/_sub_?_3` VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1234 insert into `table_part_\_special_/_sub_?_3` VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1235 insert into `table_part_\_special_/_sub_?_3` VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1236 insert into `table_part_\_special_/_sub_?_3` VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1237
1238 Inserting 10 rows to table_part_2
1239 ---------------------------------------
1240 insert into table_part_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1241 insert into table_part_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1242 insert into table_part_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1243 insert into table_part_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1244 insert into table_part_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1245 insert into table_part_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1246 insert into table_part_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1247 insert into table_part_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1248 insert into table_part_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1249 insert into table_part_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1250
1251 Inserting 10 rows to table_part_CAP_6
1252 ---------------------------------------
1253 insert into table_part_CAP_6 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1254 insert into table_part_CAP_6 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1255 insert into table_part_CAP_6 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1256 insert into table_part_CAP_6 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1257 insert into table_part_CAP_6 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1258 insert into table_part_CAP_6 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1259 insert into table_part_CAP_6 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1260 insert into table_part_CAP_6 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1261 insert into table_part_CAP_6 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1262 insert into table_part_CAP_6 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1263
1264 Inserting 10 rows to table_part_NOPART_CAP_7
1265 ---------------------------------------
1266 insert into table_part_NOPART_CAP_7 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1267 insert into table_part_NOPART_CAP_7 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1268 insert into table_part_NOPART_CAP_7 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1269 insert into table_part_NOPART_CAP_7 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1270 insert into table_part_NOPART_CAP_7 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1271 insert into table_part_NOPART_CAP_7 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1272 insert into table_part_NOPART_CAP_7 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1273 insert into table_part_NOPART_CAP_7 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1274 insert into table_part_NOPART_CAP_7 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1275 insert into table_part_NOPART_CAP_7 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1276 select id, value, name from table_part_sub_2 partition (sub_1) order by id;
1277 id value name
1278 0 55 Row - 0
1279 select id, value, name from table_part_sub_2 partition (sub_2) order by id;
1280 id value name
1281 select id, value, name from table_part_sub_2 partition (sub_3) order by id;
1282 id value name
1283 2 255 Row - 2
1284 4 455 Row - 4
1285 select id, value, name from table_part_sub_2 partition (sub_4) order by id;
1286 id value name
1287 1 155 Row - 1
1288 3 355 Row - 3
1289 select id, value, name from table_part_sub_2 partition (sub_5) order by id;
1290 id value name
1291 6 655 Row - 6
1292 8 855 Row - 8
1293 select id, value, name from table_part_sub_2 partition (sub_6) order by id;
1294 id value name
1295 5 555 Row - 5
1296 7 755 Row - 7
1297 9 955 Row - 9
1298
1299 # 1. Check table metadata and data
1300 Checking partitioned tables
1301 ---------------------------
1302 SET NAMES utf8mb4 COLLATE utf8mb4_0900_as_cs;
1303
1304 CHECK TABLE table_part_1;
1305 Table Op Msg_type Msg_text
1306 test.table_part_1 check status OK
1307
1308 SHOW CREATE TABLE table_part_1;
1309 Table Create Table
1310 table_part_1 CREATE TABLE `table_part_1` (
1311 `id` int NOT NULL,
1312 `value` int DEFAULT NULL,
1313 `name` varchar(32) DEFAULT NULL,
1314 `data` blob,
1315 PRIMARY KEY (`id`),
1316 KEY `k1` (`value`)
1317 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1318 /*!50100 PARTITION BY HASH (`id`)
1319 PARTITIONS 5 */
1320
1321 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_1 order by id;
1322 id value name SUBSTRING(data, 1024, 32)
1323 0 55 Row - 0 ta - 0Large Column Data - 0Large
1324 1 155 Row - 1 ta - 1Large Column Data - 1Large
1325 2 255 Row - 2 ta - 2Large Column Data - 2Large
1326 3 355 Row - 3 ta - 3Large Column Data - 3Large
1327 4 455 Row - 4 ta - 4Large Column Data - 4Large
1328 5 555 Row - 5 ta - 5Large Column Data - 5Large
1329 6 655 Row - 6 ta - 6Large Column Data - 6Large
1330 7 755 Row - 7 ta - 7Large Column Data - 7Large
1331 8 855 Row - 8 ta - 8Large Column Data - 8Large
1332 9 955 Row - 9 ta - 9Large Column Data - 9Large
1333
1334 CHECK TABLE table_part_sub_1;
1335 Table Op Msg_type Msg_text
1336 test.table_part_sub_1 check status OK
1337
1338 SHOW CREATE TABLE table_part_sub_1;
1339 Table Create Table
1340 table_part_sub_1 CREATE TABLE `table_part_sub_1` (
1341 `id` int NOT NULL,
1342 `value` int NOT NULL,
1343 `name` varchar(32) DEFAULT NULL,
1344 `data` blob,
1345 PRIMARY KEY (`id`,`value`),
1346 KEY `k1` (`value`)
1347 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1348 /*!50100 PARTITION BY RANGE (`value`)
1349 SUBPARTITION BY HASH (`id`)
1350 SUBPARTITIONS 2
1351 (PARTITION Part_1 VALUES LESS THAN (101) ENGINE = InnoDB,
1352 PARTITION pArt_2 VALUES LESS THAN (401) ENGINE = InnoDB,
1353 PARTITION part_3 VALUES LESS THAN (701) ENGINE = InnoDB,
1354 PARTITION PART_4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
1355
1356 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_1 order by id;
1357 id value name SUBSTRING(data, 1024, 32)
1358 0 55 Row - 0 ta - 0Large Column Data - 0Large
1359 1 155 Row - 1 ta - 1Large Column Data - 1Large
1360 2 255 Row - 2 ta - 2Large Column Data - 2Large
1361 3 355 Row - 3 ta - 3Large Column Data - 3Large
1362 4 455 Row - 4 ta - 4Large Column Data - 4Large
1363 5 555 Row - 5 ta - 5Large Column Data - 5Large
1364 6 655 Row - 6 ta - 6Large Column Data - 6Large
1365 7 755 Row - 7 ta - 7Large Column Data - 7Large
1366 8 855 Row - 8 ta - 8Large Column Data - 8Large
1367 9 955 Row - 9 ta - 9Large Column Data - 9Large
1368
1369 CHECK TABLE table_part_sub_2;
1370 Table Op Msg_type Msg_text
1371 test.table_part_sub_2 check status OK
1372
1373 SHOW CREATE TABLE table_part_sub_2;
1374 Table Create Table
1375 table_part_sub_2 CREATE TABLE `table_part_sub_2` (
1376 `id` int NOT NULL,
1377 `value` int NOT NULL,
1378 `name` varchar(32) DEFAULT NULL,
1379 `data` blob,
1380 PRIMARY KEY (`id`,`value`),
1381 KEY `k1` (`value`)
1382 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1383 /*!50100 PARTITION BY RANGE (`value`)
1384 SUBPARTITION BY HASH (`id`)
1385 (PARTITION Part_1 VALUES LESS THAN (101)
1386 (SUBPARTITION Sub_1 ENGINE = InnoDB,
1387 SUBPARTITION sUb_2 ENGINE = InnoDB),
1388 PARTITION pArt_2 VALUES LESS THAN (501)
1389 (SUBPARTITION suB_3 DATA DIRECTORY = '/tmp/mysql_wl13352_data/' ENGINE = InnoDB,
1390 SUBPARTITION SUB_4 ENGINE = InnoDB),
1391 PARTITION PART_3 VALUES LESS THAN MAXVALUE
1392 (SUBPARTITION SUB_5 ENGINE = InnoDB,
1393 SUBPARTITION sub_6 ENGINE = InnoDB)) */
1394
1395 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_2 order by id;
1396 id value name SUBSTRING(data, 1024, 32)
1397 0 55 Row - 0 ta - 0Large Column Data - 0Large
1398 1 155 Row - 1 ta - 1Large Column Data - 1Large
1399 2 255 Row - 2 ta - 2Large Column Data - 2Large
1400 3 355 Row - 3 ta - 3Large Column Data - 3Large
1401 4 455 Row - 4 ta - 4Large Column Data - 4Large
1402 5 555 Row - 5 ta - 5Large Column Data - 5Large
1403 6 655 Row - 6 ta - 6Large Column Data - 6Large
1404 7 755 Row - 7 ta - 7Large Column Data - 7Large
1405 8 855 Row - 8 ta - 8Large Column Data - 8Large
1406 9 955 Row - 9 ta - 9Large Column Data - 9Large
1407
1408 CHECK TABLE `table_part_\_special_/_sub_?_3`;
1409 Table Op Msg_type Msg_text
1410 test.table_part_\_special_/_sub_?_3 check status OK
1411
1412 SHOW CREATE TABLE `table_part_\_special_/_sub_?_3`;
1413 Table Create Table
1414 table_part_\_special_/_sub_?_3 CREATE TABLE `table_part_\_special_/_sub_?_3` (
1415 `id` int NOT NULL,
1416 `value` int NOT NULL,
1417 `name` varchar(32) DEFAULT NULL,
1418 `data` blob,
1419 PRIMARY KEY (`id`,`value`),
1420 KEY `k1` (`value`)
1421 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1422 /*!50100 PARTITION BY RANGE (`value`)
1423 SUBPARTITION BY HASH (`id`)
1424 (PARTITION `Part_?_1` VALUES LESS THAN (201)
1425 (SUBPARTITION `Sub_?_1` ENGINE = InnoDB,
1426 SUBPARTITION `sUb_/_2` ENGINE = InnoDB),
1427 PARTITION `pArt_\_2` VALUES LESS THAN (501)
1428 (SUBPARTITION `suB_\_3` ENGINE = InnoDB,
1429 SUBPARTITION `SUB_?\_4` ENGINE = InnoDB),
1430 PARTITION `PART_/_3` VALUES LESS THAN MAXVALUE
1431 (SUBPARTITION `SUB_?/_5` ENGINE = InnoDB,
1432 SUBPARTITION `sub_\/?_6` ENGINE = InnoDB)) */
1433
1434 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM `table_part_\_special_/_sub_?_3` order by id;
1435 id value name SUBSTRING(data, 1024, 32)
1436 0 55 Row - 0 ta - 0Large Column Data - 0Large
1437 1 155 Row - 1 ta - 1Large Column Data - 1Large
1438 2 255 Row - 2 ta - 2Large Column Data - 2Large
1439 3 355 Row - 3 ta - 3Large Column Data - 3Large
1440 4 455 Row - 4 ta - 4Large Column Data - 4Large
1441 5 555 Row - 5 ta - 5Large Column Data - 5Large
1442 6 655 Row - 6 ta - 6Large Column Data - 6Large
1443 7 755 Row - 7 ta - 7Large Column Data - 7Large
1444 8 855 Row - 8 ta - 8Large Column Data - 8Large
1445 9 955 Row - 9 ta - 9Large Column Data - 9Large
1446
1447 CHECK TABLE table_part_2;
1448 Table Op Msg_type Msg_text
1449 test.table_part_2 check status OK
1450
1451 SHOW CREATE TABLE table_part_2;
1452 Table Create Table
1453 table_part_2 CREATE TABLE `table_part_2` (
1454 `id` int NOT NULL,
1455 `value` int DEFAULT NULL,
1456 `name` varchar(32) DEFAULT NULL,
1457 `data` blob,
1458 PRIMARY KEY (`id`),
1459 KEY `k1` (`value`)
1460 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1461 /*!50100 PARTITION BY HASH (`id`)
1462 PARTITIONS 5 */
1463
1464 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_2 order by id;
1465 id value name SUBSTRING(data, 1024, 32)
1466 0 55 Row - 0 ta - 0Large Column Data - 0Large
1467 1 155 Row - 1 ta - 1Large Column Data - 1Large
1468 2 255 Row - 2 ta - 2Large Column Data - 2Large
1469 3 355 Row - 3 ta - 3Large Column Data - 3Large
1470 4 455 Row - 4 ta - 4Large Column Data - 4Large
1471 5 555 Row - 5 ta - 5Large Column Data - 5Large
1472 6 655 Row - 6 ta - 6Large Column Data - 6Large
1473 7 755 Row - 7 ta - 7Large Column Data - 7Large
1474 8 855 Row - 8 ta - 8Large Column Data - 8Large
1475 9 955 Row - 9 ta - 9Large Column Data - 9Large
1476
1477 CHECK TABLE table_part_CAP_6;
1478 Table Op Msg_type Msg_text
1479 test.table_part_cap_6 check status OK
1480
1481 SHOW CREATE TABLE table_part_CAP_6;
1482 Table Create Table
1483 table_part_CAP_6 CREATE TABLE `table_part_cap_6` (
1484 `id` int NOT NULL,
1485 `value` int DEFAULT NULL,
1486 `name` varchar(32) DEFAULT NULL,
1487 `data` blob,
1488 PRIMARY KEY (`id`),
1489 KEY `k1` (`value`)
1490 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1491 /*!50100 PARTITION BY HASH (`id`)
1492 PARTITIONS 5 */
1493
1494 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_CAP_6 order by id;
1495 id value name SUBSTRING(data, 1024, 32)
1496 0 55 Row - 0 ta - 0Large Column Data - 0Large
1497 1 155 Row - 1 ta - 1Large Column Data - 1Large
1498 2 255 Row - 2 ta - 2Large Column Data - 2Large
1499 3 355 Row - 3 ta - 3Large Column Data - 3Large
1500 4 455 Row - 4 ta - 4Large Column Data - 4Large
1501 5 555 Row - 5 ta - 5Large Column Data - 5Large
1502 6 655 Row - 6 ta - 6Large Column Data - 6Large
1503 7 755 Row - 7 ta - 7Large Column Data - 7Large
1504 8 855 Row - 8 ta - 8Large Column Data - 8Large
1505 9 955 Row - 9 ta - 9Large Column Data - 9Large
1506
1507 CHECK TABLE table_part_NOPART_CAP_7;
1508 Table Op Msg_type Msg_text
1509 test.table_part_nopart_cap_7 check status OK
1510
1511 SHOW CREATE TABLE table_part_NOPART_CAP_7;
1512 Table Create Table
1513 table_part_NOPART_CAP_7 CREATE TABLE `table_part_nopart_cap_7` (
1514 `id` int NOT NULL,
1515 `value` int DEFAULT NULL,
1516 `name` varchar(32) DEFAULT NULL,
1517 `data` blob,
1518 PRIMARY KEY (`id`),
1519 KEY `k1` (`value`)
1520 ) /*!50100 TABLESPACE `SPACE_part` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1521
1522 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_NOPART_CAP_7 order by id;
1523 id value name SUBSTRING(data, 1024, 32)
1524 0 55 Row - 0 ta - 0Large Column Data - 0Large
1525 1 155 Row - 1 ta - 1Large Column Data - 1Large
1526 2 255 Row - 2 ta - 2Large Column Data - 2Large
1527 3 355 Row - 3 ta - 3Large Column Data - 3Large
1528 4 455 Row - 4 ta - 4Large Column Data - 4Large
1529 5 555 Row - 5 ta - 5Large Column Data - 5Large
1530 6 655 Row - 6 ta - 6Large Column Data - 6Large
1531 7 755 Row - 7 ta - 7Large Column Data - 7Large
1532 8 855 Row - 8 ta - 8Large Column Data - 8Large
1533 9 955 Row - 9 ta - 9Large Column Data - 9Large
1534
1535 Checking IFS views
1536 ------------------
1537 select table_schema, table_name from information_schema.tables
1538 where table_name LIKE '%table_part%' order by table_schema, table_name;
1539 TABLE_SCHEMA TABLE_NAME
1540 test table_part_1
1541 test table_part_2
1542 test table_part_\_special_/_sub_?_3
1543 test table_part_cap_6
1544 test table_part_nopart_cap_7
1545 test table_part_sub_1
1546 test table_part_sub_2
1547
1548 select name, space_type from information_schema.innodb_tables
1549 where name LIKE '%table_part%' order by name, space_type;
1550 name space_type
1551 test/table_part_1#p#p0 Single
1552 test/table_part_1#p#p1 Single
1553 test/table_part_1#p#p2 Single
1554 test/table_part_1#p#p3 Single
1555 test/table_part_1#p#p4 Single
1556 test/table_part_2#p#p0 Single
1557 test/table_part_2#p#p1 Single
1558 test/table_part_2#p#p2 Single
1559 test/table_part_2#p#p3 Single
1560 test/table_part_2#p#p4 Single
1561 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5 Single
1562 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6 Single
1563 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2 Single
1564 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1 Single
1565 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4 Single
1566 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3 Single
1567 test/table_part_cap_6#p#p0 Single
1568 test/table_part_cap_6#p#p1 Single
1569 test/table_part_cap_6#p#p2 Single
1570 test/table_part_cap_6#p#p3 Single
1571 test/table_part_cap_6#p#p4 Single
1572 test/table_part_nopart_cap_7 General
1573 test/table_part_sub_1#p#part_1#sp#part_1sp0 Single
1574 test/table_part_sub_1#p#part_1#sp#part_1sp1 Single
1575 test/table_part_sub_1#p#part_2#sp#part_2sp0 Single
1576 test/table_part_sub_1#p#part_2#sp#part_2sp1 Single
1577 test/table_part_sub_1#p#part_3#sp#part_3sp0 Single
1578 test/table_part_sub_1#p#part_3#sp#part_3sp1 Single
1579 test/table_part_sub_1#p#part_4#sp#part_4sp0 Single
1580 test/table_part_sub_1#p#part_4#sp#part_4sp1 Single
1581 test/table_part_sub_2#p#part_1#sp#sub_1 Single
1582 test/table_part_sub_2#p#part_1#sp#sub_2 Single
1583 test/table_part_sub_2#p#part_2#sp#sub_3 Single
1584 test/table_part_sub_2#p#part_2#sp#sub_4 Single
1585 test/table_part_sub_2#p#part_3#sp#sub_5 Single
1586 test/table_part_sub_2#p#part_3#sp#sub_6 Single
1587
1588 select table_schema, table_name, partition_name, subpartition_name
1589 from information_schema.partitions
1590 where table_name LIKE '%table_part%'
1591 order by table_schema, table_name, partition_name, subpartition_name;
1592 TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME
1593 test table_part_1 p0 NULL
1594 test table_part_1 p1 NULL
1595 test table_part_1 p2 NULL
1596 test table_part_1 p3 NULL
1597 test table_part_1 p4 NULL
1598 test table_part_2 p0 NULL
1599 test table_part_2 p1 NULL
1600 test table_part_2 p2 NULL
1601 test table_part_2 p3 NULL
1602 test table_part_2 p4 NULL
1603 test table_part_\_special_/_sub_?_3 PART_/_3 SUB_?/_5
1604 test table_part_\_special_/_sub_?_3 PART_/_3 sub_\/?_6
1605 test table_part_\_special_/_sub_?_3 Part_?_1 sUb_/_2
1606 test table_part_\_special_/_sub_?_3 Part_?_1 Sub_?_1
1607 test table_part_\_special_/_sub_?_3 pArt_\_2 SUB_?\_4
1608 test table_part_\_special_/_sub_?_3 pArt_\_2 suB_\_3
1609 test table_part_cap_6 p0 NULL
1610 test table_part_cap_6 p1 NULL
1611 test table_part_cap_6 p2 NULL
1612 test table_part_cap_6 p3 NULL
1613 test table_part_cap_6 p4 NULL
1614 test table_part_nopart_cap_7 NULL NULL
1615 test table_part_sub_1 Part_1 Part_1sp0
1616 test table_part_sub_1 Part_1 Part_1sp1
1617 test table_part_sub_1 pArt_2 pArt_2sp0
1618 test table_part_sub_1 pArt_2 pArt_2sp1
1619 test table_part_sub_1 part_3 part_3sp0
1620 test table_part_sub_1 part_3 part_3sp1
1621 test table_part_sub_1 PART_4 PART_4sp0
1622 test table_part_sub_1 PART_4 PART_4sp1
1623 test table_part_sub_2 Part_1 Sub_1
1624 test table_part_sub_2 Part_1 sUb_2
1625 test table_part_sub_2 pArt_2 suB_3
1626 test table_part_sub_2 pArt_2 SUB_4
1627 test table_part_sub_2 PART_3 SUB_5
1628 test table_part_sub_2 PART_3 sub_6
1629
1630 select name from information_schema.innodb_tablespaces
1631 where name LIKE '%table_part%' order by name;
1632 name
1633 test/table_part_1#p#p0
1634 test/table_part_1#p#p1
1635 test/table_part_1#p#p2
1636 test/table_part_1#p#p3
1637 test/table_part_1#p#p4
1638 test/table_part_2#p#p0
1639 test/table_part_2#p#p1
1640 test/table_part_2#p#p2
1641 test/table_part_2#p#p3
1642 test/table_part_2#p#p4
1643 test/table_part_cap_6#p#p0
1644 test/table_part_cap_6#p#p1
1645 test/table_part_cap_6#p#p2
1646 test/table_part_cap_6#p#p3
1647 test/table_part_cap_6#p#p4
1648 test/table_part_sub_1#p#part_1#sp#part_1sp0
1649 test/table_part_sub_1#p#part_1#sp#part_1sp1
1650 test/table_part_sub_1#p#part_2#sp#part_2sp0
1651 test/table_part_sub_1#p#part_2#sp#part_2sp1
1652 test/table_part_sub_1#p#part_3#sp#part_3sp0
1653 test/table_part_sub_1#p#part_3#sp#part_3sp1
1654 test/table_part_sub_1#p#part_4#sp#part_4sp0
1655 test/table_part_sub_1#p#part_4#sp#part_4sp1
1656 test/table_part_sub_2#p#part_1#sp#sub_1
1657 test/table_part_sub_2#p#part_1#sp#sub_2
1658 test/table_part_sub_2#p#part_2#sp#sub_3
1659 test/table_part_sub_2#p#part_2#sp#sub_4
1660 test/table_part_sub_2#p#part_3#sp#sub_5
1661 test/table_part_sub_2#p#part_3#sp#sub_6
1662 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
1663 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
1664 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
1665 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
1666 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
1667 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
1668
1669 select file_type, status, file_name, tablespace_name from information_schema.files
1670 where file_name LIKE '%table_part%'
1671 order by file_type, status, file_name, tablespace_name;
1672 FILE_TYPE STATUS FILE_NAME TABLESPACE_NAME
1673 TABLESPACE NORMAL ./test/table_part_1#p#p0.ibd test/table_part_1#p#p0
1674 TABLESPACE NORMAL ./test/table_part_1#p#p1.ibd test/table_part_1#p#p1
1675 TABLESPACE NORMAL ./test/table_part_1#p#p2.ibd test/table_part_1#p#p2
1676 TABLESPACE NORMAL ./test/table_part_1#p#p3.ibd test/table_part_1#p#p3
1677 TABLESPACE NORMAL ./test/table_part_1#p#p4.ibd test/table_part_1#p#p4
1678 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
1679 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
1680 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
1681 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
1682 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
1683 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
1684 TABLESPACE NORMAL ./test/table_part_cap_6#p#p0.ibd test/table_part_cap_6#p#p0
1685 TABLESPACE NORMAL ./test/table_part_cap_6#p#p1.ibd test/table_part_cap_6#p#p1
1686 TABLESPACE NORMAL ./test/table_part_cap_6#p#p2.ibd test/table_part_cap_6#p#p2
1687 TABLESPACE NORMAL ./test/table_part_cap_6#p#p3.ibd test/table_part_cap_6#p#p3
1688 TABLESPACE NORMAL ./test/table_part_cap_6#p#p4.ibd test/table_part_cap_6#p#p4
1689 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
1690 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
1691 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
1692 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
1693 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
1694 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
1695 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
1696 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
1697 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
1698 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
1699 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
1700 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
1701 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
1702 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p0.ibd test/table_part_2#p#p0
1703 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p1.ibd test/table_part_2#p#p1
1704 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p2.ibd test/table_part_2#p#p2
1705 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p3.ibd test/table_part_2#p#p3
1706 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p4.ibd test/table_part_2#p#p4
1707 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
1708
1709 Checking Innodb stat tables
1710 ---------------------------
1711 select database_name, table_name from mysql.innodb_table_stats
1712 where table_name like '%table_part%' order by database_name, table_name;
1713 database_name table_name
1714 test table_part_1#p#p0
1715 test table_part_1#p#p1
1716 test table_part_1#p#p2
1717 test table_part_1#p#p3
1718 test table_part_1#p#p4
1719 test table_part_2#p#p0
1720 test table_part_2#p#p1
1721 test table_part_2#p#p2
1722 test table_part_2#p#p3
1723 test table_part_2#p#p4
1724 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
1725 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
1726 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
1727 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
1728 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
1729 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
1730 test table_part_cap_6#p#p0
1731 test table_part_cap_6#p#p1
1732 test table_part_cap_6#p#p2
1733 test table_part_cap_6#p#p3
1734 test table_part_cap_6#p#p4
1735 test table_part_nopart_cap_7
1736 test table_part_sub_1#p#part_1#sp#part_1sp0
1737 test table_part_sub_1#p#part_1#sp#part_1sp1
1738 test table_part_sub_1#p#part_2#sp#part_2sp0
1739 test table_part_sub_1#p#part_2#sp#part_2sp1
1740 test table_part_sub_1#p#part_3#sp#part_3sp0
1741 test table_part_sub_1#p#part_3#sp#part_3sp1
1742 test table_part_sub_1#p#part_4#sp#part_4sp0
1743 test table_part_sub_1#p#part_4#sp#part_4sp1
1744 test table_part_sub_2#p#part_1#sp#sub_1
1745 test table_part_sub_2#p#part_1#sp#sub_2
1746 test table_part_sub_2#p#part_2#sp#sub_3
1747 test table_part_sub_2#p#part_2#sp#sub_4
1748 test table_part_sub_2#p#part_3#sp#sub_5
1749 test table_part_sub_2#p#part_3#sp#sub_6
1750
1751 select database_name, table_name, index_name, stat_name from mysql.innodb_index_stats
1752 where table_name like '%table_part%'
1753 order by database_name, table_name, index_name, stat_name;
1754 database_name table_name index_name stat_name
1755 test table_part_1#p#p0 PRIMARY n_diff_pfx01
1756 test table_part_1#p#p0 PRIMARY n_leaf_pages
1757 test table_part_1#p#p0 PRIMARY size
1758 test table_part_1#p#p0 k1 n_diff_pfx01
1759 test table_part_1#p#p0 k1 n_diff_pfx02
1760 test table_part_1#p#p0 k1 n_leaf_pages
1761 test table_part_1#p#p0 k1 size
1762 test table_part_1#p#p1 PRIMARY n_diff_pfx01
1763 test table_part_1#p#p1 PRIMARY n_leaf_pages
1764 test table_part_1#p#p1 PRIMARY size
1765 test table_part_1#p#p1 k1 n_diff_pfx01
1766 test table_part_1#p#p1 k1 n_diff_pfx02
1767 test table_part_1#p#p1 k1 n_leaf_pages
1768 test table_part_1#p#p1 k1 size
1769 test table_part_1#p#p2 PRIMARY n_diff_pfx01
1770 test table_part_1#p#p2 PRIMARY n_leaf_pages
1771 test table_part_1#p#p2 PRIMARY size
1772 test table_part_1#p#p2 k1 n_diff_pfx01
1773 test table_part_1#p#p2 k1 n_diff_pfx02
1774 test table_part_1#p#p2 k1 n_leaf_pages
1775 test table_part_1#p#p2 k1 size
1776 test table_part_1#p#p3 PRIMARY n_diff_pfx01
1777 test table_part_1#p#p3 PRIMARY n_leaf_pages
1778 test table_part_1#p#p3 PRIMARY size
1779 test table_part_1#p#p3 k1 n_diff_pfx01
1780 test table_part_1#p#p3 k1 n_diff_pfx02
1781 test table_part_1#p#p3 k1 n_leaf_pages
1782 test table_part_1#p#p3 k1 size
1783 test table_part_1#p#p4 PRIMARY n_diff_pfx01
1784 test table_part_1#p#p4 PRIMARY n_leaf_pages
1785 test table_part_1#p#p4 PRIMARY size
1786 test table_part_1#p#p4 k1 n_diff_pfx01
1787 test table_part_1#p#p4 k1 n_diff_pfx02
1788 test table_part_1#p#p4 k1 n_leaf_pages
1789 test table_part_1#p#p4 k1 size
1790 test table_part_2#p#p0 PRIMARY n_diff_pfx01
1791 test table_part_2#p#p0 PRIMARY n_leaf_pages
1792 test table_part_2#p#p0 PRIMARY size
1793 test table_part_2#p#p0 k1 n_diff_pfx01
1794 test table_part_2#p#p0 k1 n_diff_pfx02
1795 test table_part_2#p#p0 k1 n_leaf_pages
1796 test table_part_2#p#p0 k1 size
1797 test table_part_2#p#p1 PRIMARY n_diff_pfx01
1798 test table_part_2#p#p1 PRIMARY n_leaf_pages
1799 test table_part_2#p#p1 PRIMARY size
1800 test table_part_2#p#p1 k1 n_diff_pfx01
1801 test table_part_2#p#p1 k1 n_diff_pfx02
1802 test table_part_2#p#p1 k1 n_leaf_pages
1803 test table_part_2#p#p1 k1 size
1804 test table_part_2#p#p2 PRIMARY n_diff_pfx01
1805 test table_part_2#p#p2 PRIMARY n_leaf_pages
1806 test table_part_2#p#p2 PRIMARY size
1807 test table_part_2#p#p2 k1 n_diff_pfx01
1808 test table_part_2#p#p2 k1 n_diff_pfx02
1809 test table_part_2#p#p2 k1 n_leaf_pages
1810 test table_part_2#p#p2 k1 size
1811 test table_part_2#p#p3 PRIMARY n_diff_pfx01
1812 test table_part_2#p#p3 PRIMARY n_leaf_pages
1813 test table_part_2#p#p3 PRIMARY size
1814 test table_part_2#p#p3 k1 n_diff_pfx01
1815 test table_part_2#p#p3 k1 n_diff_pfx02
1816 test table_part_2#p#p3 k1 n_leaf_pages
1817 test table_part_2#p#p3 k1 size
1818 test table_part_2#p#p4 PRIMARY n_diff_pfx01
1819 test table_part_2#p#p4 PRIMARY n_leaf_pages
1820 test table_part_2#p#p4 PRIMARY size
1821 test table_part_2#p#p4 k1 n_diff_pfx01
1822 test table_part_2#p#p4 k1 n_diff_pfx02
1823 test table_part_2#p#p4 k1 n_leaf_pages
1824 test table_part_2#p#p4 k1 size
1825 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx01
1826 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx02
1827 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_leaf_pages
1828 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY size
1829 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx01
1830 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx02
1831 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_leaf_pages
1832 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 size
1833 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx01
1834 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx02
1835 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_leaf_pages
1836 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY size
1837 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx01
1838 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx02
1839 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_leaf_pages
1840 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 size
1841 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx01
1842 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx02
1843 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_leaf_pages
1844 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY size
1845 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx01
1846 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx02
1847 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_leaf_pages
1848 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 size
1849 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx01
1850 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx02
1851 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_leaf_pages
1852 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY size
1853 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx01
1854 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx02
1855 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_leaf_pages
1856 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 size
1857 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx01
1858 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx02
1859 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_leaf_pages
1860 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY size
1861 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx01
1862 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx02
1863 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_leaf_pages
1864 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 size
1865 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx01
1866 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx02
1867 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_leaf_pages
1868 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY size
1869 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx01
1870 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx02
1871 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_leaf_pages
1872 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 size
1873 test table_part_cap_6#p#p0 PRIMARY n_diff_pfx01
1874 test table_part_cap_6#p#p0 PRIMARY n_leaf_pages
1875 test table_part_cap_6#p#p0 PRIMARY size
1876 test table_part_cap_6#p#p0 k1 n_diff_pfx01
1877 test table_part_cap_6#p#p0 k1 n_diff_pfx02
1878 test table_part_cap_6#p#p0 k1 n_leaf_pages
1879 test table_part_cap_6#p#p0 k1 size
1880 test table_part_cap_6#p#p1 PRIMARY n_diff_pfx01
1881 test table_part_cap_6#p#p1 PRIMARY n_leaf_pages
1882 test table_part_cap_6#p#p1 PRIMARY size
1883 test table_part_cap_6#p#p1 k1 n_diff_pfx01
1884 test table_part_cap_6#p#p1 k1 n_diff_pfx02
1885 test table_part_cap_6#p#p1 k1 n_leaf_pages
1886 test table_part_cap_6#p#p1 k1 size
1887 test table_part_cap_6#p#p2 PRIMARY n_diff_pfx01
1888 test table_part_cap_6#p#p2 PRIMARY n_leaf_pages
1889 test table_part_cap_6#p#p2 PRIMARY size
1890 test table_part_cap_6#p#p2 k1 n_diff_pfx01
1891 test table_part_cap_6#p#p2 k1 n_diff_pfx02
1892 test table_part_cap_6#p#p2 k1 n_leaf_pages
1893 test table_part_cap_6#p#p2 k1 size
1894 test table_part_cap_6#p#p3 PRIMARY n_diff_pfx01
1895 test table_part_cap_6#p#p3 PRIMARY n_leaf_pages
1896 test table_part_cap_6#p#p3 PRIMARY size
1897 test table_part_cap_6#p#p3 k1 n_diff_pfx01
1898 test table_part_cap_6#p#p3 k1 n_diff_pfx02
1899 test table_part_cap_6#p#p3 k1 n_leaf_pages
1900 test table_part_cap_6#p#p3 k1 size
1901 test table_part_cap_6#p#p4 PRIMARY n_diff_pfx01
1902 test table_part_cap_6#p#p4 PRIMARY n_leaf_pages
1903 test table_part_cap_6#p#p4 PRIMARY size
1904 test table_part_cap_6#p#p4 k1 n_diff_pfx01
1905 test table_part_cap_6#p#p4 k1 n_diff_pfx02
1906 test table_part_cap_6#p#p4 k1 n_leaf_pages
1907 test table_part_cap_6#p#p4 k1 size
1908 test table_part_nopart_cap_7 PRIMARY n_diff_pfx01
1909 test table_part_nopart_cap_7 PRIMARY n_leaf_pages
1910 test table_part_nopart_cap_7 PRIMARY size
1911 test table_part_nopart_cap_7 k1 n_diff_pfx01
1912 test table_part_nopart_cap_7 k1 n_diff_pfx02
1913 test table_part_nopart_cap_7 k1 n_leaf_pages
1914 test table_part_nopart_cap_7 k1 size
1915 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx01
1916 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx02
1917 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_leaf_pages
1918 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY size
1919 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx01
1920 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx02
1921 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_leaf_pages
1922 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 size
1923 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx01
1924 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx02
1925 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_leaf_pages
1926 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY size
1927 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx01
1928 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx02
1929 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_leaf_pages
1930 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 size
1931 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx01
1932 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx02
1933 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_leaf_pages
1934 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY size
1935 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx01
1936 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx02
1937 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_leaf_pages
1938 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 size
1939 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx01
1940 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx02
1941 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_leaf_pages
1942 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY size
1943 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx01
1944 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx02
1945 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_leaf_pages
1946 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 size
1947 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx01
1948 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx02
1949 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_leaf_pages
1950 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY size
1951 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx01
1952 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx02
1953 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_leaf_pages
1954 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 size
1955 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx01
1956 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx02
1957 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_leaf_pages
1958 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY size
1959 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx01
1960 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx02
1961 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_leaf_pages
1962 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 size
1963 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx01
1964 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx02
1965 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_leaf_pages
1966 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY size
1967 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx01
1968 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx02
1969 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_leaf_pages
1970 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 size
1971 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx01
1972 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx02
1973 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_leaf_pages
1974 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY size
1975 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx01
1976 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx02
1977 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_leaf_pages
1978 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 size
1979 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx01
1980 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx02
1981 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_leaf_pages
1982 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY size
1983 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx01
1984 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx02
1985 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_leaf_pages
1986 test table_part_sub_2#p#part_1#sp#sub_1 k1 size
1987 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx01
1988 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx02
1989 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_leaf_pages
1990 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY size
1991 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx01
1992 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx02
1993 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_leaf_pages
1994 test table_part_sub_2#p#part_1#sp#sub_2 k1 size
1995 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx01
1996 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx02
1997 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_leaf_pages
1998 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY size
1999 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx01
2000 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx02
2001 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_leaf_pages
2002 test table_part_sub_2#p#part_2#sp#sub_3 k1 size
2003 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx01
2004 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx02
2005 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_leaf_pages
2006 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY size
2007 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx01
2008 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx02
2009 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_leaf_pages
2010 test table_part_sub_2#p#part_2#sp#sub_4 k1 size
2011 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx01
2012 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx02
2013 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_leaf_pages
2014 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY size
2015 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx01
2016 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx02
2017 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_leaf_pages
2018 test table_part_sub_2#p#part_3#sp#sub_5 k1 size
2019 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx01
2020 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx02
2021 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_leaf_pages
2022 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY size
2023 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx01
2024 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx02
2025 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_leaf_pages
2026 test table_part_sub_2#p#part_3#sp#sub_6 k1 size
2027
2028 Checking DD tables
2029 ------------------
2030 SET DEBUG='+d,skip_dd_table_access_check';
2031
2032 select t.name as "table", p.name as "partition", p.number
2033 from mysql.tables t, mysql.table_partitions p
2034 where p.table_id = t.id
2035 order by t.name, p.name, p.number;
2036 table partition number
2037 table_part_1 p0 0
2038 table_part_1 p1 1
2039 table_part_1 p2 2
2040 table_part_1 p3 3
2041 table_part_1 p4 4
2042 table_part_2 p0 0
2043 table_part_2 p1 1
2044 table_part_2 p2 2
2045 table_part_2 p3 3
2046 table_part_2 p4 4
2047 table_part_\_special_/_sub_?_3 PART_/_3 2
2048 table_part_\_special_/_sub_?_3 Part_?_1 0
2049 table_part_\_special_/_sub_?_3 pArt_\_2 1
2050 table_part_\_special_/_sub_?_3 sUb_/_2 1
2051 table_part_\_special_/_sub_?_3 SUB_?/_5 0
2052 table_part_\_special_/_sub_?_3 SUB_?\_4 1
2053 table_part_\_special_/_sub_?_3 Sub_?_1 0
2054 table_part_\_special_/_sub_?_3 sub_\/?_6 1
2055 table_part_\_special_/_sub_?_3 suB_\_3 0
2056 table_part_cap_6 p0 0
2057 table_part_cap_6 p1 1
2058 table_part_cap_6 p2 2
2059 table_part_cap_6 p3 3
2060 table_part_cap_6 p4 4
2061 table_part_sub_1 Part_1 0
2062 table_part_sub_1 Part_1sp0 0
2063 table_part_sub_1 Part_1sp1 1
2064 table_part_sub_1 pArt_2 1
2065 table_part_sub_1 pArt_2sp0 0
2066 table_part_sub_1 pArt_2sp1 1
2067 table_part_sub_1 part_3 2
2068 table_part_sub_1 part_3sp0 0
2069 table_part_sub_1 part_3sp1 1
2070 table_part_sub_1 PART_4 3
2071 table_part_sub_1 PART_4sp0 0
2072 table_part_sub_1 PART_4sp1 1
2073 table_part_sub_2 Part_1 0
2074 table_part_sub_2 pArt_2 1
2075 table_part_sub_2 PART_3 2
2076 table_part_sub_2 Sub_1 0
2077 table_part_sub_2 sUb_2 1
2078 table_part_sub_2 suB_3 0
2079 table_part_sub_2 SUB_4 1
2080 table_part_sub_2 SUB_5 0
2081 table_part_sub_2 sub_6 1
2082
2083 select name from mysql.tablespaces
2084 where name like '%table_part%' order by name;
2085 name
2086 test/table_part_1#p#p0
2087 test/table_part_1#p#p1
2088 test/table_part_1#p#p2
2089 test/table_part_1#p#p3
2090 test/table_part_1#p#p4
2091 test/table_part_2#p#p0
2092 test/table_part_2#p#p1
2093 test/table_part_2#p#p2
2094 test/table_part_2#p#p3
2095 test/table_part_2#p#p4
2096 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
2097 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
2098 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
2099 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
2100 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
2101 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
2102 test/table_part_cap_6#p#p0
2103 test/table_part_cap_6#p#p1
2104 test/table_part_cap_6#p#p2
2105 test/table_part_cap_6#p#p3
2106 test/table_part_cap_6#p#p4
2107 test/table_part_sub_1#p#part_1#sp#part_1sp0
2108 test/table_part_sub_1#p#part_1#sp#part_1sp1
2109 test/table_part_sub_1#p#part_2#sp#part_2sp0
2110 test/table_part_sub_1#p#part_2#sp#part_2sp1
2111 test/table_part_sub_1#p#part_3#sp#part_3sp0
2112 test/table_part_sub_1#p#part_3#sp#part_3sp1
2113 test/table_part_sub_1#p#part_4#sp#part_4sp0
2114 test/table_part_sub_1#p#part_4#sp#part_4sp1
2115 test/table_part_sub_2#p#part_1#sp#sub_1
2116 test/table_part_sub_2#p#part_1#sp#sub_2
2117 test/table_part_sub_2#p#part_2#sp#sub_3
2118 test/table_part_sub_2#p#part_2#sp#sub_4
2119 test/table_part_sub_2#p#part_3#sp#sub_5
2120 test/table_part_sub_2#p#part_3#sp#sub_6
2121
2122 select file_name from mysql.tablespace_files
2123 where file_name like '%table_part%' order by file_name;
2124 file_name
2125 ./test/table_part_1#p#p0.ibd
2126 ./test/table_part_1#p#p1.ibd
2127 ./test/table_part_1#p#p2.ibd
2128 ./test/table_part_1#p#p3.ibd
2129 ./test/table_part_1#p#p4.ibd
2130 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd
2131 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd
2132 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd
2133 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd
2134 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd
2135 ./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd
2136 ./test/table_part_cap_6#p#p0.ibd
2137 ./test/table_part_cap_6#p#p1.ibd
2138 ./test/table_part_cap_6#p#p2.ibd
2139 ./test/table_part_cap_6#p#p3.ibd
2140 ./test/table_part_cap_6#p#p4.ibd
2141 ./test/table_part_sub_1#p#part_1#sp#part_1sp0.ibd
2142 ./test/table_part_sub_1#p#part_1#sp#part_1sp1.ibd
2143 ./test/table_part_sub_1#p#part_2#sp#part_2sp0.ibd
2144 ./test/table_part_sub_1#p#part_2#sp#part_2sp1.ibd
2145 ./test/table_part_sub_1#p#part_3#sp#part_3sp0.ibd
2146 ./test/table_part_sub_1#p#part_3#sp#part_3sp1.ibd
2147 ./test/table_part_sub_1#p#part_4#sp#part_4sp0.ibd
2148 ./test/table_part_sub_1#p#part_4#sp#part_4sp1.ibd
2149 ./test/table_part_sub_2#p#part_1#sp#sub_1.ibd
2150 ./test/table_part_sub_2#p#part_1#sp#sub_2.ibd
2151 ./test/table_part_sub_2#p#part_2#sp#sub_4.ibd
2152 ./test/table_part_sub_2#p#part_3#sp#sub_5.ibd
2153 ./test/table_part_sub_2#p#part_3#sp#sub_6.ibd
2154 /tmp/mysql_wl13352_data/test/table_part_2#p#p0.ibd
2155 /tmp/mysql_wl13352_data/test/table_part_2#p#p1.ibd
2156 /tmp/mysql_wl13352_data/test/table_part_2#p#p2.ibd
2157 /tmp/mysql_wl13352_data/test/table_part_2#p#p3.ibd
2158 /tmp/mysql_wl13352_data/test/table_part_2#p#p4.ibd
2159 /tmp/mysql_wl13352_data/test/table_part_sub_2#p#part_2#sp#sub_3.ibd
2160 SET DEBUG='-d,skip_dd_table_access_check';
2161 SET NAMES DEFAULT;
2162 # 2. Do DML insert/update/delete on upgraded tables
2163 DML on partitioned tables
2164 -------------------------
2165
2166 insert into table_part_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
2167
2168 update table_part_1 set name = 'Row - updated' where value > 500;
2169
2170 delete from table_part_1 where id = 7;
2171
2172 insert into table_part_sub_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
2173
2174 update table_part_sub_1 set name = 'Row - updated' where value > 500;
2175
2176 delete from table_part_sub_1 where id = 7;
2177
2178 insert into table_part_sub_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
2179
2180 update table_part_sub_2 set name = 'Row - updated' where value > 500;
2181
2182 delete from table_part_sub_2 where id = 7;
2183
2184 insert into `table_part_\_special_/_sub_?_3` values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
2185
2186 update `table_part_\_special_/_sub_?_3` set name = 'Row - updated' where value > 500;
2187
2188 delete from `table_part_\_special_/_sub_?_3` where id = 7;
2189
2190 insert into table_part_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
2191
2192 update table_part_2 set name = 'Row - updated' where value > 500;
2193
2194 delete from table_part_2 where id = 7;
2195
2196 insert into table_part_CAP_6 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
2197
2198 update table_part_CAP_6 set name = 'Row - updated' where value > 500;
2199
2200 delete from table_part_CAP_6 where id = 7;
2201
2202 insert into table_part_NOPART_CAP_7 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
2203
2204 update table_part_NOPART_CAP_7 set name = 'Row - updated' where value > 500;
2205
2206 delete from table_part_NOPART_CAP_7 where id = 7;
2207 # 3. Do DDL ALTER/DROP on upgraded tables
2208 DDL on partitioned tables
2209 -------------------------
2210 ALTER TABLE table_part_1 TRUNCATE PARTITION p0;
2211
2212 ALTER TABLE table_part_1 COALESCE PARTITION 2;
2213
2214 SHOW CREATE TABLE table_part_1;
2215 Table Create Table
2216 table_part_1 CREATE TABLE `table_part_1` (
2217 `id` int NOT NULL,
2218 `value` int DEFAULT NULL,
2219 `name` varchar(32) DEFAULT NULL,
2220 `data` blob,
2221 PRIMARY KEY (`id`),
2222 KEY `k1` (`value`)
2223 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2224 /*!50100 PARTITION BY HASH (`id`)
2225 PARTITIONS 3 */
2226
2227 ALTER TABLE table_part_sub_1 TRUNCATE PARTITION part_1;
2228
2229 ALTER TABLE table_part_sub_2 TRUNCATE PARTITION part_3;
2230
2231 CREATE TABLE test_table LIKE table_part_sub_2;
2232
2233 ALTER TABLE test_table REMOVE PARTITIONING;
2234 insert into test_table values(2, 265, "Row - 2", REPEAT('Large Column Data - 2' , 256));
2235
2236 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
2237 id value name
2238 2 255 Row - 2
2239 4 455 Row - 4
2240
2241 SELECT id, value, name FROM test_table order by id;
2242 id value name
2243 2 265 Row - 2
2244
2245 ALTER TABLE table_part_sub_2 EXCHANGE PARTITION sub_3 WITH TABLE test_table;
2246
2247 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
2248 id value name
2249 2 265 Row - 2
2250
2251 SELECT id, value, name FROM test_table order by id;
2252 id value name
2253 2 255 Row - 2
2254 4 455 Row - 4
2255
2256 DROP TABLE test_table;
2257
2258 ALTER TABLE table_part_sub_2 RENAME renamed_table;;
2259 SHOW CREATE TABLE renamed_table;
2260 Table Create Table
2261 renamed_table CREATE TABLE `renamed_table` (
2262 `id` int NOT NULL,
2263 `value` int NOT NULL,
2264 `name` varchar(32) DEFAULT NULL,
2265 `data` blob,
2266 PRIMARY KEY (`id`,`value`),
2267 KEY `k1` (`value`)
2268 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2269 /*!50100 PARTITION BY RANGE (`value`)
2270 SUBPARTITION BY HASH (`id`)
2271 (PARTITION Part_1 VALUES LESS THAN (101)
2272 (SUBPARTITION Sub_1 ENGINE = InnoDB,
2273 SUBPARTITION sUb_2 ENGINE = InnoDB),
2274 PARTITION pArt_2 VALUES LESS THAN (501)
2275 (SUBPARTITION suB_3 ENGINE = InnoDB,
2276 SUBPARTITION SUB_4 ENGINE = InnoDB),
2277 PARTITION PART_3 VALUES LESS THAN MAXVALUE
2278 (SUBPARTITION SUB_5 ENGINE = InnoDB,
2279 SUBPARTITION sub_6 ENGINE = InnoDB)) */
2280
2281 ALTER TABLE renamed_table RENAME table_part_sub_2;;
2282
2283 ALTER TABLE table_part_1 ENGINE = InnoDB;;
2284
2285 ALTER TABLE table_part_1 ADD COLUMN new_id int AFTER id;
2286
2287 ALTER TABLE table_part_1 REMOVE PARTITIONING;
2288
2289 ALTER TABLE table_part_sub_1 ENGINE = InnoDB;;
2290
2291 ALTER TABLE table_part_sub_1 ADD COLUMN new_id int AFTER id;
2292
2293 ALTER TABLE table_part_sub_1 REMOVE PARTITIONING;
2294
2295 ALTER TABLE table_part_sub_2 ENGINE = InnoDB;;
2296
2297 ALTER TABLE table_part_sub_2 ADD COLUMN new_id int AFTER id;
2298
2299 ALTER TABLE table_part_sub_2 REMOVE PARTITIONING;
2300
2301 ALTER TABLE `table_part_\_special_/_sub_?_3` ENGINE = InnoDB;;
2302
2303 ALTER TABLE `table_part_\_special_/_sub_?_3` ADD COLUMN new_id int AFTER id;
2304
2305 ALTER TABLE `table_part_\_special_/_sub_?_3` REMOVE PARTITIONING;
2306
2307 ALTER TABLE table_part_2 ENGINE = InnoDB;;
2308
2309 ALTER TABLE table_part_2 ADD COLUMN new_id int AFTER id;
2310
2311 ALTER TABLE table_part_2 REMOVE PARTITIONING;
2312
2313 ALTER TABLE table_part_CAP_6 ENGINE = InnoDB;;
2314
2315 ALTER TABLE table_part_CAP_6 ADD COLUMN new_id int AFTER id;
2316
2317 ALTER TABLE table_part_CAP_6 REMOVE PARTITIONING;
2318
2319 ALTER TABLE table_part_NOPART_CAP_7 ENGINE = InnoDB;;
2320
2321 ALTER TABLE table_part_NOPART_CAP_7 ADD COLUMN new_id int AFTER id;
2322
2323
2324 # Shutdown server
2325
2326 # Remove upgraded data directory.
2327
2328 # Cleanup: Restart with default options.
2329 # restart