Debian Codegraph @

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

raw
1 # Test to create schema for Upgrade in old version
2 select case when @@version like "5.7.27%" then '5727'
3 when @@version like "8.0.13%" then '8013'
4 when @@version like "8.0.15%" then '8015'
5 when @@version like "8.0.17%" then '8017'
6 when @@version like "8.0.19%" then '8019'
7 else 'none' end as VERSION into @current_server_version;
8 # Starting server with keyring plugin
9 # restart: --innodb_directories=/tmp/mysql_wl13352_data/ --early-plugin-load=keyring_file=keyring_file.so --loose-keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring --plugin-dir=KEYRING_PLUGIN_PATH
10
11 # A. Create tables for upgrade and fill data
12 Creating partitioned tables
13 ---------------------------
14 CREATE TABLE table_part_1(
15 id int primary key, value int, name varchar(32), data BLOB,
16 key k1(value)) partition by hash (id) partitions 5;
17
18 CREATE TABLE table_part_2(
19 id int primary key, value int, name varchar(32), data BLOB,
20 key k1(value)) DATA DIRECTORY = '/tmp/mysql_wl13352_data/'
21 partition by hash (id) partitions 5;
22
23 CREATE TABLE table_part_sub_1(
24 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
25 key k1(value)) partition by range (value) subpartition by hash (id)
26 subpartitions 2 ( partition Part_1 values less than (101),
27 partition pArt_2 values less than (401),
28 partition part_3 values less than (701),
29 partition PART_4 values less than MAXVALUE);
30
31 CREATE TABLE table_part_sub_2(
32 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
33 key k1(value)) partition by range (value) subpartition by hash (id)
34 ( partition Part_1 values less than (101)(
35 subpartition Sub_1,
36 subpartition sUb_2),
37 partition pArt_2 values less than (501)(
38 subpartition suB_3 DATA DIRECTORY = '/tmp/mysql_wl13352_data/',
39 subpartition SUB_4),
40 partition PART_3 values less than MAXVALUE(
41 subpartition SUB_5,
42 subpartition sub_6));
43
44 CREATE TABLE `table_part_\_special_/_sub_?_3`(
45 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
46 key k1(value)) partition by range (value) subpartition by hash (id)
47 ( partition `Part_?_1` values less than (201)(
48 subpartition `Sub_?_1`,
49 subpartition `sUb_/_2`),
50 partition `pArt_\_2` values less than (501)(
51 subpartition `suB_\_3`,
52 subpartition `SUB_?\_4`),
53 partition `PART_/_3` values less than MAXVALUE(
54 subpartition `SUB_?/_5`,
55 subpartition `sub_\/?_6`));
56 CREATE TABLESPACE SPACE_part add datafile 'SPACE_part_1.ibd';
57 CREATE TABLE table_part_CAP_6(
58 id int primary key, value int, name varchar(32), data BLOB,
59 key k1(value)) partition by hash (id) partitions 5;
60 CREATE TABLE table_part_NOPART_CAP_7(
61 id int primary key, value int, name varchar(32), data BLOB,
62 key k1(value)) TABLESPACE SPACE_part;
63
64 Inserting 10 rows to table_part_1
65 ---------------------------------------
66 insert into table_part_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
67 insert into table_part_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
68 insert into table_part_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
69 insert into table_part_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
70 insert into table_part_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
71 insert into table_part_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
72 insert into table_part_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
73 insert into table_part_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
74 insert into table_part_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
75 insert into table_part_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
76
77 Inserting 10 rows to table_part_sub_1
78 ---------------------------------------
79 insert into table_part_sub_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
80 insert into table_part_sub_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
81 insert into table_part_sub_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
82 insert into table_part_sub_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
83 insert into table_part_sub_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
84 insert into table_part_sub_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
85 insert into table_part_sub_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
86 insert into table_part_sub_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
87 insert into table_part_sub_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
88 insert into table_part_sub_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
89
90 Inserting 10 rows to table_part_sub_2
91 ---------------------------------------
92 insert into table_part_sub_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
93 insert into table_part_sub_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
94 insert into table_part_sub_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
95 insert into table_part_sub_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
96 insert into table_part_sub_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
97 insert into table_part_sub_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
98 insert into table_part_sub_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
99 insert into table_part_sub_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
100 insert into table_part_sub_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
101 insert into table_part_sub_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
102
103 Inserting 10 rows to `table_part_\_special_/_sub_?_3`
104 ---------------------------------------
105 insert into `table_part_\_special_/_sub_?_3` VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
106 insert into `table_part_\_special_/_sub_?_3` VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
107 insert into `table_part_\_special_/_sub_?_3` VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
108 insert into `table_part_\_special_/_sub_?_3` VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
109 insert into `table_part_\_special_/_sub_?_3` VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
110 insert into `table_part_\_special_/_sub_?_3` VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
111 insert into `table_part_\_special_/_sub_?_3` VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
112 insert into `table_part_\_special_/_sub_?_3` VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
113 insert into `table_part_\_special_/_sub_?_3` VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
114 insert into `table_part_\_special_/_sub_?_3` VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
115
116 Inserting 10 rows to table_part_2
117 ---------------------------------------
118 insert into table_part_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
119 insert into table_part_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
120 insert into table_part_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
121 insert into table_part_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
122 insert into table_part_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
123 insert into table_part_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
124 insert into table_part_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
125 insert into table_part_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
126 insert into table_part_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
127 insert into table_part_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
128
129 Inserting 10 rows to table_part_CAP_6
130 ---------------------------------------
131 insert into table_part_CAP_6 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
132 insert into table_part_CAP_6 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
133 insert into table_part_CAP_6 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
134 insert into table_part_CAP_6 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
135 insert into table_part_CAP_6 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
136 insert into table_part_CAP_6 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
137 insert into table_part_CAP_6 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
138 insert into table_part_CAP_6 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
139 insert into table_part_CAP_6 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
140 insert into table_part_CAP_6 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
141
142 Inserting 10 rows to table_part_NOPART_CAP_7
143 ---------------------------------------
144 insert into table_part_NOPART_CAP_7 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
145 insert into table_part_NOPART_CAP_7 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
146 insert into table_part_NOPART_CAP_7 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
147 insert into table_part_NOPART_CAP_7 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
148 insert into table_part_NOPART_CAP_7 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
149 insert into table_part_NOPART_CAP_7 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
150 insert into table_part_NOPART_CAP_7 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
151 insert into table_part_NOPART_CAP_7 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
152 insert into table_part_NOPART_CAP_7 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
153 insert into table_part_NOPART_CAP_7 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
154 select id, value, name from table_part_sub_2 partition (sub_1) order by id;
155 id value name
156 0 55 Row - 0
157 select id, value, name from table_part_sub_2 partition (sub_2) order by id;
158 id value name
159 select id, value, name from table_part_sub_2 partition (sub_3) order by id;
160 id value name
161 2 255 Row - 2
162 4 455 Row - 4
163 select id, value, name from table_part_sub_2 partition (sub_4) order by id;
164 id value name
165 1 155 Row - 1
166 3 355 Row - 3
167 select id, value, name from table_part_sub_2 partition (sub_5) order by id;
168 id value name
169 6 655 Row - 6
170 8 855 Row - 8
171 select id, value, name from table_part_sub_2 partition (sub_6) order by id;
172 id value name
173 5 555 Row - 5
174 7 755 Row - 7
175 9 955 Row - 9
176
177 # Export table partitions
178 CREATE TABLE table_part_encrypt(
179 id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
180 key k1(value)) ENCRYPTION = 'Y'
181 partition by range (value) subpartition by hash (id)
182 ( partition Part_1 values less than (101)(
183 subpartition Sub_1,
184 subpartition sUb_2),
185 partition pArt_2 values less than (501)(
186 subpartition suB_3 DATA DIRECTORY = '/tmp/mysql_wl13352_data/',
187 subpartition SUB_4),
188 partition PART_3 values less than MAXVALUE(
189 subpartition SUB_5,
190 subpartition sub_6));
191 INSERT INTO table_part_encrypt SELECT * FROM table_part_sub_2;
192 FLUSH TABLES table_part_encrypt, table_part_sub_2 FOR EXPORT;
193 UNLOCK TABLES;
194 DROP TABLE table_part_encrypt;
195
196 # Check table metadata and data
197 Checking partitioned tables
198 ---------------------------
199 SET NAMES utf8mb4 COLLATE utf8mb4_0900_as_cs;
200
201 CHECK TABLE table_part_1;
202 Table Op Msg_type Msg_text
203 test.table_part_1 check status OK
204
205 SHOW CREATE TABLE table_part_1;
206 Table Create Table
207 table_part_1 CREATE TABLE `table_part_1` (
208 `id` int NOT NULL,
209 `value` int DEFAULT NULL,
210 `name` varchar(32) DEFAULT NULL,
211 `data` blob,
212 PRIMARY KEY (`id`),
213 KEY `k1` (`value`)
214 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
215 /*!50100 PARTITION BY HASH (`id`)
216 PARTITIONS 5 */
217
218 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_1 order by id;
219 id value name SUBSTRING(data, 1024, 32)
220 0 55 Row - 0 ta - 0Large Column Data - 0Large
221 1 155 Row - 1 ta - 1Large Column Data - 1Large
222 2 255 Row - 2 ta - 2Large Column Data - 2Large
223 3 355 Row - 3 ta - 3Large Column Data - 3Large
224 4 455 Row - 4 ta - 4Large Column Data - 4Large
225 5 555 Row - 5 ta - 5Large Column Data - 5Large
226 6 655 Row - 6 ta - 6Large Column Data - 6Large
227 7 755 Row - 7 ta - 7Large Column Data - 7Large
228 8 855 Row - 8 ta - 8Large Column Data - 8Large
229 9 955 Row - 9 ta - 9Large Column Data - 9Large
230
231 CHECK TABLE table_part_sub_1;
232 Table Op Msg_type Msg_text
233 test.table_part_sub_1 check status OK
234
235 SHOW CREATE TABLE table_part_sub_1;
236 Table Create Table
237 table_part_sub_1 CREATE TABLE `table_part_sub_1` (
238 `id` int NOT NULL,
239 `value` int NOT NULL,
240 `name` varchar(32) DEFAULT NULL,
241 `data` blob,
242 PRIMARY KEY (`id`,`value`),
243 KEY `k1` (`value`)
244 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
245 /*!50100 PARTITION BY RANGE (`value`)
246 SUBPARTITION BY HASH (`id`)
247 SUBPARTITIONS 2
248 (PARTITION Part_1 VALUES LESS THAN (101) ENGINE = InnoDB,
249 PARTITION pArt_2 VALUES LESS THAN (401) ENGINE = InnoDB,
250 PARTITION part_3 VALUES LESS THAN (701) ENGINE = InnoDB,
251 PARTITION PART_4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
252
253 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_1 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 CHECK TABLE table_part_sub_2;
267 Table Op Msg_type Msg_text
268 test.table_part_sub_2 check status OK
269
270 SHOW CREATE TABLE table_part_sub_2;
271 Table Create Table
272 table_part_sub_2 CREATE TABLE `table_part_sub_2` (
273 `id` int NOT NULL,
274 `value` int NOT NULL,
275 `name` varchar(32) DEFAULT NULL,
276 `data` blob,
277 PRIMARY KEY (`id`,`value`),
278 KEY `k1` (`value`)
279 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
280 /*!50100 PARTITION BY RANGE (`value`)
281 SUBPARTITION BY HASH (`id`)
282 (PARTITION Part_1 VALUES LESS THAN (101)
283 (SUBPARTITION Sub_1 ENGINE = InnoDB,
284 SUBPARTITION sUb_2 ENGINE = InnoDB),
285 PARTITION pArt_2 VALUES LESS THAN (501)
286 (SUBPARTITION suB_3 DATA DIRECTORY = '/tmp/mysql_wl13352_data/' ENGINE = InnoDB,
287 SUBPARTITION SUB_4 ENGINE = InnoDB),
288 PARTITION PART_3 VALUES LESS THAN MAXVALUE
289 (SUBPARTITION SUB_5 ENGINE = InnoDB,
290 SUBPARTITION sub_6 ENGINE = InnoDB)) */
291
292 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_2 order by id;
293 id value name SUBSTRING(data, 1024, 32)
294 0 55 Row - 0 ta - 0Large Column Data - 0Large
295 1 155 Row - 1 ta - 1Large Column Data - 1Large
296 2 255 Row - 2 ta - 2Large Column Data - 2Large
297 3 355 Row - 3 ta - 3Large Column Data - 3Large
298 4 455 Row - 4 ta - 4Large Column Data - 4Large
299 5 555 Row - 5 ta - 5Large Column Data - 5Large
300 6 655 Row - 6 ta - 6Large Column Data - 6Large
301 7 755 Row - 7 ta - 7Large Column Data - 7Large
302 8 855 Row - 8 ta - 8Large Column Data - 8Large
303 9 955 Row - 9 ta - 9Large Column Data - 9Large
304
305 CHECK TABLE `table_part_\_special_/_sub_?_3`;
306 Table Op Msg_type Msg_text
307 test.table_part_\_special_/_sub_?_3 check status OK
308
309 SHOW CREATE TABLE `table_part_\_special_/_sub_?_3`;
310 Table Create Table
311 table_part_\_special_/_sub_?_3 CREATE TABLE `table_part_\_special_/_sub_?_3` (
312 `id` int NOT NULL,
313 `value` int NOT NULL,
314 `name` varchar(32) DEFAULT NULL,
315 `data` blob,
316 PRIMARY KEY (`id`,`value`),
317 KEY `k1` (`value`)
318 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
319 /*!50100 PARTITION BY RANGE (`value`)
320 SUBPARTITION BY HASH (`id`)
321 (PARTITION `Part_?_1` VALUES LESS THAN (201)
322 (SUBPARTITION `Sub_?_1` ENGINE = InnoDB,
323 SUBPARTITION `sUb_/_2` ENGINE = InnoDB),
324 PARTITION `pArt_\_2` VALUES LESS THAN (501)
325 (SUBPARTITION `suB_\_3` ENGINE = InnoDB,
326 SUBPARTITION `SUB_?\_4` ENGINE = InnoDB),
327 PARTITION `PART_/_3` VALUES LESS THAN MAXVALUE
328 (SUBPARTITION `SUB_?/_5` ENGINE = InnoDB,
329 SUBPARTITION `sub_\/?_6` ENGINE = InnoDB)) */
330
331 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM `table_part_\_special_/_sub_?_3` order by id;
332 id value name SUBSTRING(data, 1024, 32)
333 0 55 Row - 0 ta - 0Large Column Data - 0Large
334 1 155 Row - 1 ta - 1Large Column Data - 1Large
335 2 255 Row - 2 ta - 2Large Column Data - 2Large
336 3 355 Row - 3 ta - 3Large Column Data - 3Large
337 4 455 Row - 4 ta - 4Large Column Data - 4Large
338 5 555 Row - 5 ta - 5Large Column Data - 5Large
339 6 655 Row - 6 ta - 6Large Column Data - 6Large
340 7 755 Row - 7 ta - 7Large Column Data - 7Large
341 8 855 Row - 8 ta - 8Large Column Data - 8Large
342 9 955 Row - 9 ta - 9Large Column Data - 9Large
343
344 CHECK TABLE table_part_2;
345 Table Op Msg_type Msg_text
346 test.table_part_2 check status OK
347
348 SHOW CREATE TABLE table_part_2;
349 Table Create Table
350 table_part_2 CREATE TABLE `table_part_2` (
351 `id` int NOT NULL,
352 `value` int DEFAULT NULL,
353 `name` varchar(32) DEFAULT NULL,
354 `data` blob,
355 PRIMARY KEY (`id`),
356 KEY `k1` (`value`)
357 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
358 /*!50100 PARTITION BY HASH (`id`)
359 PARTITIONS 5 */
360
361 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_2 order by id;
362 id value name SUBSTRING(data, 1024, 32)
363 0 55 Row - 0 ta - 0Large Column Data - 0Large
364 1 155 Row - 1 ta - 1Large Column Data - 1Large
365 2 255 Row - 2 ta - 2Large Column Data - 2Large
366 3 355 Row - 3 ta - 3Large Column Data - 3Large
367 4 455 Row - 4 ta - 4Large Column Data - 4Large
368 5 555 Row - 5 ta - 5Large Column Data - 5Large
369 6 655 Row - 6 ta - 6Large Column Data - 6Large
370 7 755 Row - 7 ta - 7Large Column Data - 7Large
371 8 855 Row - 8 ta - 8Large Column Data - 8Large
372 9 955 Row - 9 ta - 9Large Column Data - 9Large
373
374 CHECK TABLE table_part_CAP_6;
375 Table Op Msg_type Msg_text
376 test.table_part_CAP_6 check status OK
377
378 SHOW CREATE TABLE table_part_CAP_6;
379 Table Create Table
380 table_part_CAP_6 CREATE TABLE `table_part_CAP_6` (
381 `id` int NOT NULL,
382 `value` int DEFAULT NULL,
383 `name` varchar(32) DEFAULT NULL,
384 `data` blob,
385 PRIMARY KEY (`id`),
386 KEY `k1` (`value`)
387 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
388 /*!50100 PARTITION BY HASH (`id`)
389 PARTITIONS 5 */
390
391 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_CAP_6 order by id;
392 id value name SUBSTRING(data, 1024, 32)
393 0 55 Row - 0 ta - 0Large Column Data - 0Large
394 1 155 Row - 1 ta - 1Large Column Data - 1Large
395 2 255 Row - 2 ta - 2Large Column Data - 2Large
396 3 355 Row - 3 ta - 3Large Column Data - 3Large
397 4 455 Row - 4 ta - 4Large Column Data - 4Large
398 5 555 Row - 5 ta - 5Large Column Data - 5Large
399 6 655 Row - 6 ta - 6Large Column Data - 6Large
400 7 755 Row - 7 ta - 7Large Column Data - 7Large
401 8 855 Row - 8 ta - 8Large Column Data - 8Large
402 9 955 Row - 9 ta - 9Large Column Data - 9Large
403
404 CHECK TABLE table_part_NOPART_CAP_7;
405 Table Op Msg_type Msg_text
406 test.table_part_NOPART_CAP_7 check status OK
407
408 SHOW CREATE TABLE table_part_NOPART_CAP_7;
409 Table Create Table
410 table_part_NOPART_CAP_7 CREATE TABLE `table_part_NOPART_CAP_7` (
411 `id` int NOT NULL,
412 `value` int DEFAULT NULL,
413 `name` varchar(32) DEFAULT NULL,
414 `data` blob,
415 PRIMARY KEY (`id`),
416 KEY `k1` (`value`)
417 ) /*!50100 TABLESPACE `SPACE_part` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
418
419 SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_NOPART_CAP_7 order by id;
420 id value name SUBSTRING(data, 1024, 32)
421 0 55 Row - 0 ta - 0Large Column Data - 0Large
422 1 155 Row - 1 ta - 1Large Column Data - 1Large
423 2 255 Row - 2 ta - 2Large Column Data - 2Large
424 3 355 Row - 3 ta - 3Large Column Data - 3Large
425 4 455 Row - 4 ta - 4Large Column Data - 4Large
426 5 555 Row - 5 ta - 5Large Column Data - 5Large
427 6 655 Row - 6 ta - 6Large Column Data - 6Large
428 7 755 Row - 7 ta - 7Large Column Data - 7Large
429 8 855 Row - 8 ta - 8Large Column Data - 8Large
430 9 955 Row - 9 ta - 9Large Column Data - 9Large
431
432 Checking IFS views
433 ------------------
434 select table_schema, table_name from information_schema.tables
435 where table_name LIKE '%table_part%' order by table_schema, table_name;
436 TABLE_SCHEMA TABLE_NAME
437 test table_part_1
438 test table_part_2
439 test table_part_CAP_6
440 test table_part_NOPART_CAP_7
441 test table_part_\_special_/_sub_?_3
442 test table_part_sub_1
443 test table_part_sub_2
444
445 select name, space_type from information_schema.innodb_tables
446 where name LIKE '%table_part%' order by name, space_type;
447 name space_type
448 test/table_part_1#p#p0 Single
449 test/table_part_1#p#p1 Single
450 test/table_part_1#p#p2 Single
451 test/table_part_1#p#p3 Single
452 test/table_part_1#p#p4 Single
453 test/table_part_2#p#p0 Single
454 test/table_part_2#p#p1 Single
455 test/table_part_2#p#p2 Single
456 test/table_part_2#p#p3 Single
457 test/table_part_2#p#p4 Single
458 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5 Single
459 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6 Single
460 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2 Single
461 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1 Single
462 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4 Single
463 test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3 Single
464 test/table_part_CAP_6#p#p0 Single
465 test/table_part_CAP_6#p#p1 Single
466 test/table_part_CAP_6#p#p2 Single
467 test/table_part_CAP_6#p#p3 Single
468 test/table_part_CAP_6#p#p4 Single
469 test/table_part_NOPART_CAP_7 General
470 test/table_part_sub_1#p#part_1#sp#part_1sp0 Single
471 test/table_part_sub_1#p#part_1#sp#part_1sp1 Single
472 test/table_part_sub_1#p#part_2#sp#part_2sp0 Single
473 test/table_part_sub_1#p#part_2#sp#part_2sp1 Single
474 test/table_part_sub_1#p#part_3#sp#part_3sp0 Single
475 test/table_part_sub_1#p#part_3#sp#part_3sp1 Single
476 test/table_part_sub_1#p#part_4#sp#part_4sp0 Single
477 test/table_part_sub_1#p#part_4#sp#part_4sp1 Single
478 test/table_part_sub_2#p#part_1#sp#sub_1 Single
479 test/table_part_sub_2#p#part_1#sp#sub_2 Single
480 test/table_part_sub_2#p#part_2#sp#sub_3 Single
481 test/table_part_sub_2#p#part_2#sp#sub_4 Single
482 test/table_part_sub_2#p#part_3#sp#sub_5 Single
483 test/table_part_sub_2#p#part_3#sp#sub_6 Single
484
485 select table_schema, table_name, partition_name, subpartition_name
486 from information_schema.partitions
487 where table_name LIKE '%table_part%'
488 order by table_schema, table_name, partition_name, subpartition_name;
489 TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME
490 test table_part_1 p0 NULL
491 test table_part_1 p1 NULL
492 test table_part_1 p2 NULL
493 test table_part_1 p3 NULL
494 test table_part_1 p4 NULL
495 test table_part_2 p0 NULL
496 test table_part_2 p1 NULL
497 test table_part_2 p2 NULL
498 test table_part_2 p3 NULL
499 test table_part_2 p4 NULL
500 test table_part_CAP_6 p0 NULL
501 test table_part_CAP_6 p1 NULL
502 test table_part_CAP_6 p2 NULL
503 test table_part_CAP_6 p3 NULL
504 test table_part_CAP_6 p4 NULL
505 test table_part_NOPART_CAP_7 NULL NULL
506 test table_part_\_special_/_sub_?_3 PART_/_3 SUB_?/_5
507 test table_part_\_special_/_sub_?_3 PART_/_3 sub_\/?_6
508 test table_part_\_special_/_sub_?_3 Part_?_1 sUb_/_2
509 test table_part_\_special_/_sub_?_3 Part_?_1 Sub_?_1
510 test table_part_\_special_/_sub_?_3 pArt_\_2 SUB_?\_4
511 test table_part_\_special_/_sub_?_3 pArt_\_2 suB_\_3
512 test table_part_sub_1 Part_1 Part_1sp0
513 test table_part_sub_1 Part_1 Part_1sp1
514 test table_part_sub_1 pArt_2 pArt_2sp0
515 test table_part_sub_1 pArt_2 pArt_2sp1
516 test table_part_sub_1 part_3 part_3sp0
517 test table_part_sub_1 part_3 part_3sp1
518 test table_part_sub_1 PART_4 PART_4sp0
519 test table_part_sub_1 PART_4 PART_4sp1
520 test table_part_sub_2 Part_1 Sub_1
521 test table_part_sub_2 Part_1 sUb_2
522 test table_part_sub_2 pArt_2 suB_3
523 test table_part_sub_2 pArt_2 SUB_4
524 test table_part_sub_2 PART_3 SUB_5
525 test table_part_sub_2 PART_3 sub_6
526
527 select name from information_schema.innodb_tablespaces
528 where name LIKE '%table_part%' order by name;
529 name
530 test/table_part_1#p#p0
531 test/table_part_1#p#p1
532 test/table_part_1#p#p2
533 test/table_part_1#p#p3
534 test/table_part_1#p#p4
535 test/table_part_2#p#p0
536 test/table_part_2#p#p1
537 test/table_part_2#p#p2
538 test/table_part_2#p#p3
539 test/table_part_2#p#p4
540 test/table_part_CAP_6#p#p0
541 test/table_part_CAP_6#p#p1
542 test/table_part_CAP_6#p#p2
543 test/table_part_CAP_6#p#p3
544 test/table_part_CAP_6#p#p4
545 test/table_part_sub_1#p#part_1#sp#part_1sp0
546 test/table_part_sub_1#p#part_1#sp#part_1sp1
547 test/table_part_sub_1#p#part_2#sp#part_2sp0
548 test/table_part_sub_1#p#part_2#sp#part_2sp1
549 test/table_part_sub_1#p#part_3#sp#part_3sp0
550 test/table_part_sub_1#p#part_3#sp#part_3sp1
551 test/table_part_sub_1#p#part_4#sp#part_4sp0
552 test/table_part_sub_1#p#part_4#sp#part_4sp1
553 test/table_part_sub_2#p#part_1#sp#sub_1
554 test/table_part_sub_2#p#part_1#sp#sub_2
555 test/table_part_sub_2#p#part_2#sp#sub_3
556 test/table_part_sub_2#p#part_2#sp#sub_4
557 test/table_part_sub_2#p#part_3#sp#sub_5
558 test/table_part_sub_2#p#part_3#sp#sub_6
559 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
560 test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
561 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
562 test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
563 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
564 test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
565
566 select file_type, status, file_name, tablespace_name from information_schema.files
567 where file_name LIKE '%table_part%'
568 order by file_type, status, file_name, tablespace_name;
569 FILE_TYPE STATUS FILE_NAME TABLESPACE_NAME
570 TABLESPACE NORMAL ./test/table_part_1#p#p0.ibd test/table_part_1#p#p0
571 TABLESPACE NORMAL ./test/table_part_1#p#p1.ibd test/table_part_1#p#p1
572 TABLESPACE NORMAL ./test/table_part_1#p#p2.ibd test/table_part_1#p#p2
573 TABLESPACE NORMAL ./test/table_part_1#p#p3.ibd test/table_part_1#p#p3
574 TABLESPACE NORMAL ./test/table_part_1#p#p4.ibd test/table_part_1#p#p4
575 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
576 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
577 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
578 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
579 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
580 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
581 TABLESPACE NORMAL ./test/table_part_CAP_6#p#p0.ibd test/table_part_CAP_6#p#p0
582 TABLESPACE NORMAL ./test/table_part_CAP_6#p#p1.ibd test/table_part_CAP_6#p#p1
583 TABLESPACE NORMAL ./test/table_part_CAP_6#p#p2.ibd test/table_part_CAP_6#p#p2
584 TABLESPACE NORMAL ./test/table_part_CAP_6#p#p3.ibd test/table_part_CAP_6#p#p3
585 TABLESPACE NORMAL ./test/table_part_CAP_6#p#p4.ibd test/table_part_CAP_6#p#p4
586 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
587 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
588 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
589 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
590 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
591 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
592 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
593 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
594 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
595 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
596 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
597 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
598 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
599 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p0.ibd test/table_part_2#p#p0
600 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p1.ibd test/table_part_2#p#p1
601 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p2.ibd test/table_part_2#p#p2
602 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p3.ibd test/table_part_2#p#p3
603 TABLESPACE NORMAL /tmp/mysql_wl13352_data/test/table_part_2#p#p4.ibd test/table_part_2#p#p4
604 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
605
606 Checking Innodb stat tables
607 ---------------------------
608 select database_name, table_name from mysql.innodb_table_stats
609 where table_name like '%table_part%' order by database_name, table_name;
610 database_name table_name
611 test table_part_1#p#p0
612 test table_part_1#p#p1
613 test table_part_1#p#p2
614 test table_part_1#p#p3
615 test table_part_1#p#p4
616 test table_part_2#p#p0
617 test table_part_2#p#p1
618 test table_part_2#p#p2
619 test table_part_2#p#p3
620 test table_part_2#p#p4
621 test table_part_CAP_6#p#p0
622 test table_part_CAP_6#p#p1
623 test table_part_CAP_6#p#p2
624 test table_part_CAP_6#p#p3
625 test table_part_CAP_6#p#p4
626 test table_part_NOPART_CAP_7
627 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
628 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
629 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
630 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
631 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
632 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
633 test table_part_sub_1#p#part_1#sp#part_1sp0
634 test table_part_sub_1#p#part_1#sp#part_1sp1
635 test table_part_sub_1#p#part_2#sp#part_2sp0
636 test table_part_sub_1#p#part_2#sp#part_2sp1
637 test table_part_sub_1#p#part_3#sp#part_3sp0
638 test table_part_sub_1#p#part_3#sp#part_3sp1
639 test table_part_sub_1#p#part_4#sp#part_4sp0
640 test table_part_sub_1#p#part_4#sp#part_4sp1
641 test table_part_sub_2#p#part_1#sp#sub_1
642 test table_part_sub_2#p#part_1#sp#sub_2
643 test table_part_sub_2#p#part_2#sp#sub_3
644 test table_part_sub_2#p#part_2#sp#sub_4
645 test table_part_sub_2#p#part_3#sp#sub_5
646 test table_part_sub_2#p#part_3#sp#sub_6
647
648 select database_name, table_name, index_name, stat_name from mysql.innodb_index_stats
649 where table_name like '%table_part%'
650 order by database_name, table_name, index_name, stat_name;
651 database_name table_name index_name stat_name
652 test table_part_1#p#p0 PRIMARY n_diff_pfx01
653 test table_part_1#p#p0 PRIMARY n_leaf_pages
654 test table_part_1#p#p0 PRIMARY size
655 test table_part_1#p#p0 k1 n_diff_pfx01
656 test table_part_1#p#p0 k1 n_diff_pfx02
657 test table_part_1#p#p0 k1 n_leaf_pages
658 test table_part_1#p#p0 k1 size
659 test table_part_1#p#p1 PRIMARY n_diff_pfx01
660 test table_part_1#p#p1 PRIMARY n_leaf_pages
661 test table_part_1#p#p1 PRIMARY size
662 test table_part_1#p#p1 k1 n_diff_pfx01
663 test table_part_1#p#p1 k1 n_diff_pfx02
664 test table_part_1#p#p1 k1 n_leaf_pages
665 test table_part_1#p#p1 k1 size
666 test table_part_1#p#p2 PRIMARY n_diff_pfx01
667 test table_part_1#p#p2 PRIMARY n_leaf_pages
668 test table_part_1#p#p2 PRIMARY size
669 test table_part_1#p#p2 k1 n_diff_pfx01
670 test table_part_1#p#p2 k1 n_diff_pfx02
671 test table_part_1#p#p2 k1 n_leaf_pages
672 test table_part_1#p#p2 k1 size
673 test table_part_1#p#p3 PRIMARY n_diff_pfx01
674 test table_part_1#p#p3 PRIMARY n_leaf_pages
675 test table_part_1#p#p3 PRIMARY size
676 test table_part_1#p#p3 k1 n_diff_pfx01
677 test table_part_1#p#p3 k1 n_diff_pfx02
678 test table_part_1#p#p3 k1 n_leaf_pages
679 test table_part_1#p#p3 k1 size
680 test table_part_1#p#p4 PRIMARY n_diff_pfx01
681 test table_part_1#p#p4 PRIMARY n_leaf_pages
682 test table_part_1#p#p4 PRIMARY size
683 test table_part_1#p#p4 k1 n_diff_pfx01
684 test table_part_1#p#p4 k1 n_diff_pfx02
685 test table_part_1#p#p4 k1 n_leaf_pages
686 test table_part_1#p#p4 k1 size
687 test table_part_2#p#p0 PRIMARY n_diff_pfx01
688 test table_part_2#p#p0 PRIMARY n_leaf_pages
689 test table_part_2#p#p0 PRIMARY size
690 test table_part_2#p#p0 k1 n_diff_pfx01
691 test table_part_2#p#p0 k1 n_diff_pfx02
692 test table_part_2#p#p0 k1 n_leaf_pages
693 test table_part_2#p#p0 k1 size
694 test table_part_2#p#p1 PRIMARY n_diff_pfx01
695 test table_part_2#p#p1 PRIMARY n_leaf_pages
696 test table_part_2#p#p1 PRIMARY size
697 test table_part_2#p#p1 k1 n_diff_pfx01
698 test table_part_2#p#p1 k1 n_diff_pfx02
699 test table_part_2#p#p1 k1 n_leaf_pages
700 test table_part_2#p#p1 k1 size
701 test table_part_2#p#p2 PRIMARY n_diff_pfx01
702 test table_part_2#p#p2 PRIMARY n_leaf_pages
703 test table_part_2#p#p2 PRIMARY size
704 test table_part_2#p#p2 k1 n_diff_pfx01
705 test table_part_2#p#p2 k1 n_diff_pfx02
706 test table_part_2#p#p2 k1 n_leaf_pages
707 test table_part_2#p#p2 k1 size
708 test table_part_2#p#p3 PRIMARY n_diff_pfx01
709 test table_part_2#p#p3 PRIMARY n_leaf_pages
710 test table_part_2#p#p3 PRIMARY size
711 test table_part_2#p#p3 k1 n_diff_pfx01
712 test table_part_2#p#p3 k1 n_diff_pfx02
713 test table_part_2#p#p3 k1 n_leaf_pages
714 test table_part_2#p#p3 k1 size
715 test table_part_2#p#p4 PRIMARY n_diff_pfx01
716 test table_part_2#p#p4 PRIMARY n_leaf_pages
717 test table_part_2#p#p4 PRIMARY size
718 test table_part_2#p#p4 k1 n_diff_pfx01
719 test table_part_2#p#p4 k1 n_diff_pfx02
720 test table_part_2#p#p4 k1 n_leaf_pages
721 test table_part_2#p#p4 k1 size
722 test table_part_CAP_6#p#p0 PRIMARY n_diff_pfx01
723 test table_part_CAP_6#p#p0 PRIMARY n_leaf_pages
724 test table_part_CAP_6#p#p0 PRIMARY size
725 test table_part_CAP_6#p#p0 k1 n_diff_pfx01
726 test table_part_CAP_6#p#p0 k1 n_diff_pfx02
727 test table_part_CAP_6#p#p0 k1 n_leaf_pages
728 test table_part_CAP_6#p#p0 k1 size
729 test table_part_CAP_6#p#p1 PRIMARY n_diff_pfx01
730 test table_part_CAP_6#p#p1 PRIMARY n_leaf_pages
731 test table_part_CAP_6#p#p1 PRIMARY size
732 test table_part_CAP_6#p#p1 k1 n_diff_pfx01
733 test table_part_CAP_6#p#p1 k1 n_diff_pfx02
734 test table_part_CAP_6#p#p1 k1 n_leaf_pages
735 test table_part_CAP_6#p#p1 k1 size
736 test table_part_CAP_6#p#p2 PRIMARY n_diff_pfx01
737 test table_part_CAP_6#p#p2 PRIMARY n_leaf_pages
738 test table_part_CAP_6#p#p2 PRIMARY size
739 test table_part_CAP_6#p#p2 k1 n_diff_pfx01
740 test table_part_CAP_6#p#p2 k1 n_diff_pfx02
741 test table_part_CAP_6#p#p2 k1 n_leaf_pages
742 test table_part_CAP_6#p#p2 k1 size
743 test table_part_CAP_6#p#p3 PRIMARY n_diff_pfx01
744 test table_part_CAP_6#p#p3 PRIMARY n_leaf_pages
745 test table_part_CAP_6#p#p3 PRIMARY size
746 test table_part_CAP_6#p#p3 k1 n_diff_pfx01
747 test table_part_CAP_6#p#p3 k1 n_diff_pfx02
748 test table_part_CAP_6#p#p3 k1 n_leaf_pages
749 test table_part_CAP_6#p#p3 k1 size
750 test table_part_CAP_6#p#p4 PRIMARY n_diff_pfx01
751 test table_part_CAP_6#p#p4 PRIMARY n_leaf_pages
752 test table_part_CAP_6#p#p4 PRIMARY size
753 test table_part_CAP_6#p#p4 k1 n_diff_pfx01
754 test table_part_CAP_6#p#p4 k1 n_diff_pfx02
755 test table_part_CAP_6#p#p4 k1 n_leaf_pages
756 test table_part_CAP_6#p#p4 k1 size
757 test table_part_NOPART_CAP_7 PRIMARY n_diff_pfx01
758 test table_part_NOPART_CAP_7 PRIMARY n_leaf_pages
759 test table_part_NOPART_CAP_7 PRIMARY size
760 test table_part_NOPART_CAP_7 k1 n_diff_pfx01
761 test table_part_NOPART_CAP_7 k1 n_diff_pfx02
762 test table_part_NOPART_CAP_7 k1 n_leaf_pages
763 test table_part_NOPART_CAP_7 k1 size
764 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx01
765 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_diff_pfx02
766 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY n_leaf_pages
767 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 PRIMARY size
768 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx01
769 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_diff_pfx02
770 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 n_leaf_pages
771 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5 k1 size
772 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx01
773 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_diff_pfx02
774 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY n_leaf_pages
775 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 PRIMARY size
776 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx01
777 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_diff_pfx02
778 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 n_leaf_pages
779 test table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6 k1 size
780 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx01
781 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_diff_pfx02
782 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY n_leaf_pages
783 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 PRIMARY size
784 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx01
785 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_diff_pfx02
786 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 n_leaf_pages
787 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2 k1 size
788 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx01
789 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_diff_pfx02
790 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY n_leaf_pages
791 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 PRIMARY size
792 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx01
793 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_diff_pfx02
794 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 n_leaf_pages
795 test table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1 k1 size
796 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx01
797 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_diff_pfx02
798 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY n_leaf_pages
799 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 PRIMARY size
800 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx01
801 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_diff_pfx02
802 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 n_leaf_pages
803 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4 k1 size
804 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx01
805 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_diff_pfx02
806 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY n_leaf_pages
807 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 PRIMARY size
808 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx01
809 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_diff_pfx02
810 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 n_leaf_pages
811 test table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 k1 size
812 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx01
813 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_diff_pfx02
814 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY n_leaf_pages
815 test table_part_sub_1#p#part_1#sp#part_1sp0 PRIMARY size
816 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx01
817 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_diff_pfx02
818 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 n_leaf_pages
819 test table_part_sub_1#p#part_1#sp#part_1sp0 k1 size
820 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx01
821 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_diff_pfx02
822 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY n_leaf_pages
823 test table_part_sub_1#p#part_1#sp#part_1sp1 PRIMARY size
824 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx01
825 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_diff_pfx02
826 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 n_leaf_pages
827 test table_part_sub_1#p#part_1#sp#part_1sp1 k1 size
828 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx01
829 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_diff_pfx02
830 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY n_leaf_pages
831 test table_part_sub_1#p#part_2#sp#part_2sp0 PRIMARY size
832 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx01
833 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_diff_pfx02
834 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 n_leaf_pages
835 test table_part_sub_1#p#part_2#sp#part_2sp0 k1 size
836 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx01
837 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_diff_pfx02
838 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY n_leaf_pages
839 test table_part_sub_1#p#part_2#sp#part_2sp1 PRIMARY size
840 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx01
841 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_diff_pfx02
842 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 n_leaf_pages
843 test table_part_sub_1#p#part_2#sp#part_2sp1 k1 size
844 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx01
845 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_diff_pfx02
846 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY n_leaf_pages
847 test table_part_sub_1#p#part_3#sp#part_3sp0 PRIMARY size
848 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx01
849 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_diff_pfx02
850 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 n_leaf_pages
851 test table_part_sub_1#p#part_3#sp#part_3sp0 k1 size
852 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx01
853 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_diff_pfx02
854 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY n_leaf_pages
855 test table_part_sub_1#p#part_3#sp#part_3sp1 PRIMARY size
856 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx01
857 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_diff_pfx02
858 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 n_leaf_pages
859 test table_part_sub_1#p#part_3#sp#part_3sp1 k1 size
860 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx01
861 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_diff_pfx02
862 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY n_leaf_pages
863 test table_part_sub_1#p#part_4#sp#part_4sp0 PRIMARY size
864 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx01
865 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_diff_pfx02
866 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 n_leaf_pages
867 test table_part_sub_1#p#part_4#sp#part_4sp0 k1 size
868 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx01
869 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_diff_pfx02
870 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY n_leaf_pages
871 test table_part_sub_1#p#part_4#sp#part_4sp1 PRIMARY size
872 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx01
873 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_diff_pfx02
874 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 n_leaf_pages
875 test table_part_sub_1#p#part_4#sp#part_4sp1 k1 size
876 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx01
877 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_diff_pfx02
878 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY n_leaf_pages
879 test table_part_sub_2#p#part_1#sp#sub_1 PRIMARY size
880 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx01
881 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_diff_pfx02
882 test table_part_sub_2#p#part_1#sp#sub_1 k1 n_leaf_pages
883 test table_part_sub_2#p#part_1#sp#sub_1 k1 size
884 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx01
885 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_diff_pfx02
886 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY n_leaf_pages
887 test table_part_sub_2#p#part_1#sp#sub_2 PRIMARY size
888 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx01
889 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_diff_pfx02
890 test table_part_sub_2#p#part_1#sp#sub_2 k1 n_leaf_pages
891 test table_part_sub_2#p#part_1#sp#sub_2 k1 size
892 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx01
893 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_diff_pfx02
894 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY n_leaf_pages
895 test table_part_sub_2#p#part_2#sp#sub_3 PRIMARY size
896 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx01
897 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_diff_pfx02
898 test table_part_sub_2#p#part_2#sp#sub_3 k1 n_leaf_pages
899 test table_part_sub_2#p#part_2#sp#sub_3 k1 size
900 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx01
901 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_diff_pfx02
902 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY n_leaf_pages
903 test table_part_sub_2#p#part_2#sp#sub_4 PRIMARY size
904 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx01
905 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_diff_pfx02
906 test table_part_sub_2#p#part_2#sp#sub_4 k1 n_leaf_pages
907 test table_part_sub_2#p#part_2#sp#sub_4 k1 size
908 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx01
909 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_diff_pfx02
910 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY n_leaf_pages
911 test table_part_sub_2#p#part_3#sp#sub_5 PRIMARY size
912 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx01
913 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_diff_pfx02
914 test table_part_sub_2#p#part_3#sp#sub_5 k1 n_leaf_pages
915 test table_part_sub_2#p#part_3#sp#sub_5 k1 size
916 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx01
917 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_diff_pfx02
918 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY n_leaf_pages
919 test table_part_sub_2#p#part_3#sp#sub_6 PRIMARY size
920 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx01
921 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_diff_pfx02
922 test table_part_sub_2#p#part_3#sp#sub_6 k1 n_leaf_pages
923 test table_part_sub_2#p#part_3#sp#sub_6 k1 size
924 SET NAMES DEFAULT;
925
926 # Stop DB server which was created by MTR default
927 # Copy and zip old version data directory.
928 # Copy and zip old version exported partitions.
929 # Copy and zip old version external directory.
930 # Cleanup: Restart with default options.
931 # restart
932
933 # Drop all tables created for upgrade
934 Dropping partitioned tables
935 ---------------------------
936 DROP TABLE table_part_1;
937 DROP TABLE table_part_sub_1;
938 DROP TABLE table_part_sub_2;
939 DROP TABLE `table_part_\_special_/_sub_?_3`;
940 DROP TABLE table_part_2;
941 DROP TABLE table_part_CAP_6;
942 DROP TABLE table_part_NOPART_CAP_7;
943 DROP TABLESPACE SPACE_part;