MySQL Bugs: #80056: Auto-complete / code completion functionality not working

Bug #80056	Auto-complete / code completion functionality not working
Submitted:	19 Jan 2016 20:05	Modified:	22 Jan 2016 15:33
Reporter:	Bill Schmitz	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	6.3.6	OS:	Windows (Microsoft Windows 10 Home)
Assigned to:		CPU Architecture:	Any
Tags:	auto complete, code completion, WBBugReporter

Description:
Some time in the past several months, the "Code Completion" or "Auto-complete" functionality stopped working for me on Workbench. I am not completely sure when or what version update it stopped working on because I just dealt with it when it stopped.  So, it was functioning at some point, but is not now.  This is also true for a couple of my co-workers, one is also on Windows 10 running latest version of workbench and the other is on Mac OS X.  All 3 of us cannot get the Code Completion to work.

In the "Workbench Preferences" under Query Editor, I have made sure "Enable Code Completion in Editors" and "Automatically Start Code Completion" are both checked.  I have tried things like unchecking them, restarting Workbench, checking them again and restarting again.  None of this has resolved the issues.  

None of the Code Completion functionality is working for me, including syntax, database, table, and field names.

How to repeat:
Install latest version of Workbench, and start typing in Query Editors.
The Code Completion list never pops up for syntax or object names.

This is true on 3 different workstations.  2 of them using Windows 10 and 1 using Mac OS X with latest versions of Workbench.

auto_complete

Attachment: auto_complete_win.png (image/png, text), 141.39 KiB.

Thank you for the bug report. I couldn't repeat on Windows 10 Pro.

The further I thought about this.  I believe the reason maybe that our database is now MariaDB (Server version: 10.0.21-MariaDB-log MariaDB Server).

However, most other functions within in MySQL Workbench work fine.  I am not sure why the Auto Complete would not work, other than maybe Workbench automatically turns off Auto Complete when working with a non-standard server version?