Skip to content

The sub_part in information_schema.statistics table incorrect #55812

@Defined2014

Description

@Defined2014

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t (c text);
alter table t add index idx_t (c(16));
select SUB_PART from information_schema.statistics where TABLE_SCHEMA = 'test' and TABLE_NAME = 't';

2. What did you expect to see? (Required)

mysql> select SUB_PART from information_schema.statistics where TABLE_SCHEMA = 'test' and TABLE_NAME = 't';
+----------+
| SUB_PART |
+----------+
|       16 |
+----------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

mysql> select SUB_PART from information_schema.statistics where TABLE_SCHEMA = 'test' and TABLE_NAME = 't';
+----------+
| SUB_PART |
+----------+
|     NULL |
+----------+
1 row in set (0.00 sec)

4. What is your TiDB version? (Required)

Metadata

Metadata

Assignees

Labels

affects-5.4This bug affects the 5.4.x(LTS) versions.affects-6.1This bug affects the 6.1.x(LTS) versions.affects-6.5This bug affects the 6.5.x(LTS) versions.affects-7.1This bug affects the 7.1.x(LTS) versions.affects-7.5This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.component/infoschemareport/customerCustomers have encountered this bug.severity/moderatesig/sql-infraSIG: SQL Infratype/bugThe issue is confirmed as a bug.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions