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.
Lost Table Capitalization
Re: Lost Table Capitalization
We will review this and will answer you as soon as possible.
Re: Lost Table Capitalization
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.
Re: Lost Table Capitalization
Thank you for updating us on this issue. Please let us know if any questions arise.
Re: Lost Table Capitalization
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.