Debian Codegraph @

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

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