Bug #81068 Graphical explain fails for update statement
Submitted: 13 Apr 2016 13:28 Modified: 16 Feb 2018 0:51
Reporter: Knut Anders Hatlen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.6/6.3.9 OS:Ubuntu (15.10)
Assigned to: CPU Architecture:Any

[13 Apr 2016 13:28] Knut Anders Hatlen
Description:
With MySQL Workbench 6.3.6 connected to MySQL Server 5.7.12, running graphical explain on an update statement fails with the following error message:

Query Plan Generation Error

An unexpected error occurred during creation of the graphical query plan.
Please file a bug report at http://bugs.mysql.com along with the query and the Raw Explain Data.

Exception: invalid literal for int() with base 10: '100.00'

How to repeat:
Execute:
create table t(i int);

And then run explain (Ctrl-Alt-X) on:
update t set i = 123;
[13 Apr 2016 14:27] MySQL Verification Team
exception dialog

Attachment: query_plan.png (image/png, text), 179.24 KiB.

[13 Apr 2016 14:28] MySQL Verification Team
Thank you for the bug report.
[17 Apr 2017 11:20] Miguel Tadeu Mota
Can't repeat with Workbench 6.3.9. Closing it.
[3 May 2017 12:40] Miguel Tadeu Mota
Fixed conversion from float string to int.
commid it: 12d1028e3826b4f0081ec5c81b01c09010601a3b
[2 Jul 2017 18:27] MySQL Verification Team
https://bugs.mysql.com/bug.php?id=86897 marked as duplicate of this one.
[2 Jul 2017 18:36] MySQL Verification Team
on 6.3.9. version

Attachment: update_error_explain_message.png (image/png, text), 78.21 KiB.

[16 Feb 2018 0:51] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.0 release, and here's the changelog entry:

When executing Explain Current Statement (Ctrl+Alt+X) from the menu on an
UPDATE statement, a query plan generation error was displayed and the
operation failed.

Thank you for the bug report.