Debian Codegraph @

mysql-test/suite/innodb/r/partition_upgrade_5727_mac_lctn_2.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.frm
26 table_part_NOPART_CAP_7.frm
27 table_part_cap_6#P#p0.ibd
28 table_part_cap_6#P#p1.ibd
29 table_part_cap_6#P#p2.ibd
30 table_part_cap_6#P#p3.ibd
31 table_part_cap_6#P#p4.ibd
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_@003f_1.ibd
66 table_part_@005c_special_@002f_sub_@003f_3#P#Part_@003f_1#SP#sUb_@002f_2.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_4#SP#PART_4sp0.ibd
75 table_part_sub_1#P#PART_4#SP#PART_4sp1.ibd
76 table_part_sub_1#P#Part_1#SP#Part_1sp0.ibd
77 table_part_sub_1#P#Part_1#SP#Part_1sp1.ibd
78 table_part_sub_1#P#pArt_2#SP#pArt_2sp0.ibd
79 table_part_sub_1#P#pArt_2#SP#pArt_2sp1.ibd
80 table_part_sub_1#P#part_3#SP#part_3sp0.ibd
81 table_part_sub_1#P#part_3#SP#part_3sp1.ibd
82 table_part_sub_2#P#PART_3#SP#SUB_5.ibd
83 table_part_sub_2#P#PART_3#SP#sub_6.ibd
84 table_part_sub_2#P#Part_1#SP#Sub_1.ibd
85 table_part_sub_2#P#Part_1#SP#sUb_2.ibd
86 table_part_sub_2#P#pArt_2#SP#SUB_4.ibd
87 table_part_sub_2#P#pArt_2#SP#suB_3.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_@003f_1.ibd test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
419 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
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_4#SP#PART_4sp0.ibd test/table_part_sub_1#p#part_4#sp#part_4sp0
428 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
429 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
430 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
431 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
432 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
433 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
434 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
435 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
436 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
437 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
438 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
439 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
440 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
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 SET NAMES DEFAULT;
761 # 2. Do DML insert/update/delete on upgraded tables
762 DML on partitioned tables
763 -------------------------
764
765 insert into table_part_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
766
767 update table_part_1 set name = 'Row - updated' where value > 500;
768
769 delete from table_part_1 where id = 7;
770
771 insert into table_part_sub_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
772
773 update table_part_sub_1 set name = 'Row - updated' where value > 500;
774
775 delete from table_part_sub_1 where id = 7;
776
777 insert into table_part_sub_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
778
779 update table_part_sub_2 set name = 'Row - updated' where value > 500;
780
781 delete from table_part_sub_2 where id = 7;
782
783 insert into `table_part_\_special_/_sub_?_3` values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
784
785 update `table_part_\_special_/_sub_?_3` set name = 'Row - updated' where value > 500;
786
787 delete from `table_part_\_special_/_sub_?_3` where id = 7;
788
789 insert into table_part_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
790
791 update table_part_2 set name = 'Row - updated' where value > 500;
792
793 delete from table_part_2 where id = 7;
794 # 3. Do DDL ALTER/DROP on upgraded tables
795 DDL on partitioned tables
796 -------------------------
797 ALTER TABLE table_part_1 TRUNCATE PARTITION p0;
798
799 ALTER TABLE table_part_1 COALESCE PARTITION 2;
800
801 SHOW CREATE TABLE table_part_1;
802 Table Create Table
803 table_part_1 CREATE TABLE `table_part_1` (
804 `id` int NOT NULL,
805 `value` int DEFAULT NULL,
806 `name` varchar(32) DEFAULT NULL,
807 `data` blob,
808 PRIMARY KEY (`id`),
809 KEY `k1` (`value`)
810 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
811 /*!50100 PARTITION BY HASH (`id`)
812 PARTITIONS 3 */
813
814 ALTER TABLE table_part_sub_1 TRUNCATE PARTITION part_1;
815
816 ALTER TABLE table_part_sub_2 TRUNCATE PARTITION part_3;
817
818 CREATE TABLE test_table LIKE table_part_sub_2;
819
820 ALTER TABLE test_table REMOVE PARTITIONING;
821 insert into test_table values(2, 265, "Row - 2", REPEAT('Large Column Data - 2' , 256));
822
823 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
824 id value name
825 2 255 Row - 2
826 4 455 Row - 4
827
828 SELECT id, value, name FROM test_table order by id;
829 id value name
830 2 265 Row - 2
831
832 ALTER TABLE table_part_sub_2 EXCHANGE PARTITION sub_3 WITH TABLE test_table;
833
834 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
835 id value name
836 2 265 Row - 2
837
838 SELECT id, value, name FROM test_table order by id;
839 id value name
840 2 255 Row - 2
841 4 455 Row - 4
842
843 DROP TABLE test_table;
844
845 ALTER TABLE table_part_sub_2 RENAME renamed_table;;
846 SHOW CREATE TABLE renamed_table;
847 Table Create Table
848 renamed_table CREATE TABLE `renamed_table` (
849 `id` int NOT NULL,
850 `value` int NOT NULL,
851 `name` varchar(32) DEFAULT NULL,
852 `data` blob,
853 PRIMARY KEY (`id`,`value`),
854 KEY `k1` (`value`)
855 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
856 /*!50100 PARTITION BY RANGE (`value`)
857 SUBPARTITION BY HASH (`id`)
858 (PARTITION Part_1 VALUES LESS THAN (101)
859 (SUBPARTITION Sub_1 ENGINE = InnoDB,
860 SUBPARTITION sUb_2 ENGINE = InnoDB),
861 PARTITION pArt_2 VALUES LESS THAN (501)
862 (SUBPARTITION suB_3 ENGINE = InnoDB,
863 SUBPARTITION SUB_4 ENGINE = InnoDB),
864 PARTITION PART_3 VALUES LESS THAN MAXVALUE
865 (SUBPARTITION SUB_5 ENGINE = InnoDB,
866 SUBPARTITION sub_6 ENGINE = InnoDB)) */
867
868 ALTER TABLE renamed_table RENAME table_part_sub_2;;
869
870 ALTER TABLE table_part_1 ENGINE = InnoDB;;
871
872 ALTER TABLE table_part_1 ADD COLUMN new_id int AFTER id;
873
874 ALTER TABLE table_part_1 REMOVE PARTITIONING;
875
876 ALTER TABLE table_part_sub_1 ENGINE = InnoDB;;
877
878 ALTER TABLE table_part_sub_1 ADD COLUMN new_id int AFTER id;
879
880 ALTER TABLE table_part_sub_1 REMOVE PARTITIONING;
881
882 ALTER TABLE table_part_sub_2 ENGINE = InnoDB;;
883
884 ALTER TABLE table_part_sub_2 ADD COLUMN new_id int AFTER id;
885
886 ALTER TABLE table_part_sub_2 REMOVE PARTITIONING;
887
888 ALTER TABLE `table_part_\_special_/_sub_?_3` ENGINE = InnoDB;;
889
890 ALTER TABLE `table_part_\_special_/_sub_?_3` ADD COLUMN new_id int AFTER id;
891
892 ALTER TABLE `table_part_\_special_/_sub_?_3` REMOVE PARTITIONING;
893
894 ALTER TABLE table_part_2 ENGINE = InnoDB;;
895
896 ALTER TABLE table_part_2 ADD COLUMN new_id int AFTER id;
897
898 ALTER TABLE table_part_2 REMOVE PARTITIONING;
899
900 # B. Create all the tables again and validate
901 Dropping partitioned tables
902 ---------------------------
903 DROP TABLE table_part_1;
904 DROP TABLE table_part_sub_1;
905 DROP TABLE table_part_sub_2;
906 DROP TABLE `table_part_\_special_/_sub_?_3`;
907 DROP TABLE table_part_2;
908 Creating partitioned tables
909 ---------------------------
910 CREATE TABLE table_part_1(
911 id int primary key, value int, name varchar(32), data BLOB,
912 key k1(value)) partition by hash (id) partitions 5;
913
914 CREATE TABLE table_part_2(
915 id int primary key, value int, name varchar(32), data BLOB,
916 key k1(value))
917 partition by hash (id) partitions 5;
918
919 CREATE TABLE table_part_sub_1(
920 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
921 key k1(value)) partition by range (value) subpartition by hash (id)
922 subpartitions 2 ( partition Part_1 values less than (101),
923 partition pArt_2 values less than (401),
924 partition part_3 values less than (701),
925 partition PART_4 values less than MAXVALUE);
926
927 CREATE TABLE table_part_sub_2(
928 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
929 key k1(value)) partition by range (value) subpartition by hash (id)
930 ( partition Part_1 values less than (101)(
931 subpartition Sub_1,
932 subpartition sUb_2),
933 partition pArt_2 values less than (501)(
934 subpartition suB_3 ,
935 subpartition SUB_4),
936 partition PART_3 values less than MAXVALUE(
937 subpartition SUB_5,
938 subpartition sub_6));
939
940 CREATE TABLE `table_part_\_special_/_sub_?_3`(
941 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
942 key k1(value)) partition by range (value) subpartition by hash (id)
943 ( partition `Part_?_1` values less than (201)(
944 subpartition `Sub_?_1`,
945 subpartition `sUb_/_2`),
946 partition `pArt_\_2` values less than (501)(
947 subpartition `suB_\_3`,
948 subpartition `SUB_?\_4`),
949 partition `PART_/_3` values less than MAXVALUE(
950 subpartition `SUB_?/_5`,
951 subpartition `sub_\/?_6`));
952
953 Inserting 10 rows to table_part_1
954 ---------------------------------------
955 insert into table_part_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
956 insert into table_part_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
957 insert into table_part_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
958 insert into table_part_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
959 insert into table_part_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
960 insert into table_part_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
961 insert into table_part_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
962 insert into table_part_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
963 insert into table_part_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
964 insert into table_part_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
965
966 Inserting 10 rows to table_part_sub_1
967 ---------------------------------------
968 insert into table_part_sub_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
969 insert into table_part_sub_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
970 insert into table_part_sub_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
971 insert into table_part_sub_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
972 insert into table_part_sub_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
973 insert into table_part_sub_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
974 insert into table_part_sub_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
975 insert into table_part_sub_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
976 insert into table_part_sub_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
977 insert into table_part_sub_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
978
979 Inserting 10 rows to table_part_sub_2
980 ---------------------------------------
981 insert into table_part_sub_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
982 insert into table_part_sub_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
983 insert into table_part_sub_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
984 insert into table_part_sub_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
985 insert into table_part_sub_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
986 insert into table_part_sub_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
987 insert into table_part_sub_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
988 insert into table_part_sub_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
989 insert into table_part_sub_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
990 insert into table_part_sub_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
991
992 Inserting 10 rows to `table_part_\_special_/_sub_?_3`
993 ---------------------------------------
994 insert into `table_part_\_special_/_sub_?_3` VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
995 insert into `table_part_\_special_/_sub_?_3` VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
996 insert into `table_part_\_special_/_sub_?_3` VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
997 insert into `table_part_\_special_/_sub_?_3` VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
998 insert into `table_part_\_special_/_sub_?_3` VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
999 insert into `table_part_\_special_/_sub_?_3` VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1000 insert into `table_part_\_special_/_sub_?_3` VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1001 insert into `table_part_\_special_/_sub_?_3` VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1002 insert into `table_part_\_special_/_sub_?_3` VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1003 insert into `table_part_\_special_/_sub_?_3` VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1004
1005 Inserting 10 rows to table_part_2
1006 ---------------------------------------
1007 insert into table_part_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
1008 insert into table_part_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
1009 insert into table_part_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1010 insert into table_part_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
1011 insert into table_part_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
1012 insert into table_part_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
1013 insert into table_part_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
1014 insert into table_part_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
1015 insert into table_part_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
1016 insert into table_part_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
1017 select id, value, name from table_part_sub_2 partition (sub_1) order by id;
1018 id value name
1019 0 55 Row - 0
1020 select id, value, name from table_part_sub_2 partition (sub_2) order by id;
1021 id value name
1022 select id, value, name from table_part_sub_2 partition (sub_3) order by id;
1023 id value name
1024 2 255 Row - 2
1025 4 455 Row - 4
1026 select id, value, name from table_part_sub_2 partition (sub_4) order by id;
1027 id value name
1028 1 155 Row - 1
1029 3 355 Row - 3
1030 select id, value, name from table_part_sub_2 partition (sub_5) order by id;
1031 id value name
1032 6 655 Row - 6
1033 8 855 Row - 8
1034 select id, value, name from table_part_sub_2 partition (sub_6) order by id;
1035 id value name
1036 5 555 Row - 5
1037 7 755 Row - 7
1038 9 955 Row - 9
1039
1040 # 1. Check table metadata and data
1041 Checking partitioned tables
1042 ---------------------------
1043 SET NAMES utf8mb4 COLLATE utf8mb4_0900_as_cs;
1044
1045 CHECK TABLE table_part_1;
1046 Table Op Msg_type Msg_text
1047 test.table_part_1 check status OK
1048
1049 SHOW CREATE TABLE table_part_1;
1050 Table Create Table
1051 table_part_1 CREATE TABLE `table_part_1` (
1052 `id` int NOT NULL,
1053 `value` int DEFAULT NULL,
1054 `name` varchar(32) DEFAULT NULL,
1055 `data` blob,
1056 PRIMARY KEY (`id`),
1057 KEY `k1` (`value`)
1058 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1059 /*!50100 PARTITION BY HASH (`id`)
1060 PARTITIONS 5 */
1061
1062 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_1 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_sub_1;
1076 Table Op Msg_type Msg_text
1077 test.table_part_sub_1 check status OK
1078
1079 SHOW CREATE TABLE table_part_sub_1;
1080 Table Create Table
1081 table_part_sub_1 CREATE TABLE `table_part_sub_1` (
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 SUBPARTITIONS 2
1092 (PARTITION Part_1 VALUES LESS THAN (101) ENGINE = InnoDB,
1093 PARTITION pArt_2 VALUES LESS THAN (401) ENGINE = InnoDB,
1094 PARTITION part_3 VALUES LESS THAN (701) ENGINE = InnoDB,
1095 PARTITION PART_4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
1096
1097 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_1 order by id;
1098 id value name SUBSTRING(data, 1024, 32)
1099 0 55 Row - 0 ta - 0Large Column Data - 0Large
1100 1 155 Row - 1 ta - 1Large Column Data - 1Large
1101 2 255 Row - 2 ta - 2Large Column Data - 2Large
1102 3 355 Row - 3 ta - 3Large Column Data - 3Large
1103 4 455 Row - 4 ta - 4Large Column Data - 4Large
1104 5 555 Row - 5 ta - 5Large Column Data - 5Large
1105 6 655 Row - 6 ta - 6Large Column Data - 6Large
1106 7 755 Row - 7 ta - 7Large Column Data - 7Large
1107 8 855 Row - 8 ta - 8Large Column Data - 8Large
1108 9 955 Row - 9 ta - 9Large Column Data - 9Large
1109
1110 CHECK TABLE table_part_sub_2;
1111 Table Op Msg_type Msg_text
1112 test.table_part_sub_2 check status OK
1113
1114 SHOW CREATE TABLE table_part_sub_2;
1115 Table Create Table
1116 table_part_sub_2 CREATE TABLE `table_part_sub_2` (
1117 `id` int NOT NULL,
1118 `value` int NOT NULL,
1119 `name` varchar(32) DEFAULT NULL,
1120 `data` blob,
1121 PRIMARY KEY (`id`,`value`),
1122 KEY `k1` (`value`)
1123 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1124 /*!50100 PARTITION BY RANGE (`value`)
1125 SUBPARTITION BY HASH (`id`)
1126 (PARTITION Part_1 VALUES LESS THAN (101)
1127 (SUBPARTITION Sub_1 ENGINE = InnoDB,
1128 SUBPARTITION sUb_2 ENGINE = InnoDB),
1129 PARTITION pArt_2 VALUES LESS THAN (501)
1130 (SUBPARTITION suB_3 ENGINE = InnoDB,
1131 SUBPARTITION SUB_4 ENGINE = InnoDB),
1132 PARTITION PART_3 VALUES LESS THAN MAXVALUE
1133 (SUBPARTITION SUB_5 ENGINE = InnoDB,
1134 SUBPARTITION sub_6 ENGINE = InnoDB)) */
1135
1136 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_2 order by id;
1137 id value name SUBSTRING(data, 1024, 32)
1138 0 55 Row - 0 ta - 0Large Column Data - 0Large
1139 1 155 Row - 1 ta - 1Large Column Data - 1Large
1140 2 255 Row - 2 ta - 2Large Column Data - 2Large
1141 3 355 Row - 3 ta - 3Large Column Data - 3Large
1142 4 455 Row - 4 ta - 4Large Column Data - 4Large
1143 5 555 Row - 5 ta - 5Large Column Data - 5Large
1144 6 655 Row - 6 ta - 6Large Column Data - 6Large
1145 7 755 Row - 7 ta - 7Large Column Data - 7Large
1146 8 855 Row - 8 ta - 8Large Column Data - 8Large
1147 9 955 Row - 9 ta - 9Large Column Data - 9Large
1148
1149 CHECK TABLE `table_part_\_special_/_sub_?_3`;
1150 Table Op Msg_type Msg_text
1151 test.table_part_\_special_/_sub_?_3 check status OK
1152
1153 SHOW CREATE TABLE `table_part_\_special_/_sub_?_3`;
1154 Table Create Table
1155 table_part_\_special_/_sub_?_3 CREATE TABLE `table_part_\_special_/_sub_?_3` (
1156 `id` int NOT NULL,
1157 `value` int NOT NULL,
1158 `name` varchar(32) DEFAULT NULL,
1159 `data` blob,
1160 PRIMARY KEY (`id`,`value`),
1161 KEY `k1` (`value`)
1162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1163 /*!50100 PARTITION BY RANGE (`value`)
1164 SUBPARTITION BY HASH (`id`)
1165 (PARTITION `Part_?_1` VALUES LESS THAN (201)
1166 (SUBPARTITION `Sub_?_1` ENGINE = InnoDB,
1167 SUBPARTITION `sUb_/_2` ENGINE = InnoDB),
1168 PARTITION `pArt_\_2` VALUES LESS THAN (501)
1169 (SUBPARTITION `suB_\_3` ENGINE = InnoDB,
1170 SUBPARTITION `SUB_?\_4` ENGINE = InnoDB),
1171 PARTITION `PART_/_3` VALUES LESS THAN MAXVALUE
1172 (SUBPARTITION `SUB_?/_5` ENGINE = InnoDB,
1173 SUBPARTITION `sub_\/?_6` ENGINE = InnoDB)) */
1174
1175 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM `table_part_\_special_/_sub_?_3` order by id;
1176 id value name SUBSTRING(data, 1024, 32)
1177 0 55 Row - 0 ta - 0Large Column Data - 0Large
1178 1 155 Row - 1 ta - 1Large Column Data - 1Large
1179 2 255 Row - 2 ta - 2Large Column Data - 2Large
1180 3 355 Row - 3 ta - 3Large Column Data - 3Large
1181 4 455 Row - 4 ta - 4Large Column Data - 4Large
1182 5 555 Row - 5 ta - 5Large Column Data - 5Large
1183 6 655 Row - 6 ta - 6Large Column Data - 6Large
1184 7 755 Row - 7 ta - 7Large Column Data - 7Large
1185 8 855 Row - 8 ta - 8Large Column Data - 8Large
1186 9 955 Row - 9 ta - 9Large Column Data - 9Large
1187
1188 CHECK TABLE table_part_2;
1189 Table Op Msg_type Msg_text
1190 test.table_part_2 check status OK
1191
1192 SHOW CREATE TABLE table_part_2;
1193 Table Create Table
1194 table_part_2 CREATE TABLE `table_part_2` (
1195 `id` int NOT NULL,
1196 `value` int DEFAULT NULL,
1197 `name` varchar(32) DEFAULT NULL,
1198 `data` blob,
1199 PRIMARY KEY (`id`),
1200 KEY `k1` (`value`)
1201 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1202 /*!50100 PARTITION BY HASH (`id`)
1203 PARTITIONS 5 */
1204
1205 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_2 order by id;
1206 id value name SUBSTRING(data, 1024, 32)
1207 0 55 Row - 0 ta - 0Large Column Data - 0Large
1208 1 155 Row - 1 ta - 1Large Column Data - 1Large
1209 2 255 Row - 2 ta - 2Large Column Data - 2Large
1210 3 355 Row - 3 ta - 3Large Column Data - 3Large
1211 4 455 Row - 4 ta - 4Large Column Data - 4Large
1212 5 555 Row - 5 ta - 5Large Column Data - 5Large
1213 6 655 Row - 6 ta - 6Large Column Data - 6Large
1214 7 755 Row - 7 ta - 7Large Column Data - 7Large
1215 8 855 Row - 8 ta - 8Large Column Data - 8Large
1216 9 955 Row - 9 ta - 9Large Column Data - 9Large
1217
1218 Checking IFS views
1219 ------------------
1220 select table_schema, table_name from information_schema.tables
1221 where table_name LIKE '%table_part%' order by table_schema, table_name;
1222 TABLE_SCHEMA TABLE_NAME
1223 test table_part_1
1224 test table_part_2
1225 test table_part_\_special_/_sub_?_3
1226 test table_part_cap_6
1227 test table_part_NOPART_CAP_7
1228 test table_part_sub_1
1229 test table_part_sub_2
1230
1231 select name, space_type from information_schema.innodb_tables
1232 where name LIKE '%table_part%' order by name, space_type;
1233 name space_type
1234 test/table_part_1#p#p0 Single
1235 test/table_part_1#p#p1 Single
1236 test/table_part_1#p#p2 Single
1237 test/table_part_1#p#p3 Single
1238 test/table_part_1#p#p4 Single
1239 test/table_part_2#p#p0 Single
1240 test/table_part_2#p#p1 Single
1241 test/table_part_2#p#p2 Single
1242 test/table_part_2#p#p3 Single
1243 test/table_part_2#p#p4 Single
1244 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5 Single
1245 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6 Single
1246 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2 Single
1247 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1 Single
1248 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4 Single
1249 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3 Single
1250 test/table_part_cap_6#p#p0 Single
1251 test/table_part_cap_6#p#p1 Single
1252 test/table_part_cap_6#p#p2 Single
1253 test/table_part_cap_6#p#p3 Single
1254 test/table_part_cap_6#p#p4 Single
1255 test/table_part_nopart_cap_7 General
1256 test/table_part_sub_1#p#part_1#sp#part_1sp0 Single
1257 test/table_part_sub_1#p#part_1#sp#part_1sp1 Single
1258 test/table_part_sub_1#p#part_2#sp#part_2sp0 Single
1259 test/table_part_sub_1#p#part_2#sp#part_2sp1 Single
1260 test/table_part_sub_1#p#part_3#sp#part_3sp0 Single
1261 test/table_part_sub_1#p#part_3#sp#part_3sp1 Single
1262 test/table_part_sub_1#p#part_4#sp#part_4sp0 Single
1263 test/table_part_sub_1#p#part_4#sp#part_4sp1 Single
1264 test/table_part_sub_2#p#part_1#sp#sub_1 Single
1265 test/table_part_sub_2#p#part_1#sp#sub_2 Single
1266 test/table_part_sub_2#p#part_2#sp#sub_3 Single
1267 test/table_part_sub_2#p#part_2#sp#sub_4 Single
1268 test/table_part_sub_2#p#part_3#sp#sub_5 Single
1269 test/table_part_sub_2#p#part_3#sp#sub_6 Single
1270
1271 select table_schema, table_name, partition_name, subpartition_name
1272 from information_schema.partitions
1273 where table_name LIKE '%table_part%'
1274 order by table_schema, table_name, partition_name, subpartition_name;
1275 TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME
1276 test table_part_1 p0 NULL
1277 test table_part_1 p1 NULL
1278 test table_part_1 p2 NULL
1279 test table_part_1 p3 NULL
1280 test table_part_1 p4 NULL
1281 test table_part_2 p0 NULL
1282 test table_part_2 p1 NULL
1283 test table_part_2 p2 NULL
1284 test table_part_2 p3 NULL
1285 test table_part_2 p4 NULL
1286 test table_part_\_special_/_sub_?_3 PART_/_3 SUB_?/_5
1287 test table_part_\_special_/_sub_?_3 PART_/_3 sub_\/?_6
1288 test table_part_\_special_/_sub_?_3 Part_?_1 sUb_/_2
1289 test table_part_\_special_/_sub_?_3 Part_?_1 Sub_?_1
1290 test table_part_\_special_/_sub_?_3 pArt_\_2 SUB_?\_4
1291 test table_part_\_special_/_sub_?_3 pArt_\_2 suB_\_3
1292 test table_part_cap_6 p0 NULL
1293 test table_part_cap_6 p1 NULL
1294 test table_part_cap_6 p2 NULL
1295 test table_part_cap_6 p3 NULL
1296 test table_part_cap_6 p4 NULL
1297 test table_part_NOPART_CAP_7 NULL NULL
1298 test table_part_sub_1 Part_1 Part_1sp0
1299 test table_part_sub_1 Part_1 Part_1sp1
1300 test table_part_sub_1 pArt_2 pArt_2sp0
1301 test table_part_sub_1 pArt_2 pArt_2sp1
1302 test table_part_sub_1 part_3 part_3sp0
1303 test table_part_sub_1 part_3 part_3sp1
1304 test table_part_sub_1 PART_4 PART_4sp0
1305 test table_part_sub_1 PART_4 PART_4sp1
1306 test table_part_sub_2 Part_1 Sub_1
1307 test table_part_sub_2 Part_1 sUb_2
1308 test table_part_sub_2 pArt_2 suB_3
1309 test table_part_sub_2 pArt_2 SUB_4
1310 test table_part_sub_2 PART_3 SUB_5
1311 test table_part_sub_2 PART_3 sub_6
1312
1313 select name from information_schema.innodb_tablespaces
1314 where name LIKE '%table_part%' order by name;
1315 name
1316 test/table_part_1#p#p0
1317 test/table_part_1#p#p1
1318 test/table_part_1#p#p2
1319 test/table_part_1#p#p3
1320 test/table_part_1#p#p4
1321 test/table_part_2#p#p0
1322 test/table_part_2#p#p1
1323 test/table_part_2#p#p2
1324 test/table_part_2#p#p3
1325 test/table_part_2#p#p4
1326 test/table_part_cap_6#p#p0
1327 test/table_part_cap_6#p#p1
1328 test/table_part_cap_6#p#p2
1329 test/table_part_cap_6#p#p3
1330 test/table_part_cap_6#p#p4
1331 test/table_part_sub_1#p#part_1#sp#part_1sp0
1332 test/table_part_sub_1#p#part_1#sp#part_1sp1
1333 test/table_part_sub_1#p#part_2#sp#part_2sp0
1334 test/table_part_sub_1#p#part_2#sp#part_2sp1
1335 test/table_part_sub_1#p#part_3#sp#part_3sp0
1336 test/table_part_sub_1#p#part_3#sp#part_3sp1
1337 test/table_part_sub_1#p#part_4#sp#part_4sp0
1338 test/table_part_sub_1#p#part_4#sp#part_4sp1
1339 test/table_part_sub_2#p#part_1#sp#sub_1
1340 test/table_part_sub_2#p#part_1#sp#sub_2
1341 test/table_part_sub_2#p#part_2#sp#sub_3
1342 test/table_part_sub_2#p#part_2#sp#sub_4
1343 test/table_part_sub_2#p#part_3#sp#sub_5
1344 test/table_part_sub_2#p#part_3#sp#sub_6
1345 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
1346 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
1347 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
1348 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
1349 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
1350 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
1351
1352 select file_type, status, file_name, tablespace_name from information_schema.files
1353 where file_name LIKE '%table_part%'
1354 order by file_type, status, file_name, tablespace_name;
1355 FILE_TYPE STATUS FILE_NAME TABLESPACE_NAME
1356 TABLESPACE NORMAL ./test/table_part_1#p#p0.ibd test/table_part_1#p#p0
1357 TABLESPACE NORMAL ./test/table_part_1#p#p1.ibd test/table_part_1#p#p1
1358 TABLESPACE NORMAL ./test/table_part_1#p#p2.ibd test/table_part_1#p#p2
1359 TABLESPACE NORMAL ./test/table_part_1#p#p3.ibd test/table_part_1#p#p3
1360 TABLESPACE NORMAL ./test/table_part_1#p#p4.ibd test/table_part_1#p#p4
1361 TABLESPACE NORMAL ./test/table_part_2#p#p0.ibd test/table_part_2#p#p0
1362 TABLESPACE NORMAL ./test/table_part_2#p#p1.ibd test/table_part_2#p#p1
1363 TABLESPACE NORMAL ./test/table_part_2#p#p2.ibd test/table_part_2#p#p2
1364 TABLESPACE NORMAL ./test/table_part_2#p#p3.ibd test/table_part_2#p#p3
1365 TABLESPACE NORMAL ./test/table_part_2#p#p4.ibd test/table_part_2#p#p4
1366 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
1367 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
1368 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
1369 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
1370 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
1371 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
1372 TABLESPACE NORMAL ./test/table_part_cap_6#P#p0.ibd test/table_part_cap_6#p#p0
1373 TABLESPACE NORMAL ./test/table_part_cap_6#P#p1.ibd test/table_part_cap_6#p#p1
1374 TABLESPACE NORMAL ./test/table_part_cap_6#P#p2.ibd test/table_part_cap_6#p#p2
1375 TABLESPACE NORMAL ./test/table_part_cap_6#P#p3.ibd test/table_part_cap_6#p#p3
1376 TABLESPACE NORMAL ./test/table_part_cap_6#P#p4.ibd test/table_part_cap_6#p#p4
1377 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
1378 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
1379 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
1380 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
1381 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
1382 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
1383 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
1384 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
1385 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
1386 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
1387 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
1388 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
1389 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
1390 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
1391
1392 Checking Innodb stat tables
1393 ---------------------------
1394 select database_name, table_name from mysql.innodb_table_stats
1395 where table_name like '%table_part%' order by database_name, table_name;
1396 database_name table_name
1397 test table_part_1#p#p0
1398 test table_part_1#p#p1
1399 test table_part_1#p#p2
1400 test table_part_1#p#p3
1401 test table_part_1#p#p4
1402 test table_part_2#p#p0
1403 test table_part_2#p#p1
1404 test table_part_2#p#p2
1405 test table_part_2#p#p3
1406 test table_part_2#p#p4
1407 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
1408 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
1409 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
1410 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
1411 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
1412 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
1413 test table_part_cap_6#p#p0
1414 test table_part_cap_6#p#p1
1415 test table_part_cap_6#p#p2
1416 test table_part_cap_6#p#p3
1417 test table_part_cap_6#p#p4
1418 test table_part_nopart_cap_7
1419 test table_part_sub_1#p#part_1#sp#part_1sp0
1420 test table_part_sub_1#p#part_1#sp#part_1sp1
1421 test table_part_sub_1#p#part_2#sp#part_2sp0
1422 test table_part_sub_1#p#part_2#sp#part_2sp1
1423 test table_part_sub_1#p#part_3#sp#part_3sp0
1424 test table_part_sub_1#p#part_3#sp#part_3sp1
1425 test table_part_sub_1#p#part_4#sp#part_4sp0
1426 test table_part_sub_1#p#part_4#sp#part_4sp1
1427 test table_part_sub_2#p#part_1#sp#sub_1
1428 test table_part_sub_2#p#part_1#sp#sub_2
1429 test table_part_sub_2#p#part_2#sp#sub_3
1430 test table_part_sub_2#p#part_2#sp#sub_4
1431 test table_part_sub_2#p#part_3#sp#sub_5
1432 test table_part_sub_2#p#part_3#sp#sub_6
1433
1434 select database_name, table_name, index_name, stat_name from mysql.innodb_index_stats
1435 where table_name like '%table_part%'
1436 order by database_name, table_name, index_name, stat_name;
1437 database_name table_name index_name stat_name
1438 test table_part_1#p#p0 PRIMARY n_diff_pfx01
1439 test table_part_1#p#p0 PRIMARY n_leaf_pages
1440 test table_part_1#p#p0 PRIMARY size
1441 test table_part_1#p#p0 k1 n_diff_pfx01
1442 test table_part_1#p#p0 k1 n_diff_pfx02
1443 test table_part_1#p#p0 k1 n_leaf_pages
1444 test table_part_1#p#p0 k1 size
1445 test table_part_1#p#p1 PRIMARY n_diff_pfx01
1446 test table_part_1#p#p1 PRIMARY n_leaf_pages
1447 test table_part_1#p#p1 PRIMARY size
1448 test table_part_1#p#p1 k1 n_diff_pfx01
1449 test table_part_1#p#p1 k1 n_diff_pfx02
1450 test table_part_1#p#p1 k1 n_leaf_pages
1451 test table_part_1#p#p1 k1 size
1452 test table_part_1#p#p2 PRIMARY n_diff_pfx01
1453 test table_part_1#p#p2 PRIMARY n_leaf_pages
1454 test table_part_1#p#p2 PRIMARY size
1455 test table_part_1#p#p2 k1 n_diff_pfx01
1456 test table_part_1#p#p2 k1 n_diff_pfx02
1457 test table_part_1#p#p2 k1 n_leaf_pages
1458 test table_part_1#p#p2 k1 size
1459 test table_part_1#p#p3 PRIMARY n_diff_pfx01
1460 test table_part_1#p#p3 PRIMARY n_leaf_pages
1461 test table_part_1#p#p3 PRIMARY size
1462 test table_part_1#p#p3 k1 n_diff_pfx01
1463 test table_part_1#p#p3 k1 n_diff_pfx02
1464 test table_part_1#p#p3 k1 n_leaf_pages
1465 test table_part_1#p#p3 k1 size
1466 test table_part_1#p#p4 PRIMARY n_diff_pfx01
1467 test table_part_1#p#p4 PRIMARY n_leaf_pages
1468 test table_part_1#p#p4 PRIMARY size
1469 test table_part_1#p#p4 k1 n_diff_pfx01
1470 test table_part_1#p#p4 k1 n_diff_pfx02
1471 test table_part_1#p#p4 k1 n_leaf_pages
1472 test table_part_1#p#p4 k1 size
1473 test table_part_2#p#p0 PRIMARY n_diff_pfx01
1474 test table_part_2#p#p0 PRIMARY n_leaf_pages
1475 test table_part_2#p#p0 PRIMARY size
1476 test table_part_2#p#p0 k1 n_diff_pfx01
1477 test table_part_2#p#p0 k1 n_diff_pfx02
1478 test table_part_2#p#p0 k1 n_leaf_pages
1479 test table_part_2#p#p0 k1 size
1480 test table_part_2#p#p1 PRIMARY n_diff_pfx01
1481 test table_part_2#p#p1 PRIMARY n_leaf_pages
1482 test table_part_2#p#p1 PRIMARY size
1483 test table_part_2#p#p1 k1 n_diff_pfx01
1484 test table_part_2#p#p1 k1 n_diff_pfx02
1485 test table_part_2#p#p1 k1 n_leaf_pages
1486 test table_part_2#p#p1 k1 size
1487 test table_part_2#p#p2 PRIMARY n_diff_pfx01
1488 test table_part_2#p#p2 PRIMARY n_leaf_pages
1489 test table_part_2#p#p2 PRIMARY size
1490 test table_part_2#p#p2 k1 n_diff_pfx01
1491 test table_part_2#p#p2 k1 n_diff_pfx02
1492 test table_part_2#p#p2 k1 n_leaf_pages
1493 test table_part_2#p#p2 k1 size
1494 test table_part_2#p#p3 PRIMARY n_diff_pfx01
1495 test table_part_2#p#p3 PRIMARY n_leaf_pages
1496 test table_part_2#p#p3 PRIMARY size
1497 test table_part_2#p#p3 k1 n_diff_pfx01
1498 test table_part_2#p#p3 k1 n_diff_pfx02
1499 test table_part_2#p#p3 k1 n_leaf_pages
1500 test table_part_2#p#p3 k1 size
1501 test table_part_2#p#p4 PRIMARY n_diff_pfx01
1502 test table_part_2#p#p4 PRIMARY n_leaf_pages
1503 test table_part_2#p#p4 PRIMARY size
1504 test table_part_2#p#p4 k1 n_diff_pfx01
1505 test table_part_2#p#p4 k1 n_diff_pfx02
1506 test table_part_2#p#p4 k1 n_leaf_pages
1507 test table_part_2#p#p4 k1 size
1508 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx01
1509 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx02
1510 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_leaf_pages
1511 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY size
1512 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx01
1513 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx02
1514 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_leaf_pages
1515 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 size
1516 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx01
1517 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx02
1518 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_leaf_pages
1519 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY size
1520 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx01
1521 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx02
1522 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_leaf_pages
1523 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 size
1524 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx01
1525 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx02
1526 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_leaf_pages
1527 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY size
1528 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx01
1529 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx02
1530 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_leaf_pages
1531 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 size
1532 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx01
1533 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx02
1534 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_leaf_pages
1535 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY size
1536 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx01
1537 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx02
1538 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_leaf_pages
1539 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 size
1540 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx01
1541 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx02
1542 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_leaf_pages
1543 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY size
1544 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx01
1545 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx02
1546 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_leaf_pages
1547 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 size
1548 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx01
1549 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx02
1550 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_leaf_pages
1551 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY size
1552 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx01
1553 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx02
1554 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_leaf_pages
1555 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 size
1556 test table_part_cap_6#p#p0 PRIMARY n_diff_pfx01
1557 test table_part_cap_6#p#p0 PRIMARY n_leaf_pages
1558 test table_part_cap_6#p#p0 PRIMARY size
1559 test table_part_cap_6#p#p0 k1 n_diff_pfx01
1560 test table_part_cap_6#p#p0 k1 n_diff_pfx02
1561 test table_part_cap_6#p#p0 k1 n_leaf_pages
1562 test table_part_cap_6#p#p0 k1 size
1563 test table_part_cap_6#p#p1 PRIMARY n_diff_pfx01
1564 test table_part_cap_6#p#p1 PRIMARY n_leaf_pages
1565 test table_part_cap_6#p#p1 PRIMARY size
1566 test table_part_cap_6#p#p1 k1 n_diff_pfx01
1567 test table_part_cap_6#p#p1 k1 n_diff_pfx02
1568 test table_part_cap_6#p#p1 k1 n_leaf_pages
1569 test table_part_cap_6#p#p1 k1 size
1570 test table_part_cap_6#p#p2 PRIMARY n_diff_pfx01
1571 test table_part_cap_6#p#p2 PRIMARY n_leaf_pages
1572 test table_part_cap_6#p#p2 PRIMARY size
1573 test table_part_cap_6#p#p2 k1 n_diff_pfx01
1574 test table_part_cap_6#p#p2 k1 n_diff_pfx02
1575 test table_part_cap_6#p#p2 k1 n_leaf_pages
1576 test table_part_cap_6#p#p2 k1 size
1577 test table_part_cap_6#p#p3 PRIMARY n_diff_pfx01
1578 test table_part_cap_6#p#p3 PRIMARY n_leaf_pages
1579 test table_part_cap_6#p#p3 PRIMARY size
1580 test table_part_cap_6#p#p3 k1 n_diff_pfx01
1581 test table_part_cap_6#p#p3 k1 n_diff_pfx02
1582 test table_part_cap_6#p#p3 k1 n_leaf_pages
1583 test table_part_cap_6#p#p3 k1 size
1584 test table_part_cap_6#p#p4 PRIMARY n_diff_pfx01
1585 test table_part_cap_6#p#p4 PRIMARY n_leaf_pages
1586 test table_part_cap_6#p#p4 PRIMARY size
1587 test table_part_cap_6#p#p4 k1 n_diff_pfx01
1588 test table_part_cap_6#p#p4 k1 n_diff_pfx02
1589 test table_part_cap_6#p#p4 k1 n_leaf_pages
1590 test table_part_cap_6#p#p4 k1 size
1591 test table_part_nopart_cap_7 PRIMARY n_diff_pfx01
1592 test table_part_nopart_cap_7 PRIMARY n_leaf_pages
1593 test table_part_nopart_cap_7 PRIMARY size
1594 test table_part_nopart_cap_7 k1 n_diff_pfx01
1595 test table_part_nopart_cap_7 k1 n_diff_pfx02
1596 test table_part_nopart_cap_7 k1 n_leaf_pages
1597 test table_part_nopart_cap_7 k1 size
1598 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx01
1599 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx02
1600 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_leaf_pages
1601 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY size
1602 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx01
1603 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx02
1604 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_leaf_pages
1605 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 size
1606 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx01
1607 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx02
1608 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_leaf_pages
1609 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY size
1610 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx01
1611 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx02
1612 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_leaf_pages
1613 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 size
1614 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx01
1615 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx02
1616 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_leaf_pages
1617 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY size
1618 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx01
1619 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx02
1620 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_leaf_pages
1621 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 size
1622 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx01
1623 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx02
1624 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_leaf_pages
1625 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY size
1626 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx01
1627 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx02
1628 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_leaf_pages
1629 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 size
1630 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx01
1631 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx02
1632 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_leaf_pages
1633 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY size
1634 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx01
1635 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx02
1636 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_leaf_pages
1637 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 size
1638 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx01
1639 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx02
1640 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_leaf_pages
1641 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY size
1642 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx01
1643 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx02
1644 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_leaf_pages
1645 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 size
1646 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx01
1647 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx02
1648 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_leaf_pages
1649 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY size
1650 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx01
1651 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx02
1652 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_leaf_pages
1653 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 size
1654 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx01
1655 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx02
1656 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_leaf_pages
1657 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY size
1658 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx01
1659 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx02
1660 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_leaf_pages
1661 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 size
1662 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx01
1663 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx02
1664 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_leaf_pages
1665 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY size
1666 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx01
1667 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx02
1668 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_leaf_pages
1669 test table_part_sub_2#p#part_1#sp#sub_1 k1 size
1670 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx01
1671 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx02
1672 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_leaf_pages
1673 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY size
1674 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx01
1675 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx02
1676 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_leaf_pages
1677 test table_part_sub_2#p#part_1#sp#sub_2 k1 size
1678 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx01
1679 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx02
1680 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_leaf_pages
1681 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY size
1682 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx01
1683 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx02
1684 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_leaf_pages
1685 test table_part_sub_2#p#part_2#sp#sub_3 k1 size
1686 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx01
1687 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx02
1688 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_leaf_pages
1689 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY size
1690 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx01
1691 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx02
1692 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_leaf_pages
1693 test table_part_sub_2#p#part_2#sp#sub_4 k1 size
1694 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx01
1695 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx02
1696 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_leaf_pages
1697 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY size
1698 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx01
1699 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx02
1700 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_leaf_pages
1701 test table_part_sub_2#p#part_3#sp#sub_5 k1 size
1702 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx01
1703 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx02
1704 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_leaf_pages
1705 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY size
1706 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx01
1707 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx02
1708 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_leaf_pages
1709 test table_part_sub_2#p#part_3#sp#sub_6 k1 size
1710 SET NAMES DEFAULT;
1711 # 2. Do DML insert/update/delete on upgraded tables
1712 DML on partitioned tables
1713 -------------------------
1714
1715 insert into table_part_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1716
1717 update table_part_1 set name = 'Row - updated' where value > 500;
1718
1719 delete from table_part_1 where id = 7;
1720
1721 insert into table_part_sub_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1722
1723 update table_part_sub_1 set name = 'Row - updated' where value > 500;
1724
1725 delete from table_part_sub_1 where id = 7;
1726
1727 insert into table_part_sub_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1728
1729 update table_part_sub_2 set name = 'Row - updated' where value > 500;
1730
1731 delete from table_part_sub_2 where id = 7;
1732
1733 insert into `table_part_\_special_/_sub_?_3` values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1734
1735 update `table_part_\_special_/_sub_?_3` set name = 'Row - updated' where value > 500;
1736
1737 delete from `table_part_\_special_/_sub_?_3` where id = 7;
1738
1739 insert into table_part_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));
1740
1741 update table_part_2 set name = 'Row - updated' where value > 500;
1742
1743 delete from table_part_2 where id = 7;
1744 # 3. Do DDL ALTER/DROP on upgraded tables
1745 DDL on partitioned tables
1746 -------------------------
1747 ALTER TABLE table_part_1 TRUNCATE PARTITION p0;
1748
1749 ALTER TABLE table_part_1 COALESCE PARTITION 2;
1750
1751 SHOW CREATE TABLE table_part_1;
1752 Table Create Table
1753 table_part_1 CREATE TABLE `table_part_1` (
1754 `id` int NOT NULL,
1755 `value` int DEFAULT NULL,
1756 `name` varchar(32) DEFAULT NULL,
1757 `data` blob,
1758 PRIMARY KEY (`id`),
1759 KEY `k1` (`value`)
1760 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1761 /*!50100 PARTITION BY HASH (`id`)
1762 PARTITIONS 3 */
1763
1764 ALTER TABLE table_part_sub_1 TRUNCATE PARTITION part_1;
1765
1766 ALTER TABLE table_part_sub_2 TRUNCATE PARTITION part_3;
1767
1768 CREATE TABLE test_table LIKE table_part_sub_2;
1769
1770 ALTER TABLE test_table REMOVE PARTITIONING;
1771 insert into test_table values(2, 265, "Row - 2", REPEAT('Large Column Data - 2' , 256));
1772
1773 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
1774 id value name
1775 2 255 Row - 2
1776 4 455 Row - 4
1777
1778 SELECT id, value, name FROM test_table order by id;
1779 id value name
1780 2 265 Row - 2
1781
1782 ALTER TABLE table_part_sub_2 EXCHANGE PARTITION sub_3 WITH TABLE test_table;
1783
1784 SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
1785 id value name
1786 2 265 Row - 2
1787
1788 SELECT id, value, name FROM test_table order by id;
1789 id value name
1790 2 255 Row - 2
1791 4 455 Row - 4
1792
1793 DROP TABLE test_table;
1794
1795 ALTER TABLE table_part_sub_2 RENAME renamed_table;;
1796 SHOW CREATE TABLE renamed_table;
1797 Table Create Table
1798 renamed_table CREATE TABLE `renamed_table` (
1799 `id` int NOT NULL,
1800 `value` int NOT NULL,
1801 `name` varchar(32) DEFAULT NULL,
1802 `data` blob,
1803 PRIMARY KEY (`id`,`value`),
1804 KEY `k1` (`value`)
1805 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1806 /*!50100 PARTITION BY RANGE (`value`)
1807 SUBPARTITION BY HASH (`id`)
1808 (PARTITION Part_1 VALUES LESS THAN (101)
1809 (SUBPARTITION Sub_1 ENGINE = InnoDB,
1810 SUBPARTITION sUb_2 ENGINE = InnoDB),
1811 PARTITION pArt_2 VALUES LESS THAN (501)
1812 (SUBPARTITION suB_3 ENGINE = InnoDB,
1813 SUBPARTITION SUB_4 ENGINE = InnoDB),
1814 PARTITION PART_3 VALUES LESS THAN MAXVALUE
1815 (SUBPARTITION SUB_5 ENGINE = InnoDB,
1816 SUBPARTITION sub_6 ENGINE = InnoDB)) */
1817
1818 ALTER TABLE renamed_table RENAME table_part_sub_2;;
1819
1820 ALTER TABLE table_part_1 ENGINE = InnoDB;;
1821
1822 ALTER TABLE table_part_1 ADD COLUMN new_id int AFTER id;
1823
1824 ALTER TABLE table_part_1 REMOVE PARTITIONING;
1825
1826 ALTER TABLE table_part_sub_1 ENGINE = InnoDB;;
1827
1828 ALTER TABLE table_part_sub_1 ADD COLUMN new_id int AFTER id;
1829
1830 ALTER TABLE table_part_sub_1 REMOVE PARTITIONING;
1831
1832 ALTER TABLE table_part_sub_2 ENGINE = InnoDB;;
1833
1834 ALTER TABLE table_part_sub_2 ADD COLUMN new_id int AFTER id;
1835
1836 ALTER TABLE table_part_sub_2 REMOVE PARTITIONING;
1837
1838 ALTER TABLE `table_part_\_special_/_sub_?_3` ENGINE = InnoDB;;
1839
1840 ALTER TABLE `table_part_\_special_/_sub_?_3` ADD COLUMN new_id int AFTER id;
1841
1842 ALTER TABLE `table_part_\_special_/_sub_?_3` REMOVE PARTITIONING;
1843
1844 ALTER TABLE table_part_2 ENGINE = InnoDB;;
1845
1846 ALTER TABLE table_part_2 ADD COLUMN new_id int AFTER id;
1847
1848 ALTER TABLE table_part_2 REMOVE PARTITIONING;
1849
1850 # Shutdown server
1851
1852 # Remove upgraded data directory.
1853
1854 # Cleanup: Restart with default options.
1855 # restart