Debian Codegraph @

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

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