Bug #92989 SQL editor Action Output tooltip freezes workbench temporarily
Submitted: 29 Oct 2018 14:32 Modified: 29 Oct 2018 15:18
Reporter: Jason Brunette Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.13 OS:Any
Assigned to: CPU Architecture:Any

[29 Oct 2018 14:32] Jason Brunette
Description:
The tooltip that appears when hovering over the entry for a very "wide" (lots of text on one line) query in the Output > Action Output pane will freeze the Workbench window for a number of seconds.  A large, blank tooltip window will appear for a few seconds and then disappear, at which point the Workbench is responsive again.

How to repeat:
Run a very "wide" query... for example, something with 10k characters on one line:

SELECT * FROM information.schema.TABLES WHERE
1=1 AND 1=1 ... (x1000)

Once executed, hover mouse over entry for it in the Output > Action Output pane.  Observe that Workbench is no longer responsive while Workbench attempts to display the tooltip.

Suggested fix:
Limit size of tooltip to x number of characters.
[29 Oct 2018 14:33] Jason Brunette
Fix synopsis
[29 Oct 2018 15:04] MySQL Verification Team
Hello Jason,

Thank you for the report.
Observed this on Win7 with WB 8.0.13.

regards,
Umesh
[29 Oct 2018 15:18] Jason Brunette
What amplifies the impact of this is that Workbench immediately begins creating a tooltip simply based on mouseover, rather than employing a hover delay.  The following real world scenario gets me every time:

1. Run wide query(s).
2. Minimize Workbench window.
3. <do something else>
4. Click Workbench's icon in task bar.
5. Drag mouse up to click something in Workbench, mousing over entries for the long queries in the Action Output in the process.
6. Weep softly.