Bug #100165 The table is visible in performance_schema after renaming it
Submitted: 9 Jul 2020 2:41 Modified: 9 Jul 2020 6:30
Reporter: zhijun long Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.7.29, 5.7.30, 8.0.20 OS:Any
Assigned to: CPU Architecture:Any

[9 Jul 2020 2:41] zhijun long
Description:
Hi, all

The table whose table_name starts with character # is still visible in performance_schema.objects_summary_global_by_type after renaming it.

```
USE test;
CREATE TABLE `#sql_1` (a int, b text);
CREATE TABLE `sql_1` (a int, b text);
SELECT object_type, object_schema, object_name
FROM performance_schema.objects_summary_global_by_type
WHERE object_schema="test"
ORDER BY object_name;
object_type     object_schema   object_name
TABLE   test    #sql_1
TABLE   test    sql_1
RENAME TABLE `#sql_1` TO t1;
RENAME TABLE `sql_1` TO t2;
SELECT object_type, object_schema, object_name
FROM performance_schema.objects_summary_global_by_type
WHERE object_schema="test"
ORDER BY object_name;
object_type     object_schema   object_name
TABLE   test    #sql_1
DROP TABLE t1,t2;
```

How to repeat:
mtr case

rename_table.test
```
--source include/have_perfschema.inc
--source include/not_embedded.inc

USE test;
CREATE TABLE `#sql_1` (a int, b text);
CREATE TABLE `sql_1` (a int, b text);

SELECT object_type, object_schema, object_name
FROM performance_schema.objects_summary_global_by_type
WHERE object_schema="test"
ORDER BY object_name;

RENAME TABLE `#sql_1` TO t1;
RENAME TABLE `sql_1` TO t2;

SELECT object_type, object_schema, object_name
FROM performance_schema.objects_summary_global_by_type
WHERE object_schema="test"
ORDER BY object_name;

DROP TABLE t1,t2;
```
[9 Jul 2020 6:30] MySQL Verification Team
Hello zhijun long,

Thank you for the report and test case.

regards,
Umesh