temporary table appears in the information_schema.tables

[apollodafoni]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create temporary table tb1(id int);
select count(1) from information_schema.tables where table_name = 'tb1';

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

+----------+
| count(1) |
+----------+
| 0 |
+----------+

3. What did you see instead (Required)

+----------+
| count(1) |
+----------+
| 1 |
+----------+

4. What is your TiDB version? (Required)

Release Version: v8.3.0-alpha
Edition: Community
Git Commit Hash: b0aced8
Git Branch: heads/refs/tags/v8.3.0-alpha
UTC Build Time: 2024-08-01 11:46:05
GoVersion: go1.21.10
Race Enabled: false
Check Table Before Drop: false
Store: tikv

[apollodafoni]

/component ddl

[apollodafoni]

/severity major

[apollodafoni]

/impact wrong-result