STATISTICS shows the indexes that are not PUBLIC #60430
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
mysql> SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE `TABLE_NAME` = 'part' and index_name = 'idx_mfgr';
+---------------+--------------+------------+------------+--------------+------------+--------------+-------------+-----------+-------------+----------+--------+----------+------------+---------+---------------+------------+------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | INDEX_SCHEMA | INDEX_NAME | SEQ_IN_INDEX | COLUMN_NAME | COLLATION | CARDINALITY | SUB_PART | PACKED | NULLABLE | INDEX_TYPE | COMMENT | INDEX_COMMENT | IS_VISIBLE | Expression |
+---------------+--------------+------------+------------+--------------+------------+--------------+-------------+-----------+-------------+----------+--------+----------+------------+---------+---------------+------------+------------+
| def | test | part | 1 | test | idx_mfgr | 1 | P_MFGR | A | 0 | NULL | NULL | | BTREE | | | YES | NULL |
+---------------+--------------+------------+------------+--------------+------------+--------------+-------------+-----------+-------------+----------+--------+----------+------------+---------+---------------+------------+------------+
1 row in set (0.00 sec)
mysql>
mysql> admin show ddl jobs;
+--------+---------+------------+---------------------------+----------------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | CREATE_TIME | START_TIME | END_TIME | STATE |
+--------+---------+------------+---------------------------+----------------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
| 140 | test | part | add index /* txn-merge */ | write reorganization | 2 | 84 | 1323005 | 2025-04-08 05:31:13 | 2025-04-08 05:31:13 | NULL | running |
| 139 | test | part | drop index | none | 2 | 84 | 0 | 2025-04-08 05:23:10 | 2025-04-08 05:23:10 | 2025-04-08 05:23:10 | synced |
| 138 | test | part | add index /* txn-merge */ | public | 2 | 84 | 1600000 | 2025-04-05 15:17:09 | 2025-04-05 15:17:09 | 2025-04-05 15:17:50 | synced |
| 137 | test | part | drop index | none | 2 | 84 | 0 | 2025-04-05 15:16:30 | 2025-04-05 15:16:30 | 2025-04-05 15:16:31 | synced |
| 136 | test | part | add index /* txn-merge */ | public | 2 | 84 | 1600000 | 2025-04-05 15:12:35 | 2025-04-05 15:12:35 | 2025-04-05 15:13:16 | synced |
| 135 | test | part | drop index | none | 2 | 84 | 0 | 2025-04-05 15:11:36 | 2025-04-05 15:11:36 | 2025-04-05 15:11:36 | synced |
| 134 | test | part | add index | none | 2 | 84 | 0 | 2025-04-05 05:34:29 | 2025-04-05 05:35:09 | 2025-04-05 05:35:09 | cancelled |
| 133 | test | part | add index /* txn-merge */ | public | 2 | 84 | 1600000 | 2025-04-05 05:34:29 | 2025-04-05 05:34:29 | 2025-04-05 05:35:09 | synced |
| 132 | test | part | drop index | public | 2 | 84 | 0 | 2025-04-05 05:34:29 | 2025-04-05 05:34:29 | 2025-04-05 05:34:29 | cancelled |
| 131 | test | part | drop index | none | 2 | 84 | 0 | 2025-04-05 05:34:29 | 2025-04-05 05:34:29 | 2025-04-05 05:34:29 | synced |
| 130 | test | t | drop table | none | 2 | 128 | 0 | 2025-04-05 05:30:30 | 2025-04-05 05:30:30 | 2025-04-05 05:30:30 | synced |
+--------+---------+------------+---------------------------+----------------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
11 rows in set (0.01 sec)
mysql>
mysql> select version();
+---------------------+
| version() |
+---------------------+
| 5.7.25-TiDB-v6.5.11 |
+---------------------+
1 row in set (0.00 sec)
2. What did you expect to see? (Required)
STATISTICS doesn't show the indexes that are not PUBLIC
3. What did you see instead (Required)
STATISTICS shows the indexes that are not PUBLIC
4. What is your TiDB version? (Required)
v6, v7