Bug Report: Mysqld.normalizedSchema() erroneously replaces table name with placeholder if same as DB name

[shlomi-noach]

Overview of the Issue

Assume this simplified CREATE VIEW statement:

create view `mydb`.v as select * from `mydb`.`mydb`

In the above, the view is in mydb schema. However, it also reads from a table called mydb. The function normalizedSchema() turns this view statement into:

create view {{.DatabaseName}}.v as select * from {{.DatabaseName}}.{{.DatabaseName}}

Reproduction Steps

Binary Version

18, 17, 16?

Operating System and Environment details

-

Log Fragments

No response