MySQL Bugs: #78185: mySQL workbench not autocompleting column names for alias tables

Bug #78185	mySQL workbench not autocompleting column names for alias tables
Submitted:	24 Aug 2015 10:57	Modified:	20 Jan 2017 20:09
Reporter:	James Brodrick	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	6.3.4	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	alais, auto-complete, autocomplete, osx

Description:
Workbench does not show show column names / auto-complete when using and alias for a table name. This feature works fine with version 6.2.5 (OSX), which I have reinstalled. This i very frustrating as I am dyslexic and working with a very large complex database. 

I have tried removing worknbench, including the user stored data folder MySQL/Workbench/ 

In addition 6.3.4 keeps dropping its connection. 6.2.5 remains open, shoring the same MySQL/Workbench/ settings

How to repeat:
Open a remote SQL connect and try and sql query i.e. select * from table1 as tb1 where tb1. = x

Thank you for the bug report.

Bummed this wasn't fixed in 6.3.5. Is there any plan to address this?

And not in 6.3.6.....

And not in 6.3.6.....

Actually it doesn't work even without aliasing the table.
Writing something like
SELECT * FROM my_db.user
WHERE ...
the autocomplete doesn't suggest any column name.
Someone can confirm this? I've got MySQL Workbench 6.3.6 on Windows 8.1 64bit.
This worked just fine on wb 6.2...

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.9 release, and here's the changelog entry:

The autocomplete feature did not offer suggestions as expected. The
CTRL+SPACEBAR keyboard shortcut can be used to activate this feature.

Thank you for the bug report.

NOT FIXED, I REPEAT - NOT FIXED. Version 6.1.9 DOES NOT SUGGEST TABLE AND COLUMN NAMES

EDIT:
THAT IS VERSION 6.3.9, not 6.1.9