Bug #81068 Graphical explain fails for update statement

• Submitted: 13 Apr 2016 13:28
• Modified: 16 Feb 2018 0:51
• Reporter: Knut Anders Hatlen
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.3.6/6.3.9
• OS: Ubuntu (15.10)
• 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.