File: partition_upgrade_5727_win_lctn_2_debug.result

package info (click to toggle)
mysql-8.0 8.0.43-3
links: PTS, VCS
area: main
in suites: sid
size: 1,273,924 kB
sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (2123 lines) | stat: -rw-r--r-- 93,032 bytes
# Test Upgrade from old version 5727
# Stop DB server which was created by MTR default
# Copy and unzip old version data directory.
List all files before upgrade
-----------------------------
table_part_1#p#p0.ibd
table_part_1#p#p1.ibd
table_part_1#p#p2.ibd
table_part_1#p#p3.ibd
table_part_1#p#p4.ibd
table_part_1.frm
table_part_2#p#p0.ibd
table_part_2#p#p1.ibd
table_part_2#p#p2.ibd
table_part_2#p#p3.ibd
table_part_2#p#p4.ibd
table_part_2.frm
table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd
table_part_@005c_special_@002f_sub_@003f_3.frm
table_part_CAP_6.frm
table_part_NOPART_CAP_7.frm
table_part_cap_6#p#p0.ibd
table_part_cap_6#p#p1.ibd
table_part_cap_6#p#p2.ibd
table_part_cap_6#p#p3.ibd
table_part_cap_6#p#p4.ibd
table_part_sub_1#p#part_1#sp#part_1sp0.ibd
table_part_sub_1#p#part_1#sp#part_1sp1.ibd
table_part_sub_1#p#part_2#sp#part_2sp0.ibd
table_part_sub_1#p#part_2#sp#part_2sp1.ibd
table_part_sub_1#p#part_3#sp#part_3sp0.ibd
table_part_sub_1#p#part_3#sp#part_3sp1.ibd
table_part_sub_1#p#part_4#sp#part_4sp0.ibd
table_part_sub_1#p#part_4#sp#part_4sp1.ibd
table_part_sub_1.frm
table_part_sub_2#p#part_1#sp#sub_1.ibd
table_part_sub_2#p#part_1#sp#sub_2.ibd
table_part_sub_2#p#part_2#sp#sub_3.ibd
table_part_sub_2#p#part_2#sp#sub_4.ibd
table_part_sub_2#p#part_3#sp#sub_5.ibd
table_part_sub_2#p#part_3#sp#sub_6.ibd
table_part_sub_2.frm

# Upgrade to latest mysql version

List all files of upgraded data
-------------------------------
table_part_1#p#p0.ibd
table_part_1#p#p1.ibd
table_part_1#p#p2.ibd
table_part_1#p#p3.ibd
table_part_1#p#p4.ibd
table_part_2#p#p0.ibd
table_part_2#p#p1.ibd
table_part_2#p#p2.ibd
table_part_2#p#p3.ibd
table_part_2#p#p4.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd
table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd
table_part_cap_6#p#p0.ibd
table_part_cap_6#p#p1.ibd
table_part_cap_6#p#p2.ibd
table_part_cap_6#p#p3.ibd
table_part_cap_6#p#p4.ibd
table_part_sub_1#p#part_1#sp#part_1sp0.ibd
table_part_sub_1#p#part_1#sp#part_1sp1.ibd
table_part_sub_1#p#part_2#sp#part_2sp0.ibd
table_part_sub_1#p#part_2#sp#part_2sp1.ibd
table_part_sub_1#p#part_3#sp#part_3sp0.ibd
table_part_sub_1#p#part_3#sp#part_3sp1.ibd
table_part_sub_1#p#part_4#sp#part_4sp0.ibd
table_part_sub_1#p#part_4#sp#part_4sp1.ibd
table_part_sub_2#p#part_1#sp#sub_1.ibd
table_part_sub_2#p#part_1#sp#sub_2.ibd
table_part_sub_2#p#part_2#sp#sub_3.ibd
table_part_sub_2#p#part_2#sp#sub_4.ibd
table_part_sub_2#p#part_3#sp#sub_5.ibd
table_part_sub_2#p#part_3#sp#sub_6.ibd

# A. Validate upgraded tables and data
# 1. Check table metadata and data
Checking partitioned tables
---------------------------
SET NAMES utf8mb4 COLLATE utf8mb4_0900_as_cs;

CHECK TABLE table_part_1;
Table	Op	Msg_type	Msg_text
test.table_part_1	check	status	OK

SHOW CREATE TABLE table_part_1;
Table	Create Table
table_part_1	CREATE TABLE `table_part_1` (
  `id` int NOT NULL,
  `value` int DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (`id`)
PARTITIONS 5 */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_1 order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

CHECK TABLE table_part_sub_1;
Table	Op	Msg_type	Msg_text
test.table_part_sub_1	check	status	OK

SHOW CREATE TABLE table_part_sub_1;
Table	Create Table
table_part_sub_1	CREATE TABLE `table_part_sub_1` (
  `id` int NOT NULL,
  `value` int NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`,`value`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (`value`)
SUBPARTITION BY HASH (`id`)
SUBPARTITIONS 2
(PARTITION Part_1 VALUES LESS THAN (101) ENGINE = InnoDB,
 PARTITION pArt_2 VALUES LESS THAN (401) ENGINE = InnoDB,
 PARTITION part_3 VALUES LESS THAN (701) ENGINE = InnoDB,
 PARTITION PART_4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_1 order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

CHECK TABLE table_part_sub_2;
Table	Op	Msg_type	Msg_text
test.table_part_sub_2	check	status	OK

SHOW CREATE TABLE table_part_sub_2;
Table	Create Table
table_part_sub_2	CREATE TABLE `table_part_sub_2` (
  `id` int NOT NULL,
  `value` int NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`,`value`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (`value`)
SUBPARTITION BY HASH (`id`)
(PARTITION Part_1 VALUES LESS THAN (101)
 (SUBPARTITION Sub_1 ENGINE = InnoDB,
  SUBPARTITION sUb_2 ENGINE = InnoDB),
 PARTITION pArt_2 VALUES LESS THAN (501)
 (SUBPARTITION suB_3 ENGINE = InnoDB,
  SUBPARTITION SUB_4 ENGINE = InnoDB),
 PARTITION PART_3 VALUES LESS THAN MAXVALUE
 (SUBPARTITION SUB_5 ENGINE = InnoDB,
  SUBPARTITION sub_6 ENGINE = InnoDB)) */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_2 order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

CHECK TABLE `table_part_\_special_/_sub_?_3`;
Table	Op	Msg_type	Msg_text
test.table_part_\_special_/_sub_?_3	check	status	OK

SHOW CREATE TABLE `table_part_\_special_/_sub_?_3`;
Table	Create Table
table_part_\_special_/_sub_?_3	CREATE TABLE `table_part_\_special_/_sub_?_3` (
  `id` int NOT NULL,
  `value` int NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`,`value`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (`value`)
SUBPARTITION BY HASH (`id`)
(PARTITION `Part_?_1` VALUES LESS THAN (201)
 (SUBPARTITION `Sub_?_1` ENGINE = InnoDB,
  SUBPARTITION `sUb_/_2` ENGINE = InnoDB),
 PARTITION `pArt_\_2` VALUES LESS THAN (501)
 (SUBPARTITION `suB_\_3` ENGINE = InnoDB,
  SUBPARTITION `SUB_?\_4` ENGINE = InnoDB),
 PARTITION `PART_/_3` VALUES LESS THAN MAXVALUE
 (SUBPARTITION `SUB_?/_5` ENGINE = InnoDB,
  SUBPARTITION `sub_\/?_6` ENGINE = InnoDB)) */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM `table_part_\_special_/_sub_?_3` order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

CHECK TABLE table_part_2;
Table	Op	Msg_type	Msg_text
test.table_part_2	check	status	OK

SHOW CREATE TABLE table_part_2;
Table	Create Table
table_part_2	CREATE TABLE `table_part_2` (
  `id` int NOT NULL,
  `value` int DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (`id`)
PARTITIONS 5 */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_2 order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

Checking IFS views
------------------
select table_schema, table_name from information_schema.tables
where table_name LIKE '%table_part%' order by table_schema, table_name;
TABLE_SCHEMA	TABLE_NAME
test	table_part_1
test	table_part_2
test	table_part_\_special_/_sub_?_3
test	table_part_cap_6
test	table_part_NOPART_CAP_7
test	table_part_sub_1
test	table_part_sub_2

select name, space_type from information_schema.innodb_tables
where name LIKE '%table_part%' order by name, space_type;
name	space_type
test/table_part_1#p#p0	Single
test/table_part_1#p#p1	Single
test/table_part_1#p#p2	Single
test/table_part_1#p#p3	Single
test/table_part_1#p#p4	Single
test/table_part_2#p#p0	Single
test/table_part_2#p#p1	Single
test/table_part_2#p#p2	Single
test/table_part_2#p#p3	Single
test/table_part_2#p#p4	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3	Single
test/table_part_cap_6#p#p0	Single
test/table_part_cap_6#p#p1	Single
test/table_part_cap_6#p#p2	Single
test/table_part_cap_6#p#p3	Single
test/table_part_cap_6#p#p4	Single
test/table_part_nopart_cap_7	General
test/table_part_sub_1#p#part_1#sp#part_1sp0	Single
test/table_part_sub_1#p#part_1#sp#part_1sp1	Single
test/table_part_sub_1#p#part_2#sp#part_2sp0	Single
test/table_part_sub_1#p#part_2#sp#part_2sp1	Single
test/table_part_sub_1#p#part_3#sp#part_3sp0	Single
test/table_part_sub_1#p#part_3#sp#part_3sp1	Single
test/table_part_sub_1#p#part_4#sp#part_4sp0	Single
test/table_part_sub_1#p#part_4#sp#part_4sp1	Single
test/table_part_sub_2#p#part_1#sp#sub_1	Single
test/table_part_sub_2#p#part_1#sp#sub_2	Single
test/table_part_sub_2#p#part_2#sp#sub_3	Single
test/table_part_sub_2#p#part_2#sp#sub_4	Single
test/table_part_sub_2#p#part_3#sp#sub_5	Single
test/table_part_sub_2#p#part_3#sp#sub_6	Single

select table_schema, table_name, partition_name, subpartition_name
from information_schema.partitions
where table_name LIKE '%table_part%'
  order by table_schema, table_name, partition_name, subpartition_name;
TABLE_SCHEMA	TABLE_NAME	PARTITION_NAME	SUBPARTITION_NAME
test	table_part_1	p0	NULL
test	table_part_1	p1	NULL
test	table_part_1	p2	NULL
test	table_part_1	p3	NULL
test	table_part_1	p4	NULL
test	table_part_2	p0	NULL
test	table_part_2	p1	NULL
test	table_part_2	p2	NULL
test	table_part_2	p3	NULL
test	table_part_2	p4	NULL
test	table_part_\_special_/_sub_?_3	PART_/_3	SUB_?/_5
test	table_part_\_special_/_sub_?_3	PART_/_3	sub_\/?_6
test	table_part_\_special_/_sub_?_3	Part_?_1	sUb_/_2
test	table_part_\_special_/_sub_?_3	Part_?_1	Sub_?_1
test	table_part_\_special_/_sub_?_3	pArt_\_2	SUB_?\_4
test	table_part_\_special_/_sub_?_3	pArt_\_2	suB_\_3
test	table_part_cap_6	p0	NULL
test	table_part_cap_6	p1	NULL
test	table_part_cap_6	p2	NULL
test	table_part_cap_6	p3	NULL
test	table_part_cap_6	p4	NULL
test	table_part_NOPART_CAP_7	NULL	NULL
test	table_part_sub_1	Part_1	Part_1sp0
test	table_part_sub_1	Part_1	Part_1sp1
test	table_part_sub_1	pArt_2	pArt_2sp0
test	table_part_sub_1	pArt_2	pArt_2sp1
test	table_part_sub_1	part_3	part_3sp0
test	table_part_sub_1	part_3	part_3sp1
test	table_part_sub_1	PART_4	PART_4sp0
test	table_part_sub_1	PART_4	PART_4sp1
test	table_part_sub_2	Part_1	Sub_1
test	table_part_sub_2	Part_1	sUb_2
test	table_part_sub_2	pArt_2	suB_3
test	table_part_sub_2	pArt_2	SUB_4
test	table_part_sub_2	PART_3	SUB_5
test	table_part_sub_2	PART_3	sub_6

select name from information_schema.innodb_tablespaces
where name LIKE '%table_part%' order by name;
name
test/table_part_1#p#p0
test/table_part_1#p#p1
test/table_part_1#p#p2
test/table_part_1#p#p3
test/table_part_1#p#p4
test/table_part_2#p#p0
test/table_part_2#p#p1
test/table_part_2#p#p2
test/table_part_2#p#p3
test/table_part_2#p#p4
test/table_part_cap_6#p#p0
test/table_part_cap_6#p#p1
test/table_part_cap_6#p#p2
test/table_part_cap_6#p#p3
test/table_part_cap_6#p#p4
test/table_part_sub_1#p#part_1#sp#part_1sp0
test/table_part_sub_1#p#part_1#sp#part_1sp1
test/table_part_sub_1#p#part_2#sp#part_2sp0
test/table_part_sub_1#p#part_2#sp#part_2sp1
test/table_part_sub_1#p#part_3#sp#part_3sp0
test/table_part_sub_1#p#part_3#sp#part_3sp1
test/table_part_sub_1#p#part_4#sp#part_4sp0
test/table_part_sub_1#p#part_4#sp#part_4sp1
test/table_part_sub_2#p#part_1#sp#sub_1
test/table_part_sub_2#p#part_1#sp#sub_2
test/table_part_sub_2#p#part_2#sp#sub_3
test/table_part_sub_2#p#part_2#sp#sub_4
test/table_part_sub_2#p#part_3#sp#sub_5
test/table_part_sub_2#p#part_3#sp#sub_6
test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3

select file_type, status, file_name, tablespace_name from information_schema.files
where file_name LIKE '%table_part%'
  order by file_type, status, file_name, tablespace_name;
FILE_TYPE	STATUS	FILE_NAME	TABLESPACE_NAME
TABLESPACE	NORMAL	./test/table_part_1#p#p0.ibd	test/table_part_1#p#p0
TABLESPACE	NORMAL	./test/table_part_1#p#p1.ibd	test/table_part_1#p#p1
TABLESPACE	NORMAL	./test/table_part_1#p#p2.ibd	test/table_part_1#p#p2
TABLESPACE	NORMAL	./test/table_part_1#p#p3.ibd	test/table_part_1#p#p3
TABLESPACE	NORMAL	./test/table_part_1#p#p4.ibd	test/table_part_1#p#p4
TABLESPACE	NORMAL	./test/table_part_2#p#p0.ibd	test/table_part_2#p#p0
TABLESPACE	NORMAL	./test/table_part_2#p#p1.ibd	test/table_part_2#p#p1
TABLESPACE	NORMAL	./test/table_part_2#p#p2.ibd	test/table_part_2#p#p2
TABLESPACE	NORMAL	./test/table_part_2#p#p3.ibd	test/table_part_2#p#p3
TABLESPACE	NORMAL	./test/table_part_2#p#p4.ibd	test/table_part_2#p#p4
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
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
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
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
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
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
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p0.ibd	test/table_part_cap_6#p#p0
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p1.ibd	test/table_part_cap_6#p#p1
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p2.ibd	test/table_part_cap_6#p#p2
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p3.ibd	test/table_part_cap_6#p#p3
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p4.ibd	test/table_part_cap_6#p#p4
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
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
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
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
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
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
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
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
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
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
TABLESPACE	NORMAL	./test/table_part_sub_2#p#part_2#sp#sub_3.ibd	test/table_part_sub_2#p#part_2#sp#sub_3
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
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
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

Checking Innodb stat tables
---------------------------
select database_name, table_name from mysql.innodb_table_stats
where table_name like '%table_part%' order by database_name, table_name;
database_name	table_name
test	table_part_1#p#p0
test	table_part_1#p#p1
test	table_part_1#p#p2
test	table_part_1#p#p3
test	table_part_1#p#p4
test	table_part_2#p#p0
test	table_part_2#p#p1
test	table_part_2#p#p2
test	table_part_2#p#p3
test	table_part_2#p#p4
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
test	table_part_cap_6#p#p0
test	table_part_cap_6#p#p1
test	table_part_cap_6#p#p2
test	table_part_cap_6#p#p3
test	table_part_cap_6#p#p4
test	table_part_nopart_cap_7
test	table_part_sub_1#p#part_1#sp#part_1sp0
test	table_part_sub_1#p#part_1#sp#part_1sp1
test	table_part_sub_1#p#part_2#sp#part_2sp0
test	table_part_sub_1#p#part_2#sp#part_2sp1
test	table_part_sub_1#p#part_3#sp#part_3sp0
test	table_part_sub_1#p#part_3#sp#part_3sp1
test	table_part_sub_1#p#part_4#sp#part_4sp0
test	table_part_sub_1#p#part_4#sp#part_4sp1
test	table_part_sub_2#p#part_1#sp#sub_1
test	table_part_sub_2#p#part_1#sp#sub_2
test	table_part_sub_2#p#part_2#sp#sub_3
test	table_part_sub_2#p#part_2#sp#sub_4
test	table_part_sub_2#p#part_3#sp#sub_5
test	table_part_sub_2#p#part_3#sp#sub_6

select database_name, table_name, index_name, stat_name from mysql.innodb_index_stats
where table_name like '%table_part%'
  order by database_name, table_name, index_name, stat_name;
database_name	table_name	index_name	stat_name
test	table_part_1#p#p0	PRIMARY	n_diff_pfx01
test	table_part_1#p#p0	PRIMARY	n_leaf_pages
test	table_part_1#p#p0	PRIMARY	size
test	table_part_1#p#p0	k1	n_diff_pfx01
test	table_part_1#p#p0	k1	n_diff_pfx02
test	table_part_1#p#p0	k1	n_leaf_pages
test	table_part_1#p#p0	k1	size
test	table_part_1#p#p1	PRIMARY	n_diff_pfx01
test	table_part_1#p#p1	PRIMARY	n_leaf_pages
test	table_part_1#p#p1	PRIMARY	size
test	table_part_1#p#p1	k1	n_diff_pfx01
test	table_part_1#p#p1	k1	n_diff_pfx02
test	table_part_1#p#p1	k1	n_leaf_pages
test	table_part_1#p#p1	k1	size
test	table_part_1#p#p2	PRIMARY	n_diff_pfx01
test	table_part_1#p#p2	PRIMARY	n_leaf_pages
test	table_part_1#p#p2	PRIMARY	size
test	table_part_1#p#p2	k1	n_diff_pfx01
test	table_part_1#p#p2	k1	n_diff_pfx02
test	table_part_1#p#p2	k1	n_leaf_pages
test	table_part_1#p#p2	k1	size
test	table_part_1#p#p3	PRIMARY	n_diff_pfx01
test	table_part_1#p#p3	PRIMARY	n_leaf_pages
test	table_part_1#p#p3	PRIMARY	size
test	table_part_1#p#p3	k1	n_diff_pfx01
test	table_part_1#p#p3	k1	n_diff_pfx02
test	table_part_1#p#p3	k1	n_leaf_pages
test	table_part_1#p#p3	k1	size
test	table_part_1#p#p4	PRIMARY	n_diff_pfx01
test	table_part_1#p#p4	PRIMARY	n_leaf_pages
test	table_part_1#p#p4	PRIMARY	size
test	table_part_1#p#p4	k1	n_diff_pfx01
test	table_part_1#p#p4	k1	n_diff_pfx02
test	table_part_1#p#p4	k1	n_leaf_pages
test	table_part_1#p#p4	k1	size
test	table_part_2#p#p0	PRIMARY	n_diff_pfx01
test	table_part_2#p#p0	PRIMARY	n_leaf_pages
test	table_part_2#p#p0	PRIMARY	size
test	table_part_2#p#p0	k1	n_diff_pfx01
test	table_part_2#p#p0	k1	n_diff_pfx02
test	table_part_2#p#p0	k1	n_leaf_pages
test	table_part_2#p#p0	k1	size
test	table_part_2#p#p1	PRIMARY	n_diff_pfx01
test	table_part_2#p#p1	PRIMARY	n_leaf_pages
test	table_part_2#p#p1	PRIMARY	size
test	table_part_2#p#p1	k1	n_diff_pfx01
test	table_part_2#p#p1	k1	n_diff_pfx02
test	table_part_2#p#p1	k1	n_leaf_pages
test	table_part_2#p#p1	k1	size
test	table_part_2#p#p2	PRIMARY	n_diff_pfx01
test	table_part_2#p#p2	PRIMARY	n_leaf_pages
test	table_part_2#p#p2	PRIMARY	size
test	table_part_2#p#p2	k1	n_diff_pfx01
test	table_part_2#p#p2	k1	n_diff_pfx02
test	table_part_2#p#p2	k1	n_leaf_pages
test	table_part_2#p#p2	k1	size
test	table_part_2#p#p3	PRIMARY	n_diff_pfx01
test	table_part_2#p#p3	PRIMARY	n_leaf_pages
test	table_part_2#p#p3	PRIMARY	size
test	table_part_2#p#p3	k1	n_diff_pfx01
test	table_part_2#p#p3	k1	n_diff_pfx02
test	table_part_2#p#p3	k1	n_leaf_pages
test	table_part_2#p#p3	k1	size
test	table_part_2#p#p4	PRIMARY	n_diff_pfx01
test	table_part_2#p#p4	PRIMARY	n_leaf_pages
test	table_part_2#p#p4	PRIMARY	size
test	table_part_2#p#p4	k1	n_diff_pfx01
test	table_part_2#p#p4	k1	n_diff_pfx02
test	table_part_2#p#p4	k1	n_leaf_pages
test	table_part_2#p#p4	k1	size
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	k1	size
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	k1	size
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	k1	size
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	k1	size
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	k1	size
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	k1	size
test	table_part_cap_6#p#p0	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p0	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p0	PRIMARY	size
test	table_part_cap_6#p#p0	k1	n_diff_pfx01
test	table_part_cap_6#p#p0	k1	n_diff_pfx02
test	table_part_cap_6#p#p0	k1	n_leaf_pages
test	table_part_cap_6#p#p0	k1	size
test	table_part_cap_6#p#p1	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p1	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p1	PRIMARY	size
test	table_part_cap_6#p#p1	k1	n_diff_pfx01
test	table_part_cap_6#p#p1	k1	n_diff_pfx02
test	table_part_cap_6#p#p1	k1	n_leaf_pages
test	table_part_cap_6#p#p1	k1	size
test	table_part_cap_6#p#p2	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p2	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p2	PRIMARY	size
test	table_part_cap_6#p#p2	k1	n_diff_pfx01
test	table_part_cap_6#p#p2	k1	n_diff_pfx02
test	table_part_cap_6#p#p2	k1	n_leaf_pages
test	table_part_cap_6#p#p2	k1	size
test	table_part_cap_6#p#p3	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p3	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p3	PRIMARY	size
test	table_part_cap_6#p#p3	k1	n_diff_pfx01
test	table_part_cap_6#p#p3	k1	n_diff_pfx02
test	table_part_cap_6#p#p3	k1	n_leaf_pages
test	table_part_cap_6#p#p3	k1	size
test	table_part_cap_6#p#p4	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p4	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p4	PRIMARY	size
test	table_part_cap_6#p#p4	k1	n_diff_pfx01
test	table_part_cap_6#p#p4	k1	n_diff_pfx02
test	table_part_cap_6#p#p4	k1	n_leaf_pages
test	table_part_cap_6#p#p4	k1	size
test	table_part_nopart_cap_7	PRIMARY	n_diff_pfx01
test	table_part_nopart_cap_7	PRIMARY	n_leaf_pages
test	table_part_nopart_cap_7	PRIMARY	size
test	table_part_nopart_cap_7	k1	n_diff_pfx01
test	table_part_nopart_cap_7	k1	n_diff_pfx02
test	table_part_nopart_cap_7	k1	n_leaf_pages
test	table_part_nopart_cap_7	k1	size
test	table_part_sub_1#p#part_1#sp#part_1sp0	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_1#sp#part_1sp0	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_1#sp#part_1sp0	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_1#sp#part_1sp0	PRIMARY	size
test	table_part_sub_1#p#part_1#sp#part_1sp0	k1	n_diff_pfx01
test	table_part_sub_1#p#part_1#sp#part_1sp0	k1	n_diff_pfx02
test	table_part_sub_1#p#part_1#sp#part_1sp0	k1	n_leaf_pages
test	table_part_sub_1#p#part_1#sp#part_1sp0	k1	size
test	table_part_sub_1#p#part_1#sp#part_1sp1	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_1#sp#part_1sp1	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_1#sp#part_1sp1	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_1#sp#part_1sp1	PRIMARY	size
test	table_part_sub_1#p#part_1#sp#part_1sp1	k1	n_diff_pfx01
test	table_part_sub_1#p#part_1#sp#part_1sp1	k1	n_diff_pfx02
test	table_part_sub_1#p#part_1#sp#part_1sp1	k1	n_leaf_pages
test	table_part_sub_1#p#part_1#sp#part_1sp1	k1	size
test	table_part_sub_1#p#part_2#sp#part_2sp0	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_2#sp#part_2sp0	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_2#sp#part_2sp0	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_2#sp#part_2sp0	PRIMARY	size
test	table_part_sub_1#p#part_2#sp#part_2sp0	k1	n_diff_pfx01
test	table_part_sub_1#p#part_2#sp#part_2sp0	k1	n_diff_pfx02
test	table_part_sub_1#p#part_2#sp#part_2sp0	k1	n_leaf_pages
test	table_part_sub_1#p#part_2#sp#part_2sp0	k1	size
test	table_part_sub_1#p#part_2#sp#part_2sp1	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_2#sp#part_2sp1	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_2#sp#part_2sp1	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_2#sp#part_2sp1	PRIMARY	size
test	table_part_sub_1#p#part_2#sp#part_2sp1	k1	n_diff_pfx01
test	table_part_sub_1#p#part_2#sp#part_2sp1	k1	n_diff_pfx02
test	table_part_sub_1#p#part_2#sp#part_2sp1	k1	n_leaf_pages
test	table_part_sub_1#p#part_2#sp#part_2sp1	k1	size
test	table_part_sub_1#p#part_3#sp#part_3sp0	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_3#sp#part_3sp0	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_3#sp#part_3sp0	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_3#sp#part_3sp0	PRIMARY	size
test	table_part_sub_1#p#part_3#sp#part_3sp0	k1	n_diff_pfx01
test	table_part_sub_1#p#part_3#sp#part_3sp0	k1	n_diff_pfx02
test	table_part_sub_1#p#part_3#sp#part_3sp0	k1	n_leaf_pages
test	table_part_sub_1#p#part_3#sp#part_3sp0	k1	size
test	table_part_sub_1#p#part_3#sp#part_3sp1	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_3#sp#part_3sp1	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_3#sp#part_3sp1	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_3#sp#part_3sp1	PRIMARY	size
test	table_part_sub_1#p#part_3#sp#part_3sp1	k1	n_diff_pfx01
test	table_part_sub_1#p#part_3#sp#part_3sp1	k1	n_diff_pfx02
test	table_part_sub_1#p#part_3#sp#part_3sp1	k1	n_leaf_pages
test	table_part_sub_1#p#part_3#sp#part_3sp1	k1	size
test	table_part_sub_1#p#part_4#sp#part_4sp0	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_4#sp#part_4sp0	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_4#sp#part_4sp0	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_4#sp#part_4sp0	PRIMARY	size
test	table_part_sub_1#p#part_4#sp#part_4sp0	k1	n_diff_pfx01
test	table_part_sub_1#p#part_4#sp#part_4sp0	k1	n_diff_pfx02
test	table_part_sub_1#p#part_4#sp#part_4sp0	k1	n_leaf_pages
test	table_part_sub_1#p#part_4#sp#part_4sp0	k1	size
test	table_part_sub_1#p#part_4#sp#part_4sp1	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_4#sp#part_4sp1	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_4#sp#part_4sp1	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_4#sp#part_4sp1	PRIMARY	size
test	table_part_sub_1#p#part_4#sp#part_4sp1	k1	n_diff_pfx01
test	table_part_sub_1#p#part_4#sp#part_4sp1	k1	n_diff_pfx02
test	table_part_sub_1#p#part_4#sp#part_4sp1	k1	n_leaf_pages
test	table_part_sub_1#p#part_4#sp#part_4sp1	k1	size
test	table_part_sub_2#p#part_1#sp#sub_1	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_1#sp#sub_1	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_1#sp#sub_1	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_1#sp#sub_1	PRIMARY	size
test	table_part_sub_2#p#part_1#sp#sub_1	k1	n_diff_pfx01
test	table_part_sub_2#p#part_1#sp#sub_1	k1	n_diff_pfx02
test	table_part_sub_2#p#part_1#sp#sub_1	k1	n_leaf_pages
test	table_part_sub_2#p#part_1#sp#sub_1	k1	size
test	table_part_sub_2#p#part_1#sp#sub_2	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_1#sp#sub_2	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_1#sp#sub_2	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_1#sp#sub_2	PRIMARY	size
test	table_part_sub_2#p#part_1#sp#sub_2	k1	n_diff_pfx01
test	table_part_sub_2#p#part_1#sp#sub_2	k1	n_diff_pfx02
test	table_part_sub_2#p#part_1#sp#sub_2	k1	n_leaf_pages
test	table_part_sub_2#p#part_1#sp#sub_2	k1	size
test	table_part_sub_2#p#part_2#sp#sub_3	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_2#sp#sub_3	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_2#sp#sub_3	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_2#sp#sub_3	PRIMARY	size
test	table_part_sub_2#p#part_2#sp#sub_3	k1	n_diff_pfx01
test	table_part_sub_2#p#part_2#sp#sub_3	k1	n_diff_pfx02
test	table_part_sub_2#p#part_2#sp#sub_3	k1	n_leaf_pages
test	table_part_sub_2#p#part_2#sp#sub_3	k1	size
test	table_part_sub_2#p#part_2#sp#sub_4	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_2#sp#sub_4	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_2#sp#sub_4	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_2#sp#sub_4	PRIMARY	size
test	table_part_sub_2#p#part_2#sp#sub_4	k1	n_diff_pfx01
test	table_part_sub_2#p#part_2#sp#sub_4	k1	n_diff_pfx02
test	table_part_sub_2#p#part_2#sp#sub_4	k1	n_leaf_pages
test	table_part_sub_2#p#part_2#sp#sub_4	k1	size
test	table_part_sub_2#p#part_3#sp#sub_5	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_3#sp#sub_5	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_3#sp#sub_5	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_3#sp#sub_5	PRIMARY	size
test	table_part_sub_2#p#part_3#sp#sub_5	k1	n_diff_pfx01
test	table_part_sub_2#p#part_3#sp#sub_5	k1	n_diff_pfx02
test	table_part_sub_2#p#part_3#sp#sub_5	k1	n_leaf_pages
test	table_part_sub_2#p#part_3#sp#sub_5	k1	size
test	table_part_sub_2#p#part_3#sp#sub_6	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_3#sp#sub_6	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_3#sp#sub_6	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_3#sp#sub_6	PRIMARY	size
test	table_part_sub_2#p#part_3#sp#sub_6	k1	n_diff_pfx01
test	table_part_sub_2#p#part_3#sp#sub_6	k1	n_diff_pfx02
test	table_part_sub_2#p#part_3#sp#sub_6	k1	n_leaf_pages
test	table_part_sub_2#p#part_3#sp#sub_6	k1	size

Checking DD tables
------------------
SET DEBUG='+d,skip_dd_table_access_check';

select t.name as "table", p.name as "partition", p.number
from mysql.tables t, mysql.table_partitions p
where p.table_id = t.id
order by t.name, p.name, p.number;
table	partition	number
table_part_1	p0	0
table_part_1	p1	1
table_part_1	p2	2
table_part_1	p3	3
table_part_1	p4	4
table_part_2	p0	0
table_part_2	p1	1
table_part_2	p2	2
table_part_2	p3	3
table_part_2	p4	4
table_part_\_special_/_sub_?_3	PART_/_3	2
table_part_\_special_/_sub_?_3	Part_?_1	0
table_part_\_special_/_sub_?_3	pArt_\_2	1
table_part_\_special_/_sub_?_3	sUb_/_2	1
table_part_\_special_/_sub_?_3	SUB_?/_5	0
table_part_\_special_/_sub_?_3	SUB_?\_4	1
table_part_\_special_/_sub_?_3	Sub_?_1	0
table_part_\_special_/_sub_?_3	sub_\/?_6	1
table_part_\_special_/_sub_?_3	suB_\_3	0
table_part_cap_6	p0	0
table_part_cap_6	p1	1
table_part_cap_6	p2	2
table_part_cap_6	p3	3
table_part_cap_6	p4	4
table_part_sub_1	Part_1	0
table_part_sub_1	Part_1sp0	0
table_part_sub_1	Part_1sp1	1
table_part_sub_1	pArt_2	1
table_part_sub_1	pArt_2sp0	0
table_part_sub_1	pArt_2sp1	1
table_part_sub_1	part_3	2
table_part_sub_1	part_3sp0	0
table_part_sub_1	part_3sp1	1
table_part_sub_1	PART_4	3
table_part_sub_1	PART_4sp0	0
table_part_sub_1	PART_4sp1	1
table_part_sub_2	Part_1	0
table_part_sub_2	pArt_2	1
table_part_sub_2	PART_3	2
table_part_sub_2	Sub_1	0
table_part_sub_2	sUb_2	1
table_part_sub_2	suB_3	0
table_part_sub_2	SUB_4	1
table_part_sub_2	SUB_5	0
table_part_sub_2	sub_6	1

select name from mysql.tablespaces
where name like '%table_part%' order by name;
name
test/table_part_1#p#p0
test/table_part_1#p#p1
test/table_part_1#p#p2
test/table_part_1#p#p3
test/table_part_1#p#p4
test/table_part_2#p#p0
test/table_part_2#p#p1
test/table_part_2#p#p2
test/table_part_2#p#p3
test/table_part_2#p#p4
test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
test/table_part_cap_6#p#p0
test/table_part_cap_6#p#p1
test/table_part_cap_6#p#p2
test/table_part_cap_6#p#p3
test/table_part_cap_6#p#p4
test/table_part_sub_1#p#part_1#sp#part_1sp0
test/table_part_sub_1#p#part_1#sp#part_1sp1
test/table_part_sub_1#p#part_2#sp#part_2sp0
test/table_part_sub_1#p#part_2#sp#part_2sp1
test/table_part_sub_1#p#part_3#sp#part_3sp0
test/table_part_sub_1#p#part_3#sp#part_3sp1
test/table_part_sub_1#p#part_4#sp#part_4sp0
test/table_part_sub_1#p#part_4#sp#part_4sp1
test/table_part_sub_2#p#part_1#sp#sub_1
test/table_part_sub_2#p#part_1#sp#sub_2
test/table_part_sub_2#p#part_2#sp#sub_3
test/table_part_sub_2#p#part_2#sp#sub_4
test/table_part_sub_2#p#part_3#sp#sub_5
test/table_part_sub_2#p#part_3#sp#sub_6

select file_name from mysql.tablespace_files
where file_name like '%table_part%' order by file_name;
file_name
./test/table_part_1#p#p0.ibd
./test/table_part_1#p#p1.ibd
./test/table_part_1#p#p2.ibd
./test/table_part_1#p#p3.ibd
./test/table_part_1#p#p4.ibd
./test/table_part_2#p#p0.ibd
./test/table_part_2#p#p1.ibd
./test/table_part_2#p#p2.ibd
./test/table_part_2#p#p3.ibd
./test/table_part_2#p#p4.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd
./test/table_part_cap_6#p#p0.ibd
./test/table_part_cap_6#p#p1.ibd
./test/table_part_cap_6#p#p2.ibd
./test/table_part_cap_6#p#p3.ibd
./test/table_part_cap_6#p#p4.ibd
./test/table_part_sub_1#p#part_1#sp#part_1sp0.ibd
./test/table_part_sub_1#p#part_1#sp#part_1sp1.ibd
./test/table_part_sub_1#p#part_2#sp#part_2sp0.ibd
./test/table_part_sub_1#p#part_2#sp#part_2sp1.ibd
./test/table_part_sub_1#p#part_3#sp#part_3sp0.ibd
./test/table_part_sub_1#p#part_3#sp#part_3sp1.ibd
./test/table_part_sub_1#p#part_4#sp#part_4sp0.ibd
./test/table_part_sub_1#p#part_4#sp#part_4sp1.ibd
./test/table_part_sub_2#p#part_1#sp#sub_1.ibd
./test/table_part_sub_2#p#part_1#sp#sub_2.ibd
./test/table_part_sub_2#p#part_2#sp#sub_3.ibd
./test/table_part_sub_2#p#part_2#sp#sub_4.ibd
./test/table_part_sub_2#p#part_3#sp#sub_5.ibd
./test/table_part_sub_2#p#part_3#sp#sub_6.ibd
SET DEBUG='-d,skip_dd_table_access_check';
SET NAMES DEFAULT;
# 2. Do DML insert/update/delete on upgraded tables
DML on partitioned tables
-------------------------

insert into table_part_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update table_part_1 set name = 'Row - updated' where value > 500;

delete from table_part_1 where id = 7;

insert into table_part_sub_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update table_part_sub_1 set name = 'Row - updated' where value > 500;

delete from table_part_sub_1 where id = 7;

insert into table_part_sub_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update table_part_sub_2 set name = 'Row - updated' where value > 500;

delete from table_part_sub_2 where id = 7;

insert into `table_part_\_special_/_sub_?_3` values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update `table_part_\_special_/_sub_?_3` set name = 'Row - updated' where value > 500;

delete from `table_part_\_special_/_sub_?_3` where id = 7;

insert into table_part_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update table_part_2 set name = 'Row - updated' where value > 500;

delete from table_part_2 where id = 7;
# 3. Do DDL ALTER/DROP on upgraded tables
DDL on partitioned tables
-------------------------
ALTER TABLE table_part_1 TRUNCATE PARTITION p0;

ALTER TABLE table_part_1 COALESCE PARTITION 2;

SHOW CREATE TABLE table_part_1;
Table	Create Table
table_part_1	CREATE TABLE `table_part_1` (
  `id` int NOT NULL,
  `value` int DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (`id`)
PARTITIONS 3 */

ALTER TABLE table_part_sub_1 TRUNCATE PARTITION part_1;

ALTER TABLE table_part_sub_2 TRUNCATE PARTITION part_3;

CREATE TABLE test_table LIKE table_part_sub_2;

ALTER TABLE test_table REMOVE PARTITIONING;
insert into test_table values(2, 265, "Row - 2", REPEAT('Large Column Data - 2' , 256));

SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
id	value	name
2	255	Row - 2
4	455	Row - 4

SELECT id, value, name FROM test_table order by id;
id	value	name
2	265	Row - 2

ALTER TABLE table_part_sub_2 EXCHANGE PARTITION sub_3 WITH TABLE test_table;

SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
id	value	name
2	265	Row - 2

SELECT id, value, name FROM test_table order by id;
id	value	name
2	255	Row - 2
4	455	Row - 4

DROP TABLE test_table;

ALTER TABLE table_part_sub_2 RENAME renamed_table;;
SHOW CREATE TABLE renamed_table;
Table	Create Table
renamed_table	CREATE TABLE `renamed_table` (
  `id` int NOT NULL,
  `value` int NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`,`value`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (`value`)
SUBPARTITION BY HASH (`id`)
(PARTITION Part_1 VALUES LESS THAN (101)
 (SUBPARTITION Sub_1 ENGINE = InnoDB,
  SUBPARTITION sUb_2 ENGINE = InnoDB),
 PARTITION pArt_2 VALUES LESS THAN (501)
 (SUBPARTITION suB_3 ENGINE = InnoDB,
  SUBPARTITION SUB_4 ENGINE = InnoDB),
 PARTITION PART_3 VALUES LESS THAN MAXVALUE
 (SUBPARTITION SUB_5 ENGINE = InnoDB,
  SUBPARTITION sub_6 ENGINE = InnoDB)) */

ALTER TABLE renamed_table RENAME table_part_sub_2;;

ALTER TABLE table_part_1 ENGINE = InnoDB;;

ALTER TABLE table_part_1 ADD COLUMN new_id int AFTER id;

ALTER TABLE table_part_1 REMOVE PARTITIONING;

ALTER TABLE table_part_sub_1 ENGINE = InnoDB;;

ALTER TABLE table_part_sub_1 ADD COLUMN new_id int AFTER id;

ALTER TABLE table_part_sub_1 REMOVE PARTITIONING;

ALTER TABLE table_part_sub_2 ENGINE = InnoDB;;

ALTER TABLE table_part_sub_2 ADD COLUMN new_id int AFTER id;

ALTER TABLE table_part_sub_2 REMOVE PARTITIONING;

ALTER TABLE `table_part_\_special_/_sub_?_3` ENGINE = InnoDB;;

ALTER TABLE `table_part_\_special_/_sub_?_3` ADD COLUMN new_id int AFTER id;

ALTER TABLE `table_part_\_special_/_sub_?_3` REMOVE PARTITIONING;

ALTER TABLE table_part_2 ENGINE = InnoDB;;

ALTER TABLE table_part_2 ADD COLUMN new_id int AFTER id;

ALTER TABLE table_part_2 REMOVE PARTITIONING;

# B. Create all the tables again and validate
Dropping partitioned tables
---------------------------
DROP TABLE table_part_1;
DROP TABLE table_part_sub_1;
DROP TABLE table_part_sub_2;
DROP TABLE `table_part_\_special_/_sub_?_3`;
DROP TABLE table_part_2;
Creating partitioned tables
---------------------------
CREATE TABLE table_part_1(
id int primary key, value int, name varchar(32), data BLOB,
key k1(value)) partition by hash (id) partitions 5;

CREATE TABLE table_part_2(
id int primary key, value int, name varchar(32), data BLOB,
key k1(value)) 
partition by hash (id) partitions 5;

CREATE TABLE table_part_sub_1(
id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
key k1(value)) partition by range (value) subpartition by hash (id)
subpartitions 2 ( partition Part_1 values less than (101),
partition pArt_2 values less than (401),
partition part_3 values less than (701),
partition PART_4 values less than MAXVALUE);

CREATE TABLE table_part_sub_2(
id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
key k1(value)) partition by range (value) subpartition by hash (id)
( partition Part_1 values less than (101)(
subpartition Sub_1,
subpartition sUb_2),
partition pArt_2 values less than (501)(
subpartition suB_3 ,
subpartition SUB_4),
partition PART_3 values less than MAXVALUE(
subpartition SUB_5,
subpartition sub_6));

CREATE TABLE `table_part_\_special_/_sub_?_3`(
id int, value int, name varchar(32), data BLOB, primary key pk(id, value),
key k1(value)) partition by range (value) subpartition by hash (id)
( partition `Part_?_1` values less than (201)(
subpartition `Sub_?_1`,
subpartition `sUb_/_2`),
partition `pArt_\_2` values less than (501)(
subpartition `suB_\_3`,
subpartition `SUB_?\_4`),
partition `PART_/_3` values less than MAXVALUE(
subpartition `SUB_?/_5`,
subpartition `sub_\/?_6`));

Inserting 10 rows to table_part_1
---------------------------------------
insert into table_part_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
insert into table_part_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
insert into table_part_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
insert into table_part_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
insert into table_part_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
insert into table_part_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
insert into table_part_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
insert into table_part_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
insert into table_part_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
insert into table_part_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));

Inserting 10 rows to table_part_sub_1
---------------------------------------
insert into table_part_sub_1 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
insert into table_part_sub_1 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
insert into table_part_sub_1 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
insert into table_part_sub_1 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
insert into table_part_sub_1 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
insert into table_part_sub_1 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
insert into table_part_sub_1 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
insert into table_part_sub_1 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
insert into table_part_sub_1 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
insert into table_part_sub_1 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));

Inserting 10 rows to table_part_sub_2
---------------------------------------
insert into table_part_sub_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
insert into table_part_sub_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
insert into table_part_sub_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
insert into table_part_sub_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
insert into table_part_sub_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
insert into table_part_sub_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
insert into table_part_sub_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
insert into table_part_sub_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
insert into table_part_sub_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
insert into table_part_sub_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));

Inserting 10 rows to `table_part_\_special_/_sub_?_3`
---------------------------------------
insert into `table_part_\_special_/_sub_?_3` VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
insert into `table_part_\_special_/_sub_?_3` VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));

Inserting 10 rows to table_part_2
---------------------------------------
insert into table_part_2 VALUES(0, 55, "Row - 0", REPEAT('Large Column Data - 0' , 256));
insert into table_part_2 VALUES(1, 155, "Row - 1", REPEAT('Large Column Data - 1' , 256));
insert into table_part_2 VALUES(2, 255, "Row - 2", REPEAT('Large Column Data - 2' , 256));
insert into table_part_2 VALUES(3, 355, "Row - 3", REPEAT('Large Column Data - 3' , 256));
insert into table_part_2 VALUES(4, 455, "Row - 4", REPEAT('Large Column Data - 4' , 256));
insert into table_part_2 VALUES(5, 555, "Row - 5", REPEAT('Large Column Data - 5' , 256));
insert into table_part_2 VALUES(6, 655, "Row - 6", REPEAT('Large Column Data - 6' , 256));
insert into table_part_2 VALUES(7, 755, "Row - 7", REPEAT('Large Column Data - 7' , 256));
insert into table_part_2 VALUES(8, 855, "Row - 8", REPEAT('Large Column Data - 8' , 256));
insert into table_part_2 VALUES(9, 955, "Row - 9", REPEAT('Large Column Data - 9' , 256));
select id, value, name from table_part_sub_2 partition (sub_1) order by id;
id	value	name
0	55	Row - 0
select id, value, name from table_part_sub_2 partition (sub_2) order by id;
id	value	name
select id, value, name from table_part_sub_2 partition (sub_3) order by id;
id	value	name
2	255	Row - 2
4	455	Row - 4
select id, value, name from table_part_sub_2 partition (sub_4) order by id;
id	value	name
1	155	Row - 1
3	355	Row - 3
select id, value, name from table_part_sub_2 partition (sub_5) order by id;
id	value	name
6	655	Row - 6
8	855	Row - 8
select id, value, name from table_part_sub_2 partition (sub_6) order by id;
id	value	name
5	555	Row - 5
7	755	Row - 7
9	955	Row - 9

# 1. Check table metadata and data
Checking partitioned tables
---------------------------
SET NAMES utf8mb4 COLLATE utf8mb4_0900_as_cs;

CHECK TABLE table_part_1;
Table	Op	Msg_type	Msg_text
test.table_part_1	check	status	OK

SHOW CREATE TABLE table_part_1;
Table	Create Table
table_part_1	CREATE TABLE `table_part_1` (
  `id` int NOT NULL,
  `value` int DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY HASH (`id`)
PARTITIONS 5 */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_1 order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

CHECK TABLE table_part_sub_1;
Table	Op	Msg_type	Msg_text
test.table_part_sub_1	check	status	OK

SHOW CREATE TABLE table_part_sub_1;
Table	Create Table
table_part_sub_1	CREATE TABLE `table_part_sub_1` (
  `id` int NOT NULL,
  `value` int NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`,`value`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY RANGE (`value`)
SUBPARTITION BY HASH (`id`)
SUBPARTITIONS 2
(PARTITION Part_1 VALUES LESS THAN (101) ENGINE = InnoDB,
 PARTITION pArt_2 VALUES LESS THAN (401) ENGINE = InnoDB,
 PARTITION part_3 VALUES LESS THAN (701) ENGINE = InnoDB,
 PARTITION PART_4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_1 order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

CHECK TABLE table_part_sub_2;
Table	Op	Msg_type	Msg_text
test.table_part_sub_2	check	status	OK

SHOW CREATE TABLE table_part_sub_2;
Table	Create Table
table_part_sub_2	CREATE TABLE `table_part_sub_2` (
  `id` int NOT NULL,
  `value` int NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`,`value`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY RANGE (`value`)
SUBPARTITION BY HASH (`id`)
(PARTITION Part_1 VALUES LESS THAN (101)
 (SUBPARTITION Sub_1 ENGINE = InnoDB,
  SUBPARTITION sUb_2 ENGINE = InnoDB),
 PARTITION pArt_2 VALUES LESS THAN (501)
 (SUBPARTITION suB_3 ENGINE = InnoDB,
  SUBPARTITION SUB_4 ENGINE = InnoDB),
 PARTITION PART_3 VALUES LESS THAN MAXVALUE
 (SUBPARTITION SUB_5 ENGINE = InnoDB,
  SUBPARTITION sub_6 ENGINE = InnoDB)) */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_sub_2 order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

CHECK TABLE `table_part_\_special_/_sub_?_3`;
Table	Op	Msg_type	Msg_text
test.table_part_\_special_/_sub_?_3	check	status	OK

SHOW CREATE TABLE `table_part_\_special_/_sub_?_3`;
Table	Create Table
table_part_\_special_/_sub_?_3	CREATE TABLE `table_part_\_special_/_sub_?_3` (
  `id` int NOT NULL,
  `value` int NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`,`value`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY RANGE (`value`)
SUBPARTITION BY HASH (`id`)
(PARTITION `Part_?_1` VALUES LESS THAN (201)
 (SUBPARTITION `Sub_?_1` ENGINE = InnoDB,
  SUBPARTITION `sUb_/_2` ENGINE = InnoDB),
 PARTITION `pArt_\_2` VALUES LESS THAN (501)
 (SUBPARTITION `suB_\_3` ENGINE = InnoDB,
  SUBPARTITION `SUB_?\_4` ENGINE = InnoDB),
 PARTITION `PART_/_3` VALUES LESS THAN MAXVALUE
 (SUBPARTITION `SUB_?/_5` ENGINE = InnoDB,
  SUBPARTITION `sub_\/?_6` ENGINE = InnoDB)) */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM `table_part_\_special_/_sub_?_3` order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

CHECK TABLE table_part_2;
Table	Op	Msg_type	Msg_text
test.table_part_2	check	status	OK

SHOW CREATE TABLE table_part_2;
Table	Create Table
table_part_2	CREATE TABLE `table_part_2` (
  `id` int NOT NULL,
  `value` int DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY HASH (`id`)
PARTITIONS 5 */

SELECT id, value, name, SUBSTRING(data, 1024, 32) FROM table_part_2 order by id;
id	value	name	SUBSTRING(data, 1024, 32)
0	55	Row - 0	ta - 0Large Column Data - 0Large
1	155	Row - 1	ta - 1Large Column Data - 1Large
2	255	Row - 2	ta - 2Large Column Data - 2Large
3	355	Row - 3	ta - 3Large Column Data - 3Large
4	455	Row - 4	ta - 4Large Column Data - 4Large
5	555	Row - 5	ta - 5Large Column Data - 5Large
6	655	Row - 6	ta - 6Large Column Data - 6Large
7	755	Row - 7	ta - 7Large Column Data - 7Large
8	855	Row - 8	ta - 8Large Column Data - 8Large
9	955	Row - 9	ta - 9Large Column Data - 9Large

Checking IFS views
------------------
select table_schema, table_name from information_schema.tables
where table_name LIKE '%table_part%' order by table_schema, table_name;
TABLE_SCHEMA	TABLE_NAME
test	table_part_1
test	table_part_2
test	table_part_\_special_/_sub_?_3
test	table_part_cap_6
test	table_part_NOPART_CAP_7
test	table_part_sub_1
test	table_part_sub_2

select name, space_type from information_schema.innodb_tables
where name LIKE '%table_part%' order by name, space_type;
name	space_type
test/table_part_1#p#p0	Single
test/table_part_1#p#p1	Single
test/table_part_1#p#p2	Single
test/table_part_1#p#p3	Single
test/table_part_1#p#p4	Single
test/table_part_2#p#p0	Single
test/table_part_2#p#p1	Single
test/table_part_2#p#p2	Single
test/table_part_2#p#p3	Single
test/table_part_2#p#p4	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4	Single
test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3	Single
test/table_part_cap_6#p#p0	Single
test/table_part_cap_6#p#p1	Single
test/table_part_cap_6#p#p2	Single
test/table_part_cap_6#p#p3	Single
test/table_part_cap_6#p#p4	Single
test/table_part_nopart_cap_7	General
test/table_part_sub_1#p#part_1#sp#part_1sp0	Single
test/table_part_sub_1#p#part_1#sp#part_1sp1	Single
test/table_part_sub_1#p#part_2#sp#part_2sp0	Single
test/table_part_sub_1#p#part_2#sp#part_2sp1	Single
test/table_part_sub_1#p#part_3#sp#part_3sp0	Single
test/table_part_sub_1#p#part_3#sp#part_3sp1	Single
test/table_part_sub_1#p#part_4#sp#part_4sp0	Single
test/table_part_sub_1#p#part_4#sp#part_4sp1	Single
test/table_part_sub_2#p#part_1#sp#sub_1	Single
test/table_part_sub_2#p#part_1#sp#sub_2	Single
test/table_part_sub_2#p#part_2#sp#sub_3	Single
test/table_part_sub_2#p#part_2#sp#sub_4	Single
test/table_part_sub_2#p#part_3#sp#sub_5	Single
test/table_part_sub_2#p#part_3#sp#sub_6	Single

select table_schema, table_name, partition_name, subpartition_name
from information_schema.partitions
where table_name LIKE '%table_part%'
  order by table_schema, table_name, partition_name, subpartition_name;
TABLE_SCHEMA	TABLE_NAME	PARTITION_NAME	SUBPARTITION_NAME
test	table_part_1	p0	NULL
test	table_part_1	p1	NULL
test	table_part_1	p2	NULL
test	table_part_1	p3	NULL
test	table_part_1	p4	NULL
test	table_part_2	p0	NULL
test	table_part_2	p1	NULL
test	table_part_2	p2	NULL
test	table_part_2	p3	NULL
test	table_part_2	p4	NULL
test	table_part_\_special_/_sub_?_3	PART_/_3	SUB_?/_5
test	table_part_\_special_/_sub_?_3	PART_/_3	sub_\/?_6
test	table_part_\_special_/_sub_?_3	Part_?_1	sUb_/_2
test	table_part_\_special_/_sub_?_3	Part_?_1	Sub_?_1
test	table_part_\_special_/_sub_?_3	pArt_\_2	SUB_?\_4
test	table_part_\_special_/_sub_?_3	pArt_\_2	suB_\_3
test	table_part_cap_6	p0	NULL
test	table_part_cap_6	p1	NULL
test	table_part_cap_6	p2	NULL
test	table_part_cap_6	p3	NULL
test	table_part_cap_6	p4	NULL
test	table_part_NOPART_CAP_7	NULL	NULL
test	table_part_sub_1	Part_1	Part_1sp0
test	table_part_sub_1	Part_1	Part_1sp1
test	table_part_sub_1	pArt_2	pArt_2sp0
test	table_part_sub_1	pArt_2	pArt_2sp1
test	table_part_sub_1	part_3	part_3sp0
test	table_part_sub_1	part_3	part_3sp1
test	table_part_sub_1	PART_4	PART_4sp0
test	table_part_sub_1	PART_4	PART_4sp1
test	table_part_sub_2	Part_1	Sub_1
test	table_part_sub_2	Part_1	sUb_2
test	table_part_sub_2	pArt_2	suB_3
test	table_part_sub_2	pArt_2	SUB_4
test	table_part_sub_2	PART_3	SUB_5
test	table_part_sub_2	PART_3	sub_6

select name from information_schema.innodb_tablespaces
where name LIKE '%table_part%' order by name;
name
test/table_part_1#p#p0
test/table_part_1#p#p1
test/table_part_1#p#p2
test/table_part_1#p#p3
test/table_part_1#p#p4
test/table_part_2#p#p0
test/table_part_2#p#p1
test/table_part_2#p#p2
test/table_part_2#p#p3
test/table_part_2#p#p4
test/table_part_cap_6#p#p0
test/table_part_cap_6#p#p1
test/table_part_cap_6#p#p2
test/table_part_cap_6#p#p3
test/table_part_cap_6#p#p4
test/table_part_sub_1#p#part_1#sp#part_1sp0
test/table_part_sub_1#p#part_1#sp#part_1sp1
test/table_part_sub_1#p#part_2#sp#part_2sp0
test/table_part_sub_1#p#part_2#sp#part_2sp1
test/table_part_sub_1#p#part_3#sp#part_3sp0
test/table_part_sub_1#p#part_3#sp#part_3sp1
test/table_part_sub_1#p#part_4#sp#part_4sp0
test/table_part_sub_1#p#part_4#sp#part_4sp1
test/table_part_sub_2#p#part_1#sp#sub_1
test/table_part_sub_2#p#part_1#sp#sub_2
test/table_part_sub_2#p#part_2#sp#sub_3
test/table_part_sub_2#p#part_2#sp#sub_4
test/table_part_sub_2#p#part_3#sp#sub_5
test/table_part_sub_2#p#part_3#sp#sub_6
test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3

select file_type, status, file_name, tablespace_name from information_schema.files
where file_name LIKE '%table_part%'
  order by file_type, status, file_name, tablespace_name;
FILE_TYPE	STATUS	FILE_NAME	TABLESPACE_NAME
TABLESPACE	NORMAL	./test/table_part_1#p#p0.ibd	test/table_part_1#p#p0
TABLESPACE	NORMAL	./test/table_part_1#p#p1.ibd	test/table_part_1#p#p1
TABLESPACE	NORMAL	./test/table_part_1#p#p2.ibd	test/table_part_1#p#p2
TABLESPACE	NORMAL	./test/table_part_1#p#p3.ibd	test/table_part_1#p#p3
TABLESPACE	NORMAL	./test/table_part_1#p#p4.ibd	test/table_part_1#p#p4
TABLESPACE	NORMAL	./test/table_part_2#p#p0.ibd	test/table_part_2#p#p0
TABLESPACE	NORMAL	./test/table_part_2#p#p1.ibd	test/table_part_2#p#p1
TABLESPACE	NORMAL	./test/table_part_2#p#p2.ibd	test/table_part_2#p#p2
TABLESPACE	NORMAL	./test/table_part_2#p#p3.ibd	test/table_part_2#p#p3
TABLESPACE	NORMAL	./test/table_part_2#p#p4.ibd	test/table_part_2#p#p4
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
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
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
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
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
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
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p0.ibd	test/table_part_cap_6#p#p0
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p1.ibd	test/table_part_cap_6#p#p1
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p2.ibd	test/table_part_cap_6#p#p2
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p3.ibd	test/table_part_cap_6#p#p3
TABLESPACE	NORMAL	./test/table_part_cap_6#p#p4.ibd	test/table_part_cap_6#p#p4
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
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
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
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
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
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
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
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
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
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
TABLESPACE	NORMAL	./test/table_part_sub_2#p#part_2#sp#sub_3.ibd	test/table_part_sub_2#p#part_2#sp#sub_3
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
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
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

Checking Innodb stat tables
---------------------------
select database_name, table_name from mysql.innodb_table_stats
where table_name like '%table_part%' order by database_name, table_name;
database_name	table_name
test	table_part_1#p#p0
test	table_part_1#p#p1
test	table_part_1#p#p2
test	table_part_1#p#p3
test	table_part_1#p#p4
test	table_part_2#p#p0
test	table_part_2#p#p1
test	table_part_2#p#p2
test	table_part_2#p#p3
test	table_part_2#p#p4
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
test	table_part_cap_6#p#p0
test	table_part_cap_6#p#p1
test	table_part_cap_6#p#p2
test	table_part_cap_6#p#p3
test	table_part_cap_6#p#p4
test	table_part_nopart_cap_7
test	table_part_sub_1#p#part_1#sp#part_1sp0
test	table_part_sub_1#p#part_1#sp#part_1sp1
test	table_part_sub_1#p#part_2#sp#part_2sp0
test	table_part_sub_1#p#part_2#sp#part_2sp1
test	table_part_sub_1#p#part_3#sp#part_3sp0
test	table_part_sub_1#p#part_3#sp#part_3sp1
test	table_part_sub_1#p#part_4#sp#part_4sp0
test	table_part_sub_1#p#part_4#sp#part_4sp1
test	table_part_sub_2#p#part_1#sp#sub_1
test	table_part_sub_2#p#part_1#sp#sub_2
test	table_part_sub_2#p#part_2#sp#sub_3
test	table_part_sub_2#p#part_2#sp#sub_4
test	table_part_sub_2#p#part_3#sp#sub_5
test	table_part_sub_2#p#part_3#sp#sub_6

select database_name, table_name, index_name, stat_name from mysql.innodb_index_stats
where table_name like '%table_part%'
  order by database_name, table_name, index_name, stat_name;
database_name	table_name	index_name	stat_name
test	table_part_1#p#p0	PRIMARY	n_diff_pfx01
test	table_part_1#p#p0	PRIMARY	n_leaf_pages
test	table_part_1#p#p0	PRIMARY	size
test	table_part_1#p#p0	k1	n_diff_pfx01
test	table_part_1#p#p0	k1	n_diff_pfx02
test	table_part_1#p#p0	k1	n_leaf_pages
test	table_part_1#p#p0	k1	size
test	table_part_1#p#p1	PRIMARY	n_diff_pfx01
test	table_part_1#p#p1	PRIMARY	n_leaf_pages
test	table_part_1#p#p1	PRIMARY	size
test	table_part_1#p#p1	k1	n_diff_pfx01
test	table_part_1#p#p1	k1	n_diff_pfx02
test	table_part_1#p#p1	k1	n_leaf_pages
test	table_part_1#p#p1	k1	size
test	table_part_1#p#p2	PRIMARY	n_diff_pfx01
test	table_part_1#p#p2	PRIMARY	n_leaf_pages
test	table_part_1#p#p2	PRIMARY	size
test	table_part_1#p#p2	k1	n_diff_pfx01
test	table_part_1#p#p2	k1	n_diff_pfx02
test	table_part_1#p#p2	k1	n_leaf_pages
test	table_part_1#p#p2	k1	size
test	table_part_1#p#p3	PRIMARY	n_diff_pfx01
test	table_part_1#p#p3	PRIMARY	n_leaf_pages
test	table_part_1#p#p3	PRIMARY	size
test	table_part_1#p#p3	k1	n_diff_pfx01
test	table_part_1#p#p3	k1	n_diff_pfx02
test	table_part_1#p#p3	k1	n_leaf_pages
test	table_part_1#p#p3	k1	size
test	table_part_1#p#p4	PRIMARY	n_diff_pfx01
test	table_part_1#p#p4	PRIMARY	n_leaf_pages
test	table_part_1#p#p4	PRIMARY	size
test	table_part_1#p#p4	k1	n_diff_pfx01
test	table_part_1#p#p4	k1	n_diff_pfx02
test	table_part_1#p#p4	k1	n_leaf_pages
test	table_part_1#p#p4	k1	size
test	table_part_2#p#p0	PRIMARY	n_diff_pfx01
test	table_part_2#p#p0	PRIMARY	n_leaf_pages
test	table_part_2#p#p0	PRIMARY	size
test	table_part_2#p#p0	k1	n_diff_pfx01
test	table_part_2#p#p0	k1	n_diff_pfx02
test	table_part_2#p#p0	k1	n_leaf_pages
test	table_part_2#p#p0	k1	size
test	table_part_2#p#p1	PRIMARY	n_diff_pfx01
test	table_part_2#p#p1	PRIMARY	n_leaf_pages
test	table_part_2#p#p1	PRIMARY	size
test	table_part_2#p#p1	k1	n_diff_pfx01
test	table_part_2#p#p1	k1	n_diff_pfx02
test	table_part_2#p#p1	k1	n_leaf_pages
test	table_part_2#p#p1	k1	size
test	table_part_2#p#p2	PRIMARY	n_diff_pfx01
test	table_part_2#p#p2	PRIMARY	n_leaf_pages
test	table_part_2#p#p2	PRIMARY	size
test	table_part_2#p#p2	k1	n_diff_pfx01
test	table_part_2#p#p2	k1	n_diff_pfx02
test	table_part_2#p#p2	k1	n_leaf_pages
test	table_part_2#p#p2	k1	size
test	table_part_2#p#p3	PRIMARY	n_diff_pfx01
test	table_part_2#p#p3	PRIMARY	n_leaf_pages
test	table_part_2#p#p3	PRIMARY	size
test	table_part_2#p#p3	k1	n_diff_pfx01
test	table_part_2#p#p3	k1	n_diff_pfx02
test	table_part_2#p#p3	k1	n_leaf_pages
test	table_part_2#p#p3	k1	size
test	table_part_2#p#p4	PRIMARY	n_diff_pfx01
test	table_part_2#p#p4	PRIMARY	n_leaf_pages
test	table_part_2#p#p4	PRIMARY	size
test	table_part_2#p#p4	k1	n_diff_pfx01
test	table_part_2#p#p4	k1	n_diff_pfx02
test	table_part_2#p#p4	k1	n_leaf_pages
test	table_part_2#p#p4	k1	size
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5	k1	size
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6	k1	size
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2	k1	size
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1	k1	size
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4	k1	size
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	PRIMARY	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	PRIMARY	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	PRIMARY	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	PRIMARY	size
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	k1	n_diff_pfx01
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	k1	n_diff_pfx02
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	k1	n_leaf_pages
test	table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3	k1	size
test	table_part_cap_6#p#p0	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p0	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p0	PRIMARY	size
test	table_part_cap_6#p#p0	k1	n_diff_pfx01
test	table_part_cap_6#p#p0	k1	n_diff_pfx02
test	table_part_cap_6#p#p0	k1	n_leaf_pages
test	table_part_cap_6#p#p0	k1	size
test	table_part_cap_6#p#p1	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p1	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p1	PRIMARY	size
test	table_part_cap_6#p#p1	k1	n_diff_pfx01
test	table_part_cap_6#p#p1	k1	n_diff_pfx02
test	table_part_cap_6#p#p1	k1	n_leaf_pages
test	table_part_cap_6#p#p1	k1	size
test	table_part_cap_6#p#p2	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p2	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p2	PRIMARY	size
test	table_part_cap_6#p#p2	k1	n_diff_pfx01
test	table_part_cap_6#p#p2	k1	n_diff_pfx02
test	table_part_cap_6#p#p2	k1	n_leaf_pages
test	table_part_cap_6#p#p2	k1	size
test	table_part_cap_6#p#p3	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p3	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p3	PRIMARY	size
test	table_part_cap_6#p#p3	k1	n_diff_pfx01
test	table_part_cap_6#p#p3	k1	n_diff_pfx02
test	table_part_cap_6#p#p3	k1	n_leaf_pages
test	table_part_cap_6#p#p3	k1	size
test	table_part_cap_6#p#p4	PRIMARY	n_diff_pfx01
test	table_part_cap_6#p#p4	PRIMARY	n_leaf_pages
test	table_part_cap_6#p#p4	PRIMARY	size
test	table_part_cap_6#p#p4	k1	n_diff_pfx01
test	table_part_cap_6#p#p4	k1	n_diff_pfx02
test	table_part_cap_6#p#p4	k1	n_leaf_pages
test	table_part_cap_6#p#p4	k1	size
test	table_part_nopart_cap_7	PRIMARY	n_diff_pfx01
test	table_part_nopart_cap_7	PRIMARY	n_leaf_pages
test	table_part_nopart_cap_7	PRIMARY	size
test	table_part_nopart_cap_7	k1	n_diff_pfx01
test	table_part_nopart_cap_7	k1	n_diff_pfx02
test	table_part_nopart_cap_7	k1	n_leaf_pages
test	table_part_nopart_cap_7	k1	size
test	table_part_sub_1#p#part_1#sp#part_1sp0	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_1#sp#part_1sp0	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_1#sp#part_1sp0	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_1#sp#part_1sp0	PRIMARY	size
test	table_part_sub_1#p#part_1#sp#part_1sp0	k1	n_diff_pfx01
test	table_part_sub_1#p#part_1#sp#part_1sp0	k1	n_diff_pfx02
test	table_part_sub_1#p#part_1#sp#part_1sp0	k1	n_leaf_pages
test	table_part_sub_1#p#part_1#sp#part_1sp0	k1	size
test	table_part_sub_1#p#part_1#sp#part_1sp1	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_1#sp#part_1sp1	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_1#sp#part_1sp1	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_1#sp#part_1sp1	PRIMARY	size
test	table_part_sub_1#p#part_1#sp#part_1sp1	k1	n_diff_pfx01
test	table_part_sub_1#p#part_1#sp#part_1sp1	k1	n_diff_pfx02
test	table_part_sub_1#p#part_1#sp#part_1sp1	k1	n_leaf_pages
test	table_part_sub_1#p#part_1#sp#part_1sp1	k1	size
test	table_part_sub_1#p#part_2#sp#part_2sp0	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_2#sp#part_2sp0	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_2#sp#part_2sp0	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_2#sp#part_2sp0	PRIMARY	size
test	table_part_sub_1#p#part_2#sp#part_2sp0	k1	n_diff_pfx01
test	table_part_sub_1#p#part_2#sp#part_2sp0	k1	n_diff_pfx02
test	table_part_sub_1#p#part_2#sp#part_2sp0	k1	n_leaf_pages
test	table_part_sub_1#p#part_2#sp#part_2sp0	k1	size
test	table_part_sub_1#p#part_2#sp#part_2sp1	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_2#sp#part_2sp1	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_2#sp#part_2sp1	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_2#sp#part_2sp1	PRIMARY	size
test	table_part_sub_1#p#part_2#sp#part_2sp1	k1	n_diff_pfx01
test	table_part_sub_1#p#part_2#sp#part_2sp1	k1	n_diff_pfx02
test	table_part_sub_1#p#part_2#sp#part_2sp1	k1	n_leaf_pages
test	table_part_sub_1#p#part_2#sp#part_2sp1	k1	size
test	table_part_sub_1#p#part_3#sp#part_3sp0	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_3#sp#part_3sp0	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_3#sp#part_3sp0	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_3#sp#part_3sp0	PRIMARY	size
test	table_part_sub_1#p#part_3#sp#part_3sp0	k1	n_diff_pfx01
test	table_part_sub_1#p#part_3#sp#part_3sp0	k1	n_diff_pfx02
test	table_part_sub_1#p#part_3#sp#part_3sp0	k1	n_leaf_pages
test	table_part_sub_1#p#part_3#sp#part_3sp0	k1	size
test	table_part_sub_1#p#part_3#sp#part_3sp1	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_3#sp#part_3sp1	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_3#sp#part_3sp1	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_3#sp#part_3sp1	PRIMARY	size
test	table_part_sub_1#p#part_3#sp#part_3sp1	k1	n_diff_pfx01
test	table_part_sub_1#p#part_3#sp#part_3sp1	k1	n_diff_pfx02
test	table_part_sub_1#p#part_3#sp#part_3sp1	k1	n_leaf_pages
test	table_part_sub_1#p#part_3#sp#part_3sp1	k1	size
test	table_part_sub_1#p#part_4#sp#part_4sp0	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_4#sp#part_4sp0	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_4#sp#part_4sp0	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_4#sp#part_4sp0	PRIMARY	size
test	table_part_sub_1#p#part_4#sp#part_4sp0	k1	n_diff_pfx01
test	table_part_sub_1#p#part_4#sp#part_4sp0	k1	n_diff_pfx02
test	table_part_sub_1#p#part_4#sp#part_4sp0	k1	n_leaf_pages
test	table_part_sub_1#p#part_4#sp#part_4sp0	k1	size
test	table_part_sub_1#p#part_4#sp#part_4sp1	PRIMARY	n_diff_pfx01
test	table_part_sub_1#p#part_4#sp#part_4sp1	PRIMARY	n_diff_pfx02
test	table_part_sub_1#p#part_4#sp#part_4sp1	PRIMARY	n_leaf_pages
test	table_part_sub_1#p#part_4#sp#part_4sp1	PRIMARY	size
test	table_part_sub_1#p#part_4#sp#part_4sp1	k1	n_diff_pfx01
test	table_part_sub_1#p#part_4#sp#part_4sp1	k1	n_diff_pfx02
test	table_part_sub_1#p#part_4#sp#part_4sp1	k1	n_leaf_pages
test	table_part_sub_1#p#part_4#sp#part_4sp1	k1	size
test	table_part_sub_2#p#part_1#sp#sub_1	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_1#sp#sub_1	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_1#sp#sub_1	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_1#sp#sub_1	PRIMARY	size
test	table_part_sub_2#p#part_1#sp#sub_1	k1	n_diff_pfx01
test	table_part_sub_2#p#part_1#sp#sub_1	k1	n_diff_pfx02
test	table_part_sub_2#p#part_1#sp#sub_1	k1	n_leaf_pages
test	table_part_sub_2#p#part_1#sp#sub_1	k1	size
test	table_part_sub_2#p#part_1#sp#sub_2	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_1#sp#sub_2	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_1#sp#sub_2	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_1#sp#sub_2	PRIMARY	size
test	table_part_sub_2#p#part_1#sp#sub_2	k1	n_diff_pfx01
test	table_part_sub_2#p#part_1#sp#sub_2	k1	n_diff_pfx02
test	table_part_sub_2#p#part_1#sp#sub_2	k1	n_leaf_pages
test	table_part_sub_2#p#part_1#sp#sub_2	k1	size
test	table_part_sub_2#p#part_2#sp#sub_3	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_2#sp#sub_3	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_2#sp#sub_3	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_2#sp#sub_3	PRIMARY	size
test	table_part_sub_2#p#part_2#sp#sub_3	k1	n_diff_pfx01
test	table_part_sub_2#p#part_2#sp#sub_3	k1	n_diff_pfx02
test	table_part_sub_2#p#part_2#sp#sub_3	k1	n_leaf_pages
test	table_part_sub_2#p#part_2#sp#sub_3	k1	size
test	table_part_sub_2#p#part_2#sp#sub_4	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_2#sp#sub_4	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_2#sp#sub_4	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_2#sp#sub_4	PRIMARY	size
test	table_part_sub_2#p#part_2#sp#sub_4	k1	n_diff_pfx01
test	table_part_sub_2#p#part_2#sp#sub_4	k1	n_diff_pfx02
test	table_part_sub_2#p#part_2#sp#sub_4	k1	n_leaf_pages
test	table_part_sub_2#p#part_2#sp#sub_4	k1	size
test	table_part_sub_2#p#part_3#sp#sub_5	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_3#sp#sub_5	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_3#sp#sub_5	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_3#sp#sub_5	PRIMARY	size
test	table_part_sub_2#p#part_3#sp#sub_5	k1	n_diff_pfx01
test	table_part_sub_2#p#part_3#sp#sub_5	k1	n_diff_pfx02
test	table_part_sub_2#p#part_3#sp#sub_5	k1	n_leaf_pages
test	table_part_sub_2#p#part_3#sp#sub_5	k1	size
test	table_part_sub_2#p#part_3#sp#sub_6	PRIMARY	n_diff_pfx01
test	table_part_sub_2#p#part_3#sp#sub_6	PRIMARY	n_diff_pfx02
test	table_part_sub_2#p#part_3#sp#sub_6	PRIMARY	n_leaf_pages
test	table_part_sub_2#p#part_3#sp#sub_6	PRIMARY	size
test	table_part_sub_2#p#part_3#sp#sub_6	k1	n_diff_pfx01
test	table_part_sub_2#p#part_3#sp#sub_6	k1	n_diff_pfx02
test	table_part_sub_2#p#part_3#sp#sub_6	k1	n_leaf_pages
test	table_part_sub_2#p#part_3#sp#sub_6	k1	size

Checking DD tables
------------------
SET DEBUG='+d,skip_dd_table_access_check';

select t.name as "table", p.name as "partition", p.number
from mysql.tables t, mysql.table_partitions p
where p.table_id = t.id
order by t.name, p.name, p.number;
table	partition	number
table_part_1	p0	0
table_part_1	p1	1
table_part_1	p2	2
table_part_1	p3	3
table_part_1	p4	4
table_part_2	p0	0
table_part_2	p1	1
table_part_2	p2	2
table_part_2	p3	3
table_part_2	p4	4
table_part_\_special_/_sub_?_3	PART_/_3	2
table_part_\_special_/_sub_?_3	Part_?_1	0
table_part_\_special_/_sub_?_3	pArt_\_2	1
table_part_\_special_/_sub_?_3	sUb_/_2	1
table_part_\_special_/_sub_?_3	SUB_?/_5	0
table_part_\_special_/_sub_?_3	SUB_?\_4	1
table_part_\_special_/_sub_?_3	Sub_?_1	0
table_part_\_special_/_sub_?_3	sub_\/?_6	1
table_part_\_special_/_sub_?_3	suB_\_3	0
table_part_cap_6	p0	0
table_part_cap_6	p1	1
table_part_cap_6	p2	2
table_part_cap_6	p3	3
table_part_cap_6	p4	4
table_part_sub_1	Part_1	0
table_part_sub_1	Part_1sp0	0
table_part_sub_1	Part_1sp1	1
table_part_sub_1	pArt_2	1
table_part_sub_1	pArt_2sp0	0
table_part_sub_1	pArt_2sp1	1
table_part_sub_1	part_3	2
table_part_sub_1	part_3sp0	0
table_part_sub_1	part_3sp1	1
table_part_sub_1	PART_4	3
table_part_sub_1	PART_4sp0	0
table_part_sub_1	PART_4sp1	1
table_part_sub_2	Part_1	0
table_part_sub_2	pArt_2	1
table_part_sub_2	PART_3	2
table_part_sub_2	Sub_1	0
table_part_sub_2	sUb_2	1
table_part_sub_2	suB_3	0
table_part_sub_2	SUB_4	1
table_part_sub_2	SUB_5	0
table_part_sub_2	sub_6	1

select name from mysql.tablespaces
where name like '%table_part%' order by name;
name
test/table_part_1#p#p0
test/table_part_1#p#p1
test/table_part_1#p#p2
test/table_part_1#p#p3
test/table_part_1#p#p4
test/table_part_2#p#p0
test/table_part_2#p#p1
test/table_part_2#p#p2
test/table_part_2#p#p3
test/table_part_2#p#p4
test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_?/_5
test/table_part_\_special_/_sub_?_3#p#part_/_3#sp#sub_\/?_6
test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_/_2
test/table_part_\_special_/_sub_?_3#p#part_?_1#sp#sub_?_1
test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_?\_4
test/table_part_\_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
test/table_part_cap_6#p#p0
test/table_part_cap_6#p#p1
test/table_part_cap_6#p#p2
test/table_part_cap_6#p#p3
test/table_part_cap_6#p#p4
test/table_part_sub_1#p#part_1#sp#part_1sp0
test/table_part_sub_1#p#part_1#sp#part_1sp1
test/table_part_sub_1#p#part_2#sp#part_2sp0
test/table_part_sub_1#p#part_2#sp#part_2sp1
test/table_part_sub_1#p#part_3#sp#part_3sp0
test/table_part_sub_1#p#part_3#sp#part_3sp1
test/table_part_sub_1#p#part_4#sp#part_4sp0
test/table_part_sub_1#p#part_4#sp#part_4sp1
test/table_part_sub_2#p#part_1#sp#sub_1
test/table_part_sub_2#p#part_1#sp#sub_2
test/table_part_sub_2#p#part_2#sp#sub_3
test/table_part_sub_2#p#part_2#sp#sub_4
test/table_part_sub_2#p#part_3#sp#sub_5
test/table_part_sub_2#p#part_3#sp#sub_6

select file_name from mysql.tablespace_files
where file_name like '%table_part%' order by file_name;
file_name
./test/table_part_1#p#p0.ibd
./test/table_part_1#p#p1.ibd
./test/table_part_1#p#p2.ibd
./test/table_part_1#p#p3.ibd
./test/table_part_1#p#p4.ibd
./test/table_part_2#p#p0.ibd
./test/table_part_2#p#p1.ibd
./test/table_part_2#p#p2.ibd
./test/table_part_2#p#p3.ibd
./test/table_part_2#p#p4.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@003f@002f_5.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@002f_3#sp#sub_@005c@002f@003f_6.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@002f_2.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@003f_1#sp#sub_@003f_1.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@003f@005c_4.ibd
./test/table_part_@005c_special_@002f_sub_@003f_3#p#part_@005c_2#sp#sub_@005c_3.ibd
./test/table_part_cap_6#p#p0.ibd
./test/table_part_cap_6#p#p1.ibd
./test/table_part_cap_6#p#p2.ibd
./test/table_part_cap_6#p#p3.ibd
./test/table_part_cap_6#p#p4.ibd
./test/table_part_sub_1#p#part_1#sp#part_1sp0.ibd
./test/table_part_sub_1#p#part_1#sp#part_1sp1.ibd
./test/table_part_sub_1#p#part_2#sp#part_2sp0.ibd
./test/table_part_sub_1#p#part_2#sp#part_2sp1.ibd
./test/table_part_sub_1#p#part_3#sp#part_3sp0.ibd
./test/table_part_sub_1#p#part_3#sp#part_3sp1.ibd
./test/table_part_sub_1#p#part_4#sp#part_4sp0.ibd
./test/table_part_sub_1#p#part_4#sp#part_4sp1.ibd
./test/table_part_sub_2#p#part_1#sp#sub_1.ibd
./test/table_part_sub_2#p#part_1#sp#sub_2.ibd
./test/table_part_sub_2#p#part_2#sp#sub_3.ibd
./test/table_part_sub_2#p#part_2#sp#sub_4.ibd
./test/table_part_sub_2#p#part_3#sp#sub_5.ibd
./test/table_part_sub_2#p#part_3#sp#sub_6.ibd
SET DEBUG='-d,skip_dd_table_access_check';
SET NAMES DEFAULT;
# 2. Do DML insert/update/delete on upgraded tables
DML on partitioned tables
-------------------------

insert into table_part_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update table_part_1 set name = 'Row - updated' where value > 500;

delete from table_part_1 where id = 7;

insert into table_part_sub_1 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update table_part_sub_1 set name = 'Row - updated' where value > 500;

delete from table_part_sub_1 where id = 7;

insert into table_part_sub_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update table_part_sub_2 set name = 'Row - updated' where value > 500;

delete from table_part_sub_2 where id = 7;

insert into `table_part_\_special_/_sub_?_3` values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update `table_part_\_special_/_sub_?_3` set name = 'Row - updated' where value > 500;

delete from `table_part_\_special_/_sub_?_3` where id = 7;

insert into table_part_2 values(15, 1555, "Row - 15", REPEAT('Large Column Data - 15' , 256));

update table_part_2 set name = 'Row - updated' where value > 500;

delete from table_part_2 where id = 7;
# 3. Do DDL ALTER/DROP on upgraded tables
DDL on partitioned tables
-------------------------
ALTER TABLE table_part_1 TRUNCATE PARTITION p0;

ALTER TABLE table_part_1 COALESCE PARTITION 2;

SHOW CREATE TABLE table_part_1;
Table	Create Table
table_part_1	CREATE TABLE `table_part_1` (
  `id` int NOT NULL,
  `value` int DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY HASH (`id`)
PARTITIONS 3 */

ALTER TABLE table_part_sub_1 TRUNCATE PARTITION part_1;

ALTER TABLE table_part_sub_2 TRUNCATE PARTITION part_3;

CREATE TABLE test_table LIKE table_part_sub_2;

ALTER TABLE test_table REMOVE PARTITIONING;
insert into test_table values(2, 265, "Row - 2", REPEAT('Large Column Data - 2' , 256));

SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
id	value	name
2	255	Row - 2
4	455	Row - 4

SELECT id, value, name FROM test_table order by id;
id	value	name
2	265	Row - 2

ALTER TABLE table_part_sub_2 EXCHANGE PARTITION sub_3 WITH TABLE test_table;

SELECT id, value, name FROM table_part_sub_2 PARTITION (sub_3) order by id;
id	value	name
2	265	Row - 2

SELECT id, value, name FROM test_table order by id;
id	value	name
2	255	Row - 2
4	455	Row - 4

DROP TABLE test_table;

ALTER TABLE table_part_sub_2 RENAME renamed_table;;
SHOW CREATE TABLE renamed_table;
Table	Create Table
renamed_table	CREATE TABLE `renamed_table` (
  `id` int NOT NULL,
  `value` int NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`,`value`),
  KEY `k1` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY RANGE (`value`)
SUBPARTITION BY HASH (`id`)
(PARTITION Part_1 VALUES LESS THAN (101)
 (SUBPARTITION Sub_1 ENGINE = InnoDB,
  SUBPARTITION sUb_2 ENGINE = InnoDB),
 PARTITION pArt_2 VALUES LESS THAN (501)
 (SUBPARTITION suB_3 ENGINE = InnoDB,
  SUBPARTITION SUB_4 ENGINE = InnoDB),
 PARTITION PART_3 VALUES LESS THAN MAXVALUE
 (SUBPARTITION SUB_5 ENGINE = InnoDB,
  SUBPARTITION sub_6 ENGINE = InnoDB)) */

ALTER TABLE renamed_table RENAME table_part_sub_2;;

ALTER TABLE table_part_1 ENGINE = InnoDB;;

ALTER TABLE table_part_1 ADD COLUMN new_id int AFTER id;

ALTER TABLE table_part_1 REMOVE PARTITIONING;

ALTER TABLE table_part_sub_1 ENGINE = InnoDB;;

ALTER TABLE table_part_sub_1 ADD COLUMN new_id int AFTER id;

ALTER TABLE table_part_sub_1 REMOVE PARTITIONING;

ALTER TABLE table_part_sub_2 ENGINE = InnoDB;;

ALTER TABLE table_part_sub_2 ADD COLUMN new_id int AFTER id;

ALTER TABLE table_part_sub_2 REMOVE PARTITIONING;

ALTER TABLE `table_part_\_special_/_sub_?_3` ENGINE = InnoDB;;

ALTER TABLE `table_part_\_special_/_sub_?_3` ADD COLUMN new_id int AFTER id;

ALTER TABLE `table_part_\_special_/_sub_?_3` REMOVE PARTITIONING;

ALTER TABLE table_part_2 ENGINE = InnoDB;;

ALTER TABLE table_part_2 ADD COLUMN new_id int AFTER id;

ALTER TABLE table_part_2 REMOVE PARTITIONING;

# Shutdown server

# Remove upgraded data directory.

# Cleanup: Restart with default options.
# restart