MySQL Bugs: #71771: Syntax auto-completion popup persistance

Bug #71771	Syntax auto-completion popup persistance
Submitted:	19 Feb 2014 17:24	Modified:	13 Mar 2014 2:14
Reporter:	Nigel Markey	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.0.8.11354 build 833	OS:	MacOS (Mavericks)
Assigned to:		CPU Architecture:	Any
Tags:	Auto Suggest, UI, user interface

Description:
The auto-suggest/completion popover in the Query window persists on screen, either whilst using MySQL Workbench or whilst using other applications. The only resolution is quitting and restarting MySQL Workbench. 

The issue appears on a semi-random basis, but is worse on slow/inconsistent connections.

How to repeat:
1) Open a new query tab
2) Start typing a query
3) A popup/popover menu appears, it suggests SQL or table names that complete the word that the user is currently typing
4) Open or navigate to another application and place it in front of MySQL Workbench
5) The popup menu will persist on screen, appearing in front of the application that is now in front of MySQL Workbench.
6) After the above steps, either of the following happens on (though I cannot consistently trigger one of the other behaviour:
--7A) Returning to MySQL Workbench results in the popup menu clearing from the screen
--7B) Returning to MySQL Workbench doesn't resolve the issue and the popup menu persists on screen until quitting and restarting MySQL Workbench

Suggested fix:
My observation is that:
1) There can be lag between typing on screen and the popup appearing
2) It looks like the application is refreshing the list of suggestions from the server every time it runs
3) The issue may be caused by:
3a) The UI not running on a separate thread whilst communication is happening back to the server
3b) The thread the UI runs on not being told that the application is no longer in focus
3c) The delay in retrieving the auto-suggest list from the server may cause the UI thread to continue running even after the application is no longer in focus the thread that the UI runs on  

Possible suggestions:
1) The way the auto-complete appears in the GUI should:
1a) React to changes in application focus
1b) Not persist on loss of focus
2) The auto complete functionality could be cached into memory on the client and receive push updates from the server when new fields/tables are added. The popup would read from this cached list and avoid potential errors with the connectivity/updates from the server (separation of concerns).

Thank you for the bug report.

Select popup

Attachment: POPUP.png (image/png, text), 51.60 KiB.

Posted by developer:
 
Fixed on 6.1.3.11725

Posted by developer:
 
This was fixed in Workbench 6.1.2 via Oracle Bug #17799326 / MySQL Bug #70912 and the changelog reads as:

        On Mac OS X, the auto completion popup window remained open
        after reopening MySQL Workbench.

Thank you for the bug report, it was also added to that entry.