Debian Codegraph @

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

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