Bug #72812 Auto-complete works only on SELECT statements
Submitted: 30 May 2014 7:53 Modified: 21 Mar 2018 16:41
Reporter: Lorenzo Sequi Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.1.6.11834 OS:Windows
Assigned to: CPU Architecture:Any
Tags: auto-complete, auto-completion, complete

[30 May 2014 7:53] Lorenzo Sequi
Description:
Auto-complete works only on SELECT statements.
Auto-complete doesn't work on UPDATE (and other), sub-query or in SELECT statements e.g:

  INSERT INTO db_schema_1.table1 (field1, field2)
  SELECT field1, field2 FROM db_schema_2.table1 

How to repeat:
Try to write in your schema for example:

SELECT field1, field2 FROM db_schema_2.table1

And  you'll see the fields are suggested, if you write complex query (sub-query) or UPDATE queries the fields are not auto-completed as in the select part of this query:

 INSERT INTO db_schema_1.table1 (field1, field2)
  SELECT field1, field2 FROM db_schema_2.table1
[30 May 2014 9:35] MySQL Verification Team
Hello Lorenzo,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[21 Mar 2018 16:41] Christine Cole
Fixed as of the upcoming MySQL Workbench 8.0.11 release, and here's the changelog entry:

Code completion did not provide a suggestion reliably for instructions
included in the server dictionary, such as statements or system variables.

Thank you for the bug report.