Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

MySsql lower case table name in view #3488

Open
richardpbull opened this issue Jun 19, 2019 · 4 comments

Comments

Projects
None yet
2 participants
@richardpbull
Copy link

commented Jun 19, 2019

Note that the case of tables referred to in a view may not match the case of the actual table names. tblhotel vs tblHotel..

This means the view cannot be copied to another server for instance, but cutting and pasting the view's create syntax.

https://www.dropbox.com/s/boeecwynqce6i04/Screenshot%202019-06-19%2011.07.42.png?dl=0

https://www.dropbox.com/s/bikcoeugv2c7wfk/Screenshot%202019-06-19%2011.10.51.png?dl=0

@italktocomputers

This comment has been minimized.

Copy link

commented Jul 9, 2019

Strange. When building off of master or using the current binary version, I do not see this issue.
Screen Shot 2019-07-08 at 8 21 19 PM

@richardpbull

This comment has been minimized.

Copy link
Author

commented Jul 9, 2019

@italktocomputers

This comment has been minimized.

Copy link

commented Jul 10, 2019

Sorry, I was unable to see your screenshots. I'm guessing because you replied via email?

@richardpbull

This comment has been minimized.

Copy link
Author

commented Jul 10, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.