Bug #116152 Visual Explain option not available after query, reverts back to Tabular Explain
Submitted: 18 Sep 22:24 Modified: 20 Sep 0:27
Reporter: Jennifer Forde-Watling Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.38 OS:MacOS (macOS 14.x Sonoma x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[18 Sep 22:24] Jennifer Forde-Watling
Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/jenniferforde-watling/Library/Application Support/MySQL/Workbench/log/wb.log]

How to repeat:
run this query

SELECT CustomerID, ContactName, CompanyName
FROM Customers;

select execution plan

only tabular explain window appears, when I try to select visual explain its does nothing and reverts back to tabular explain option
[19 Sep 7:00] MySQL Verification Team
Hello Jennifer,

Thank you for the report and feedback.
Initially thought this could be duplicate of Bug #112640 (which itself is marked as dup of Bug #97595 but doesn't look duplicate actually). I quickly tried with MySQL Workbench Community (GPL) for macOS version 8.0.38 CE build 4270059 (64 bit) on macOS 14.x Sonoma arm64 but not seeing the issue as reported. Attaching the screenshot shortly.

To investigate further this issue at our end, may I kindly request you
to launch workbench under debug mode (--log-level=debug3) and provide
unaltered workbench log file(more details about log are explained here
-
https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html)
along with screenshot of the problem? Thank you.

regards,
Umesh
[19 Sep 7:01] MySQL Verification Team
VisualExplain Screenshot

Attachment: VisualExplain.jpg (image/jpeg, text), 296.04 KiB.

[20 Sep 0:27] Jennifer Forde-Watling
To be honest I couldn't launch workbench under debug mode (--log-level=debug3). I tried open MySQLWorkbench.app --log-level debug3 and got open: unrecognized option `--log-level'. I have included a video of my problem and the log files.

Thank you