MySQL Bugs: #66157: Explain Current Statement not working

Bug #66157	Explain Current Statement not working
Submitted:	2 Aug 2012 13:22	Modified:	13 Nov 2012 5:02
Reporter:	Crisitan Petru Parvu	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.41 CE	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Running "Explain Current Statement" in Query menu, or using the button in the toolbar or the keyboard shortcut (CTRL+ALT+Enter), an Action is produced in the Output Window, but the window with the query Result is not displayed.

When "EXPLAIN" is put explicitly in front of a query, and run the query, the Result window is displayed as expected.

How to repeat:
Try one of the following:
- run "Explain Current Statement" from the Query menu;
- push the button in the toolbar; 
- use the keyboard shortcut (CTRL+ALT+Enter).

For any of the above the window with the query Result is not displayed.

Thank you for the bug report. Verified on Windows XP. Works on Mac OS X though, so this is a platform-specific bug.

Bug #66175 was marked as a duplicate of this one.

I get the same result in Windows 7.

Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

On Microsoft Windows, the "Explain Current Statement" option would not
function. A workaround is to manually prepend "EXPLAIN" to your query.

Thank you for the bug report.