| Bug #82816 | MySql WorkBench Visual Explain don't show Deail Pop Up Hint When Mouse over | ||
|---|---|---|---|
| Submitted: | 31 Aug 2016 11:26 | Modified: | 21 Jan 2017 0:33 |
| Reporter: | Gong Winjeg | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
| Version: | 6.3.7 | OS: | Linux (Arch Linux) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[31 Aug 2016 16:34]
Gong Winjeg
Both On Windows 7 And On Linux. The visual explain hint has bug.
[1 Sep 2016 7:13]
MySQL Verification Team
Hello Gong Winjeg, Thank you for the report. Verified as described with Wb 6.3.7 on Win7. Thanks, Umesh
[1 Sep 2016 7:15]
MySQL Verification Team
-- Import sakila schema, data and try visual explain for below query SELECT CONCAT(customer.last_name, ', ', customer.first_name) AS customer, address.phone, film.title FROM rental INNER JOIN customer ON rental.customer_id = customer.customer_id INNER JOIN address ON customer.address_id = address.address_id INNER JOIN inventory ON rental.inventory_id = inventory.inventory_id INNER JOIN film ON inventory.film_id = film.film_id WHERE rental.return_date IS NULL AND rental_date + INTERVAL film.rental_duration DAY < CURRENT_DATE() LIMIT 5; -- most of the time it hangs, grey out and error log is flooded with 12:40:00 [DB1][ grt]: Traceback (most recent call last): 12:40:00 [DB1][ grt]: File "D:\Workbench\MySQL Workbench 6.3.7 CE (winx64)\modules\wb_query_analysis_grt.py", line 108, in mouse_move 12:40:00 [DB1][ grt]: self.econtext._canvas.mouse_move(x, y) 12:40:00 [DB1][ grt]: File "D:\Workbench\MySQL Workbench 6.3.7 CE (winx64)\workbench\graphics\canvas.py", line 145, in mouse_move 12:40:00 [DB1][ grt]: fig.hover_in(x, y) 12:40:00 [DB1][ grt]: File "D:\Workbench\MySQL Workbench 6.3.7 CE (winx64)\workbench\graphics\canvas.py", line 203, in hover_in 12:40:00 [DB1][ grt]: self.on_hover_in(self, x, y) 12:40:00 [DB1][ grt]: File "D:\Workbench\MySQL Workbench 6.3.7 CE (winx64)\modules\explain_renderer.py", line 376, in handle_hover_in 12:40:00 [DB1][ grt]: self._context.tooltip.show_and_track(self._context._view, xx, yy, mforms.Right) 12:40:00 [DB1][ grt]: AttributeError: 'module' object has no attribute 'Right' 12:40:00 [DB2][ mforms managed]: Returning main form 12:40:00 [DB1][ grt]: Traceback (most recent call last): 12:40:00 [DB1][ grt]: File "D:\Workbench\MySQL Workbench 6.3.7 CE (winx64)\modules\wb_query_analysis_grt.py", line 108, in mouse_move 12:40:00 [DB1][ grt]: self.econtext._canvas.mouse_move(x, y) 12:40:00 [DB1][ grt]: File "D:\Workbench\MySQL Workbench 6.3.7 CE (winx64)\workbench\graphics\canvas.py", line 145, in mouse_move 12:40:00 [DB1][ grt]: fig.hover_in(x, y) 12:40:00 [DB1][ grt]: File "D:\Workbench\MySQL Workbench 6.3.7 CE (winx64)\workbench\graphics\canvas.py", line 203, in hover_in 12:40:00 [DB1][ grt]: self.on_hover_in(self, x, y) 12:40:00 [DB1][ grt]: File "D:\Workbench\MySQL Workbench 6.3.7 CE (winx64)\modules\explain_renderer.py", line 376, in handle_hover_in 12:40:00 [DB1][ grt]: self._context.tooltip.show_and_track(self._context._view, xx, yy, mforms.Right) 12:40:00 [DB1][ grt]: AttributeError: 'module' object has no attribute 'Right'
[14 Oct 2016 10:23]
Chris Herridge
The fix for this is an edit in the \\MySQL Workbench 6.3 CE\modules\explain_renderer.py file change line 376 self._context.tooltip.show_and_track(self._context._view, xx, yy, mforms.Right) to self._context.tooltip.show_and_track(self._context._view, xx, yy, mforms.StartRight) C
[21 Jan 2017 0:33]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Workbench 6.3.9 release, and here's the changelog entry: Tooltips failed to operate properly in the Visual Explain panel. Thank you for the bug report.
[27 Jul 2017 9:25]
Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=87219 marked as duplicate of this one.
[28 Jul 2017 7:08]
Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=87233 marked as duplicate of this one.
Description: Python Script Error File "/usr/lib/mysql-workbench/modules/explain_renderer.py", line 376, in handle_hover_in self._context.tooltip.show_and_track(self._context._view, xx, yy, mforms.Right) AttributeError: 'module' object has no attribute 'Right' Traceback (most recent call last): File "/usr/lib/mysql-workbench/modules/wb_query_analysis_grt.py", line 108, in mouse_move self.econtext._canvas.mouse_move(x, y) File "/usr/share/mysql-workbench/libraries/workbench/graphics/canvas.py", line 145, in mouse_move fig.hover_in(x, y) File "/usr/share/mysql-workbench/libraries/workbench/graphics/canvas.py", line 203, in hover_in self.on_hover_in(self, x, y) File "/usr/lib/mysql-workbench/modules/explain_renderer.py", line 376, in handle_hover_in self._context.tooltip.show_and_track(self._context._view, xx, yy, mforms.Right) AttributeError: 'module' object has no attribute 'Right' How to repeat: Archlinux: 1. Insall It By pacman -S mysql-workbench 2. Then Open it in a terminal. 3. Write whatever sql statement, Click on explain BUtton 4. Hover the mouse on any visual explain result. Suggested fix: Just Fix the Script And make it work. I don't know python much