 # 0. Check table metadata and data Checking partitioned tables --------------------------- SET NAMES utf0mb0 COLLATE utf0mb0_0000_as_cs;  CHECK TABLE table_part_0; Table Op Msg_type Msg_text test.table_part_0 check status OK  SHOW CREATE TABLE table_part_0; Table Create Table table_part_0 CREATE TABLE `table_part_0` (   `id` int NOT NULL,   `value` int DEFAULT NULL,   `name` varchar(00) DEFAULT NULL,   `data` blob,   PRIMARY KEY (`id`),   KEY `k0` (`value`) ) ENGINE=InnoDB DEFAULT CHARSET=latin0 /*!00000 PARTITION BY HASH (`id`) PARTITIONS 0 */  SELECT id, value, name, SUBSTRING(data, 0000, 00) FROM table_part_0 order by id; id value name SUBSTRING(data, 0000, 00) 0 00 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large  CHECK TABLE table_part_sub_0; Table Op Msg_type Msg_text test.table_part_sub_0 check status OK  SHOW CREATE TABLE table_part_sub_0; Table Create Table table_part_sub_0 CREATE TABLE `table_part_sub_0` (   `id` int NOT NULL,   `value` int NOT NULL,   `name` varchar(00) DEFAULT NULL,   `data` blob,   PRIMARY KEY (`id`,`value`),   KEY `k0` (`value`) ) ENGINE=InnoDB DEFAULT CHARSET=latin0 /*!00000 PARTITION BY RANGE (`value`) SUBPARTITION BY HASH (`id`) SUBPARTITIONS 0 (PARTITION Part_0 VALUES LESS THAN (000) ENGINE = InnoDB,  PARTITION pArt_0 VALUES LESS THAN (000) ENGINE = InnoDB,  PARTITION part_0 VALUES LESS THAN (000) ENGINE = InnoDB,  PARTITION PART_0 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */  SELECT id, value, name, SUBSTRING(data, 0000, 00) FROM table_part_sub_0 order by id; id value name SUBSTRING(data, 0000, 00) 0 00 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large  CHECK TABLE table_part_sub_0; Table Op Msg_type Msg_text test.table_part_sub_0 check status OK  SHOW CREATE TABLE table_part_sub_0; Table Create Table table_part_sub_0 CREATE TABLE `table_part_sub_0` (   `id` int NOT NULL,   `value` int NOT NULL,   `name` varchar(00) DEFAULT NULL,   `data` blob,   PRIMARY KEY (`id`,`value`),   KEY `k0` (`value`) ) ENGINE=InnoDB DEFAULT CHARSET=latin0 /*!00000 PARTITION BY RANGE (`value`) SUBPARTITION BY HASH (`id`) (PARTITION Part_0 VALUES LESS THAN (000)  (SUBPARTITION Sub_0 ENGINE = InnoDB,   SUBPARTITION sUb_0 ENGINE = InnoDB),  PARTITION pArt_0 VALUES LESS THAN (000)  (SUBPARTITION suB_0 ENGINE = InnoDB,   SUBPARTITION SUB_0 ENGINE = InnoDB),  PARTITION PART_0 VALUES LESS THAN MAXVALUE  (SUBPARTITION SUB_0 ENGINE = InnoDB,   SUBPARTITION sub_0 ENGINE = InnoDB)) */  SELECT id, value, name, SUBSTRING(data, 0000, 00) FROM table_part_sub_0 order by id; id value name SUBSTRING(data, 0000, 00) 0 00 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large  CHECK TABLE `table_part_\_special_/_sub_?_0`; Table Op Msg_type Msg_text test.table_part_\_special_/_sub_?_0 check status OK  SHOW CREATE TABLE `table_part_\_special_/_sub_?_0`; Table Create Table table_part_\_special_/_sub_?_0 CREATE TABLE `table_part_\_special_/_sub_?_0` (   `id` int NOT NULL,   `value` int NOT NULL,   `name` varchar(00) DEFAULT NULL,   `data` blob,   PRIMARY KEY (`id`,`value`),   KEY `k0` (`value`) ) ENGINE=InnoDB DEFAULT CHARSET=latin0 /*!00000 PARTITION BY RANGE (`value`) SUBPARTITION BY HASH (`id`) (PARTITION `Part_?_0` VALUES LESS THAN (000)  (SUBPARTITION `Sub_?_0` ENGINE = InnoDB,   SUBPARTITION `sUb_/_0` ENGINE = InnoDB),  PARTITION `pArt_\_0` VALUES LESS THAN (000)  (SUBPARTITION `suB_\_0` ENGINE = InnoDB,   SUBPARTITION `SUB_?\_0` ENGINE = InnoDB),  PARTITION `PART_/_0` VALUES LESS THAN MAXVALUE  (SUBPARTITION `SUB_?/_0` ENGINE = InnoDB,   SUBPARTITION `sub_\/?_0` ENGINE = InnoDB)) */  SELECT id, value, name, SUBSTRING(data, 0000, 00) FROM `table_part_\_special_/_sub_?_0` order by id; id value name SUBSTRING(data, 0000, 00) 0 00 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large  CHECK TABLE table_part_0; Table Op Msg_type Msg_text test.table_part_0 check status OK  SHOW CREATE TABLE table_part_0; Table Create Table table_part_0 CREATE TABLE `table_part_0` (   `id` int NOT NULL,   `value` int DEFAULT NULL,   `name` varchar(00) DEFAULT NULL,   `data` blob,   PRIMARY KEY (`id`),   KEY `k0` (`value`) ) ENGINE=InnoDB DEFAULT CHARSET=latin0 /*!00000 PARTITION BY HASH (`id`) PARTITIONS 0 */  SELECT id, value, name, SUBSTRING(data, 0000, 00) FROM table_part_0 order by id; id value name SUBSTRING(data, 0000, 00) 0 00 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large 0 000 Row - 0 ta - 0Large Column Data - 0Large  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_0 test table_part_0 test table_part_\_special_/_sub_?_0 test table_part_cap_0 test table_part_nopart_cap_0 test table_part_sub_0 test table_part_sub_0  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_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_0#p#p0 Single test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f@000f_0 Single test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000c@000f@000f_0 Single test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f_0 Single test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f_0 Single test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000c_0#sp#sub_@000f@000c_0 Single test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000c_0#sp#sub_@000c_0 Single test/table_part_cap_0#p#p0 Single test/table_part_cap_0#p#p0 Single test/table_part_cap_0#p#p0 Single test/table_part_cap_0#p#p0 Single test/table_part_cap_0#p#p0 Single test/table_part_nopart_cap_0 General test/table_part_sub_0#p#part_0#sp#part_0sp0 Single test/table_part_sub_0#p#part_0#sp#part_0sp0 Single test/table_part_sub_0#p#part_0#sp#part_0sp0 Single test/table_part_sub_0#p#part_0#sp#part_0sp0 Single test/table_part_sub_0#p#part_0#sp#part_0sp0 Single test/table_part_sub_0#p#part_0#sp#part_0sp0 Single test/table_part_sub_0#p#part_0#sp#part_0sp0 Single test/table_part_sub_0#p#part_0#sp#part_0sp0 Single test/table_part_sub_0#p#part_0#sp#sub_0 Single test/table_part_sub_0#p#part_0#sp#sub_0 Single test/table_part_sub_0#p#part_0#sp#sub_0 Single test/table_part_sub_0#p#part_0#sp#sub_0 Single test/table_part_sub_0#p#part_0#sp#sub_0 Single test/table_part_sub_0#p#part_0#sp#sub_0 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_0 p0 NULL test table_part_0 p0 NULL test table_part_0 p0 NULL test table_part_0 p0 NULL test table_part_0 p0 NULL test table_part_0 p0 NULL test table_part_0 p0 NULL test table_part_0 p0 NULL test table_part_0 p0 NULL test table_part_0 p0 NULL test table_part_\_special_/_sub_?_0 PART_/_0 SUB_?/_0 test table_part_\_special_/_sub_?_0 PART_/_0 sub_\/?_0 test table_part_\_special_/_sub_?_0 Part_?_0 sUb_/_0 test table_part_\_special_/_sub_?_0 Part_?_0 Sub_?_0 test table_part_\_special_/_sub_?_0 pArt_\_0 SUB_?\_0 test table_part_\_special_/_sub_?_0 pArt_\_0 suB_\_0 test table_part_cap_0 p0 NULL test table_part_cap_0 p0 NULL test table_part_cap_0 p0 NULL test table_part_cap_0 p0 NULL test table_part_cap_0 p0 NULL test table_part_nopart_cap_0 NULL NULL test table_part_sub_0 Part_0 Part_0sp0 test table_part_sub_0 Part_0 Part_0sp0 test table_part_sub_0 pArt_0 pArt_0sp0 test table_part_sub_0 pArt_0 pArt_0sp0 test table_part_sub_0 part_0 part_0sp0 test table_part_sub_0 part_0 part_0sp0 test table_part_sub_0 PART_0 PART_0sp0 test table_part_sub_0 PART_0 PART_0sp0 test table_part_sub_0 Part_0 Sub_0 test table_part_sub_0 Part_0 sUb_0 test table_part_sub_0 pArt_0 suB_0 test table_part_sub_0 pArt_0 SUB_0 test table_part_sub_0 PART_0 SUB_0 test table_part_sub_0 PART_0 sub_0  select name from information_schema.innodb_tablespaces where name LIKE '%table_part%' order by name; name test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 test/table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 test/table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 test/table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 test/table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 test/table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0  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_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_0#p#p0.ibd test/table_part_0#p#p0 TABLESPACE NORMAL ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f@000f_0.ibd test/table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 TABLESPACE NORMAL ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000c@000f@000f_0.ibd test/table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 TABLESPACE NORMAL ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f_0.ibd test/table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 TABLESPACE NORMAL ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f_0.ibd test/table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 TABLESPACE NORMAL ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000c_0#sp#sub_@000f@000c_0.ibd test/table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 TABLESPACE NORMAL ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000c_0#sp#sub_@000c_0.ibd test/table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 TABLESPACE NORMAL ./test/table_part_cap_0#p#p0.ibd test/table_part_cap_0#p#p0 TABLESPACE NORMAL ./test/table_part_cap_0#p#p0.ibd test/table_part_cap_0#p#p0 TABLESPACE NORMAL ./test/table_part_cap_0#p#p0.ibd test/table_part_cap_0#p#p0 TABLESPACE NORMAL ./test/table_part_cap_0#p#p0.ibd test/table_part_cap_0#p#p0 TABLESPACE NORMAL ./test/table_part_cap_0#p#p0.ibd test/table_part_cap_0#p#p0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd test/table_part_sub_0#p#part_0#sp#part_0sp0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd test/table_part_sub_0#p#part_0#sp#part_0sp0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd test/table_part_sub_0#p#part_0#sp#part_0sp0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd test/table_part_sub_0#p#part_0#sp#part_0sp0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd test/table_part_sub_0#p#part_0#sp#part_0sp0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd test/table_part_sub_0#p#part_0#sp#part_0sp0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd test/table_part_sub_0#p#part_0#sp#part_0sp0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd test/table_part_sub_0#p#part_0#sp#part_0sp0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd test/table_part_sub_0#p#part_0#sp#sub_0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd test/table_part_sub_0#p#part_0#sp#sub_0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd test/table_part_sub_0#p#part_0#sp#sub_0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd test/table_part_sub_0#p#part_0#sp#sub_0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd test/table_part_sub_0#p#part_0#sp#sub_0 TABLESPACE NORMAL ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd test/table_part_sub_0#p#part_0#sp#sub_0  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_0#p#p0 test table_part_0#p#p0 test table_part_0#p#p0 test table_part_0#p#p0 test table_part_0#p#p0 test table_part_0#p#p0 test table_part_0#p#p0 test table_part_0#p#p0 test table_part_0#p#p0 test table_part_0#p#p0 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 test table_part_cap_0#p#p0 test table_part_cap_0#p#p0 test table_part_cap_0#p#p0 test table_part_cap_0#p#p0 test table_part_cap_0#p#p0 test table_part_nopart_cap_0 test table_part_sub_0#p#part_0#sp#part_0sp0 test table_part_sub_0#p#part_0#sp#part_0sp0 test table_part_sub_0#p#part_0#sp#part_0sp0 test table_part_sub_0#p#part_0#sp#part_0sp0 test table_part_sub_0#p#part_0#sp#part_0sp0 test table_part_sub_0#p#part_0#sp#part_0sp0 test table_part_sub_0#p#part_0#sp#part_0sp0 test table_part_sub_0#p#part_0#sp#part_0sp0 test table_part_sub_0#p#part_0#sp#sub_0 test table_part_sub_0#p#part_0#sp#sub_0 test table_part_sub_0#p#part_0#sp#sub_0 test table_part_sub_0#p#part_0#sp#sub_0 test table_part_sub_0#p#part_0#sp#sub_0 test table_part_sub_0#p#part_0#sp#sub_0  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_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_0#p#p0 PRIMARY n_diff_pfx00 test table_part_0#p#p0 PRIMARY n_leaf_pages test table_part_0#p#p0 PRIMARY size test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_diff_pfx00 test table_part_0#p#p0 k0 n_leaf_pages test table_part_0#p#p0 k0 size test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 PRIMARY n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 PRIMARY size test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 k0 n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 k0 size test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 PRIMARY n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 PRIMARY size test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 k0 n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 k0 size test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 PRIMARY n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 PRIMARY size test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 k0 n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 k0 size test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 PRIMARY n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 PRIMARY size test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 k0 n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 k0 size test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 PRIMARY n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 PRIMARY size test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 k0 n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 k0 size test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 PRIMARY n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 PRIMARY n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 PRIMARY size test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 k0 n_diff_pfx00 test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 k0 n_leaf_pages test table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 k0 size test table_part_cap_0#p#p0 PRIMARY n_diff_pfx00 test table_part_cap_0#p#p0 PRIMARY n_leaf_pages test table_part_cap_0#p#p0 PRIMARY size test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_leaf_pages test table_part_cap_0#p#p0 k0 size test table_part_cap_0#p#p0 PRIMARY n_diff_pfx00 test table_part_cap_0#p#p0 PRIMARY n_leaf_pages test table_part_cap_0#p#p0 PRIMARY size test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_leaf_pages test table_part_cap_0#p#p0 k0 size test table_part_cap_0#p#p0 PRIMARY n_diff_pfx00 test table_part_cap_0#p#p0 PRIMARY n_leaf_pages test table_part_cap_0#p#p0 PRIMARY size test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_leaf_pages test table_part_cap_0#p#p0 k0 size test table_part_cap_0#p#p0 PRIMARY n_diff_pfx00 test table_part_cap_0#p#p0 PRIMARY n_leaf_pages test table_part_cap_0#p#p0 PRIMARY size test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_leaf_pages test table_part_cap_0#p#p0 k0 size test table_part_cap_0#p#p0 PRIMARY n_diff_pfx00 test table_part_cap_0#p#p0 PRIMARY n_leaf_pages test table_part_cap_0#p#p0 PRIMARY size test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_diff_pfx00 test table_part_cap_0#p#p0 k0 n_leaf_pages test table_part_cap_0#p#p0 k0 size test table_part_nopart_cap_0 PRIMARY n_diff_pfx00 test table_part_nopart_cap_0 PRIMARY n_leaf_pages test table_part_nopart_cap_0 PRIMARY size test table_part_nopart_cap_0 k0 n_diff_pfx00 test table_part_nopart_cap_0 k0 n_diff_pfx00 test table_part_nopart_cap_0 k0 n_leaf_pages test table_part_nopart_cap_0 k0 size test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY size test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 k0 size test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY size test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 k0 size test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY size test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 k0 size test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY size test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 k0 size test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY size test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 k0 size test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY size test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 k0 size test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY size test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 k0 size test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 PRIMARY size test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#part_0sp0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#part_0sp0 k0 size test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY size test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 k0 size test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY size test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 k0 size test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY size test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 k0 size test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY size test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 k0 size test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY size test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 k0 size test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 PRIMARY size test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_diff_pfx00 test table_part_sub_0#p#part_0#sp#sub_0 k0 n_leaf_pages test table_part_sub_0#p#part_0#sp#sub_0 k0 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_0 p0 0 table_part_0 p0 0 table_part_0 p0 0 table_part_0 p0 0 table_part_0 p0 0 table_part_0 p0 0 table_part_0 p0 0 table_part_0 p0 0 table_part_0 p0 0 table_part_0 p0 0 table_part_\_special_/_sub_?_0 PART_/_0 0 table_part_\_special_/_sub_?_0 Part_?_0 0 table_part_\_special_/_sub_?_0 pArt_\_0 0 table_part_\_special_/_sub_?_0 sUb_/_0 0 table_part_\_special_/_sub_?_0 SUB_?/_0 0 table_part_\_special_/_sub_?_0 SUB_?\_0 0 table_part_\_special_/_sub_?_0 Sub_?_0 0 table_part_\_special_/_sub_?_0 sub_\/?_0 0 table_part_\_special_/_sub_?_0 suB_\_0 0 table_part_cap_0 p0 0 table_part_cap_0 p0 0 table_part_cap_0 p0 0 table_part_cap_0 p0 0 table_part_cap_0 p0 0 table_part_sub_0 Part_0 0 table_part_sub_0 Part_0sp0 0 table_part_sub_0 Part_0sp0 0 table_part_sub_0 pArt_0 0 table_part_sub_0 pArt_0sp0 0 table_part_sub_0 pArt_0sp0 0 table_part_sub_0 part_0 0 table_part_sub_0 part_0sp0 0 table_part_sub_0 part_0sp0 0 table_part_sub_0 PART_0 0 table_part_sub_0 PART_0sp0 0 table_part_sub_0 PART_0sp0 0 table_part_sub_0 Part_0 0 table_part_sub_0 pArt_0 0 table_part_sub_0 PART_0 0 table_part_sub_0 Sub_0 0 table_part_sub_0 sUb_0 0 table_part_sub_0 suB_0 0 table_part_sub_0 SUB_0 0 table_part_sub_0 SUB_0 0 table_part_sub_0 sub_0 0  select name from mysql.tablespaces where name like '%table_part%' order by name; name test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_0#p#p0 test/table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_?/_0 test/table_part_\_special_/_sub_?_0#p#part_/_0#sp#sub_\/?_0 test/table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_/_0 test/table_part_\_special_/_sub_?_0#p#part_?_0#sp#sub_?_0 test/table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_?\_0 test/table_part_\_special_/_sub_?_0#p#part_\_0#sp#sub_\_0 test/table_part_cap_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_cap_0#p#p0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#part_0sp0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0 test/table_part_sub_0#p#part_0#sp#sub_0  select file_name from mysql.tablespace_files where file_name like '%table_part%' order by file_name; file_name ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_0#p#p0.ibd ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f@000f_0.ibd ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000c@000f@000f_0.ibd ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f_0.ibd ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000f_0#sp#sub_@000f_0.ibd ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000c_0#sp#sub_@000f@000c_0.ibd ./test/table_part_@000c_special_@000f_sub_@000f_0#p#part_@000c_0#sp#sub_@000c_0.ibd ./test/table_part_cap_0#p#p0.ibd ./test/table_part_cap_0#p#p0.ibd ./test/table_part_cap_0#p#p0.ibd ./test/table_part_cap_0#p#p0.ibd ./test/table_part_cap_0#p#p0.ibd ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd ./test/table_part_sub_0#p#part_0#sp#part_0sp0.ibd ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd ./test/table_part_sub_0#p#part_0#sp#sub_0.ibd SET DEBUG='-d,skip_dd_table_access_check'; SET NAMES DEFAULT; # 0. Do DML insert/update/delete on upgraded tables DML on partitioned tables -------------------------  insert into table_part_0 values(00, 0000, "Row - 00", REPEAT('Large Column Data - 00' , 000));  update table_part_0 set name = 'Row - updated' where value > 000;  delete from table_part_0 where id = 0;  insert into table_part_sub_0 values(00, 0000, "Row - 00", REPEAT('Large Column Data - 00' , 000));  update table_part_sub_0 set name = 'Row - updated' where value > 000;  delete from table_part_sub_0 where id = 0;  insert into table_part_sub_0 values(00, 0000, "Row - 00", REPEAT('Large Column Data - 00' , 000));  update table_part_sub_0 set name = 'Row - updated' where value > 000;  delete from table_part_sub_0 where id = 0;  insert into `table_part_\_special_/_sub_?_0` values(00, 0000, "Row - 00", REPEAT('Large Column Data - 00' , 000));  update `table_part_\_special_/_sub_?_0` set name = 'Row - updated' where value > 000;  delete from `table_part_\_special_/_sub_?_0` where id = 0;  insert into table_part_0 values(00, 0000, "Row - 00", REPEAT('Large Column Data - 00' , 000));  update table_part_0 set name = 'Row - updated' where value > 000;  delete from table_part_0 where id = 0; # 0. Do DDL ALTER/DROP on upgraded tables DDL on partitioned tables ------------------------- ALTER TABLE table_part_0 TRUNCATE PARTITION p0;  ALTER TABLE table_part_0 COALESCE PARTITION 0;  SHOW CREATE TABLE table_part_0; Table Create Table table_part_0 CREATE TABLE `table_part_0` (   `id` int NOT NULL,   `value` int DEFAULT NULL,   `name` varchar(00) DEFAULT NULL,   `data` blob,   PRIMARY KEY (`id`),   KEY `k0` (`value`) ) ENGINE=InnoDB DEFAULT CHARSET=latin0 /*!00000 PARTITION BY HASH (`id`) PARTITIONS 0 */  ALTER TABLE table_part_sub_0 TRUNCATE PARTITION part_0;  ALTER TABLE table_part_sub_0 TRUNCATE PARTITION part_0;  CREATE TABLE test_table LIKE table_part_sub_0;  ALTER TABLE test_table REMOVE PARTITIONING; insert into test_table values(0, 000, "Row - 0", REPEAT('Large Column Data - 0' , 000));  SELECT id, value, name FROM table_part_sub_0 PARTITION (sub_0) order by id; id value name 0 000 Row - 0 0 000 Row - 0  SELECT id, value, name FROM test_table order by id; id value name 0 000 Row - 0  ALTER TABLE table_part_sub_0 EXCHANGE PARTITION sub_0 WITH TABLE test_table;  SELECT id, value, name FROM table_part_sub_0 PARTITION (sub_0) order by id; id value name 0 000 Row - 0  SELECT id, value, name FROM test_table order by id; id value name 0 000 Row - 0 0 000 Row - 0  DROP TABLE test_table;  ALTER TABLE table_part_sub_0 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(00) DEFAULT NULL,   `data` blob,   PRIMARY KEY (`id`,`value`),   KEY `k0` (`value`) ) ENGINE=InnoDB DEFAULT CHARSET=latin0 /*!00000 PARTITION BY RANGE (`value`) SUBPARTITION BY HASH (`id`) (PARTITION Part_0 VALUES LESS THAN (000)  (SUBPARTITION Sub_0 ENGINE = InnoDB,   SUBPARTITION sUb_0 ENGINE = InnoDB),  PARTITION pArt_0 VALUES LESS THAN (000)  (SUBPARTITION suB_0 ENGINE = InnoDB,   SUBPARTITION SUB_0 ENGINE = InnoDB),  PARTITION PART_0 VALUES LESS THAN MAXVALUE  (SUBPARTITION SUB_0 ENGINE = InnoDB,   SUBPARTITION sub_0 ENGINE = InnoDB)) */  ALTER TABLE renamed_table RENAME table_part_sub_0;;  ALTER TABLE table_part_0 ENGINE = InnoDB;;  ALTER TABLE table_part_0 ADD COLUMN new_id int AFTER id;  ALTER TABLE table_part_0 REMOVE PARTITIONING;  ALTER TABLE table_part_sub_0 ENGINE = InnoDB;;  ALTER TABLE table_part_sub_0 ADD COLUMN new_id int AFTER id;  ALTER TABLE table_part_sub_0 REMOVE PARTITIONING;  ALTER TABLE table_part_sub_0 ENGINE = InnoDB;;  ALTER TABLE table_part_sub_0 ADD COLUMN new_id int AFTER id;  ALTER TABLE table_part_sub_0 REMOVE PARTITIONING;  ALTER TABLE `table_part_\_special_/_sub_?_0` ENGINE = InnoDB;;  ALTER TABLE `table_part_\_special_/_sub_?_0` ADD COLUMN new_id int AFTER id;  ALTER TABLE `table_part_\_special_/_sub_?_0` REMOVE PARTITIONING;  ALTER TABLE table_part_0 ENGINE = InnoDB;;  ALTER TABLE table_part_0 ADD COLUMN new_id int AFTER id;  ALTER TABLE table_part_0 REMOVE PARTITIONING;  # 