Description:
The button that allows you to run an explain plan for a selected query does not return a result to the resultsets window. It will tell you in the output that xxx rows have been returned, but the resultset remains as whatever is written in the query (results of a 'select *' for instance). if you manually type out and run a 'Explain select *' then the resultset will correctly display the explain plan.
----- Developer Notes -----
MySQL Workbench CE for Windows version 5.2.42 revision 9752
Configuration Directory: C:\Users\JaredE\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit
CPU: 4x Intel(R) Core(TM) i5-2310 CPU @ 2.90GHz, 4.0 GiB RAM
Active video adapter (0): NVIDIA GeForce GT 530
Installed video RAM: 1023 MB
Current video mode: 1680 x 1050 x 4294967296 colors
Used bit depth: 32
Driver version: 8.17.13.142
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: English (United Kingdom)
How to repeat:
1) load MySQL WorkBench 5.2.42 revision 9752
2) connect to a database
3) in SQL Editor tab, write a select statement 'select 1+1' from dual for instance
4) Click the Run SQL button which will display the resultset
5) click the Explain Plkan button, which will leave the previous resultset up, but in the Output box it will tell you 2 rows have been returned.
