Bug #92410 Regression in code-completion: column names not proposed
Submitted: 13 Sep 2018 14:51 Modified: 13 Sep 2018 18:36
Reporter: Mauro Molinari Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.12 OS:Windows
Assigned to: CPU Architecture:Any

[13 Sep 2018 14:51] Mauro Molinari 
Description:
MySQL Workbench 8.0.11 release notes talk about a "new code-completion engine".
Unfortunately, this broke at least the following case.

How to repeat:
Open an editor and type
SELECT * FROM myschema.MYTABLE WHERE |

Invoke code assist at "|": MYTABLE column names are not proposed

If "mycolumn" is a column of MYTABLE, if you try:

SELECT * FROM myschema.MYTABLE WHERE myc| 

and invoke code assist, no suggestion is given (apart from any other table whose name starts with 'myc').

This was working correctly in 6.3.10 and it's quite annoying.
[13 Sep 2018 18:36] MySQL Verification Team 
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=92015.