Lost Table Capitalization

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
tcarr
Posts: 3
Joined: Tue 10 Apr 2018 16:53

Lost Table Capitalization

Post by tcarr » Thu 19 Jul 2018 18:11

Hello,

With the latest version (8.0.40 as of writing) table names have lost their capitalization causing auto-completion to create aliases based on the first letter of a table instead of the capitalized letters. Is there a fix for this?

Here's a couple example tables:
'join tblProject P' is now 'join tblproject T'
'join tblProjectAttachments PA' is now 'join tblprojectattachments T'
In the case of inner join using the tables above, tblprojectattachment's alias becomes T1 instead of PA, which defeats the purpose of aliases.

alexa

Re: Lost Table Capitalization

Post by alexa » Thu 19 Jul 2018 18:50

We will review this and will answer you as soon as possible.

tcarr
Posts: 3
Joined: Tue 10 Apr 2018 16:53

Re: Lost Table Capitalization

Post by tcarr » Fri 20 Jul 2018 17:40

Thanks for the quick response. Somewhere between switching databases and restarting dbForge it fixed itself, so I haven't been able to reproduce it yet.

alexa

Re: Lost Table Capitalization

Post by alexa » Mon 23 Jul 2018 09:19

Thank you for updating us on this issue. Please let us know if any questions arise.

tcarr
Posts: 3
Joined: Tue 10 Apr 2018 16:53

Re: Lost Table Capitalization

Post by tcarr » Mon 23 Jul 2018 19:36

I solved the issue. I have two MySQL Servers, one that runs on Windows, and one that runs on an Ubuntu VM. Shutting one down prevents the loss of capitalization. I don't need both running at the same time since they're identical and will eventually get rid of the VM completely.

alexa

Re: Lost Table Capitalization

Post by alexa » Tue 24 Jul 2018 10:44

Thank you for the information.

Post Reply