Debian Codegraph @

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

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