information_schema.tables return wrong result

[tangenta]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create database test1;
create database test2;
create table test1.t (a int);
create table test2.t (a int);

select table_schema, table_name, tidb_table_id from information_schema.tables where tidb_table_id = 108;

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

There should be one row.

3. What did you see instead (Required)

Two rows with same table ID but different schema names.

4. What is your TiDB version? (Required)

1985662

[tangenta]

Introduced by #55144