Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Tables with dots in the name break import #6

Closed
tresf opened this issue Jul 17, 2018 · 0 comments · Fixed by #7
Closed

Tables with dots in the name break import #6

tresf opened this issue Jul 17, 2018 · 0 comments · Fixed by #7

Comments

@tresf
Copy link
Owner

tresf commented Jul 17, 2018

It's common for SQL Server to use dot-notation for naming tables, but this is not common for MySQL and require special escaping which is largely frowned upon.

For example:

A table named Sales.Customers in Microsoft SQL would translated to Database: Sales, Table: Customers and break on INSERT unless wrapped with backticks. e.g. `Sales.Customers` explained further here: https://stackoverflow.com/a/776141/3196753

By default, we should replace dots . in table names with underscores _.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant