Duplicate information_schema

[waynexia]

What type of bug is this?

Unexpected error

What subsystems are affected?

Standalone mode, Frontend, Datanode

Minimal reproduce step

MySQL [(none)]> show schemas;
+--------------------+
| Schemas            |
+--------------------+
| information_schema |
| public             |
+--------------------+
2 rows in set (0.002 sec)

MySQL [(none)]> create schema information_schema;
Query OK, 1 row affected (0.000 sec)

MySQL [(none)]> show schemas;
+--------------------+
| Schemas            |
+--------------------+
| information_schema |
| information_schema |
| public             |
+--------------------+
3 rows in set (0.000 sec)

@Taylor-lagrange found this in #2928 (comment)

What did you expect to see?

Cannot create a schema named information_schema since there is one

What did you see instead?

two duplicate information_schemas

What operating system did you use?

Doesn't matter

Relevant log output and stack trace

No response