search

i-van / mysql-emulator

MySQL Emulator
MIT License
11 stars 1 forks source link

Table name normalization required #1

Closed sokcuri closed 1 year ago

sokcuri commented 1 year ago

It seems that the behavior is different depending on the syntax of SQL.

`INFORMATION_SCHEMA`.`SCHEMATA`
`INFORMATION_SCHEMA.SCHEMATA`

This table are the same table, but mysql-emulator treats them differently

i-van commented 1 year ago

First issue 🎉!

MySQL thinks that `INFORMATION_SCHEMA.SCHEMATA` is table name and will return error like

Query 1 ERROR: Table 'mysql_emulator.INFORMATION_SCHEMA.SCHEMATA' doesn't exist

as mysql-emulator does when you select something from that table.

Could you add a query that failed to comments?

sokcuri commented 1 year ago

I was mistaken. If it consists of backtick, it seems to be regarded as one table name. It's working great!