As in the question title - is it possible for a MySQL database to have duplicate tables with the same name? Is there a directove that can be used for a database to allow this?

Normally, when trying to add duplicate tables, MySQL should return an error #1050 - Table 'tablename' already exists, but recently, while working on a project, I noticed that almost every table in the database is duplicated (only the structure, new tables are empty). While I know that some table-creating scripts could be executed, MySQL shouldn't allow this, right?

How to even deal with such an issue?