Issue with Displaying the Number of Filtered Table Data

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 表数据过滤数量显示问题

| username: juecong

[TiDB Usage Environment] Production Environment

[TiDB Version] 7.1.1

[Encountered Issues: Problem Phenomenon and Impact]
The table structure is as follows: (some unrelated fields are omitted in the middle)

The query statement is as follows: (resulting in 4 records)

If I query by primary key id: (one record is missing)

The above is issue 1.
Issue 2:


id and database_table are composite primary keys, and 2 records are found in a single table.

| username: juecong | Original post link

Table health is 100

| username: juecong | Original post link

It should be an issue with _tidb_rowid.

| username: zhanggame1 | Original post link

_tidb_rowid does not exist by default

| username: caiyfc | Original post link

Check the table to see if the number of indexes and tables are consistent: ADMIN CHECK TABLE tbl_name
ADMIN CHECK [TABLE|INDEX] | PingCAP Documentation Center