Bug #76954 Auto-completion shows everything instead of context-relevant suggestions

• Submitted: 6 May 2015 14:25
• Modified: 8 Dec 2015 1:25
• Reporter: Mauro Molinari
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 6.3.3.0
• OS: Any
• CPU Architecture: Any
• Tags: auto-complete, auto-completion, code completion, complete, completion

[6 May 2015 14:25] Mauro Molinari

Description:
Although the release notes say that in 6.3.x the code completion was improved, after upgrading from 6.2.4 to 6.3.3 I notice that whenever I try to invoke it, a lot of not-relevant (and hence wrong) suggestions are given now.

For instance:
SELECT p.|
FROM Person p
JOIN Address a ON a.personId = p.id

if I invoke code assist at |, all Address columns are also shown.
Previously, only Person columns where shown.
Also, before the column names suggestions, there are the schema names and table names ones, which shouldn't be applicable to the location I invoked code assist from.

IMHO this is a huge usability regression. 

How to repeat:
Create two tables with a relation and try to do a SELECT query joining them.

[7 May 2015 8:29] MySQL Verification Team

Hello Mauro Molinari,

Thank you for the report.

Thanks,
Umesh

[2 Nov 2015 9:26] Mauro Molinari

Is there any plan to fix this? This severely affects usability, code completion is almost useless right now... It worked much better before...

[2 Nov 2015 11:32] Mike Lischke

A fix will be available with the next release.

[8 Dec 2015 1:25] Philip Olson

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

SQL auto-completion would sometimes show unavailable columns.

Thank you for the bug report.