global temporary table missed in information_schema.tables

[apollodafoni]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create global temporary table global_temp(id int) on commit delete rows;
select count(*) from information_schema.tables where table_name='global_temp';

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

count(*)
1

3. What did you see instead (Required)

count(*)
0

4. What is your TiDB version? (Required)

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

[apollodafoni]

/component ddl

[apollodafoni]

/severity major

[apollodafoni]

/impact wrong-result
/assign @tangenta