SELECT `infoschema`.`tables` data is inconsistent, schema and table name do not match.

[River2000i]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop database if exists test1;
create database test1;
use test1;
create table t10(id int);
create table t11 like t10;
create table t12 like t10;
create table t13 like t10;
create table t14 like t10;
create table t15 like t10;
create table t16 like t10;
create table t17 like t10;
create table t18 like t10;
create table t19 like t10;

drop database if exists test2;
create database test2;
use test2;
create table t20(id int);
create table t21 like t20;
create table t22 like t20;
create table t23 like t20;
create table t24 like t20;
create table t25 like t20;
create table t26 like t20;
create table t27 like t20;
create table t28 like t20;
create table t29 like t20;

SELECT table_schema, table_name,data_length
FROM information_schema.TABLES
WHERE (TABLE_NAME IN ('t10','t11','t12','t13','t14','t15','t16','t17','t18','t19','t20','t21','t22','t23','t24','t25','t26','t27','t28','t29'));

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

mysql> SELECT table_schema, table_name,data_length FROM information_schema.TABLES WHERE (TABLE_NAME IN ('t10','t11','t12','t13','t14','t15','t16','t17','t18','t19','t20','t21','t22','t23','t24','t25','t26','t27','t28','t29')) order by table_name;
+--------------+------------+-------------+
| table_schema | table_name | data_length |
+--------------+------------+-------------+
| test1        | t10        |           0 |
| test1        | t11        |           0 |
| test1        | t12        |           0 |
| test1        | t13        |           0 |
| test1        | t14        |           0 |
| test1        | t15        |           0 |
| test1        | t16        |           0 |
| test1        | t17        |           0 |
| test1        | t18        |           0 |
| test1        | t19        |           0 |
| test2        | t20        |           0 |
| test2        | t21        |           0 |
| test2        | t22        |           0 |
| test2        | t23        |           0 |
| test2        | t24        |           0 |
| test2        | t25        |           0 |
| test2        | t26        |           0 |
| test2        | t27        |           0 |
| test2        | t28        |           0 |
| test2        | t29        |           0 |
+--------------+------------+-------------+
20 rows in set (0.01 sec)

3. What did you see instead (Required)

mysql> SELECT table_schema, table_name,data_length FROM information_schema.TABLES WHERE (TABLE_NAME IN ('t10','t11','t12','t13','t14','t15','t16','t17','t18','t19','t20','t21','t22','t23','t24','t25','t26','t27','t28','t29'));
+--------------+------------+-------------+
| table_schema | table_name | data_length |
+--------------+------------+-------------+
| test1        | t10        |           0 |
| test1        | t11        |           0 |
| test1        | t14        |           0 |
| test1        | t15        |           0 |
| test1        | t17        |           0 |
| test1        | t20        |           0 |
| test1        | t22        |           0 |
| test1        | t23        |           0 |
| test1        | t24        |           0 |
| test1        | t26        |           0 |
| test2        | t25        |           0 |
| test2        | t12        |           0 |
| test2        | t13        |           0 |
| test2        | t16        |           0 |
| test2        | t18        |           0 |
| test2        | t19        |           0 |
| test2        | t21        |           0 |
| test2        | t27        |           0 |
| test2        | t28        |           0 |
| test2        | t29        |           0 |
+--------------+------------+-------------+
20 rows in set (0.00 sec)

4. What is your TiDB version? (Required)

v8.5.0, master