Bug #92003 Workbench Result Grid does not appear
Submitted: 14 Aug 2018 5:04 Modified: 14 Aug 2018 5:33
Reporter: Rafael Bracho Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.12 OS:Windows
Assigned to: CPU Architecture:x86 (64-bit)

[14 Aug 2018 5:04] Rafael Bracho
Description:
The "Result Grid" stops "appearing" to show the results of a SELECT query, even though the "Output Area Panel" (showing "Action Output") says that a non-zero number of rows were returned by the query.  The problem was NOT present in 6.3.10 but it was there in 8.0.11rc

How to repeat:
I was able to reproduce as follows:

1. Open connection to 8.0.12 server (Win64) with user 'root'
2. Open 'World' schema, 'Tables', right-click on 'city', select 'Select Rows' (I have a default limit of 5000 rows, but I doubt that changes anything).
2a. At this point, the panel labelled "Output" says that 4079 rows were returned, and a query tab labelled "city" opens up with the "Result Grid" showing.
3. Right-click again on the 'city' table, this time select 'Alter Table...'
3a. A new tab labelled "city - Table" appears with the "Columns" sub-tab showing.
4. Go back to the query tab "city" and edit the query showing:
    SELECT * FROM world.city;
change it to:
    SELECT * FROM world.city WHERE CountryCode = 'MEX';
4a. The "Result Grid" disappears and never re-appears, although the "Output" panel says that 173 rows were returned.
4b. Nothing brings the "Result Grid" back in ANY query tab.

Suggested fix:
The only known "solution" is to exit Workbench altogether.  Closing the connection and re-opening it does not work, the new connection comes back and there is no way to get a "Result Grid".
[14 Aug 2018 5:10] MySQL Verification Team
Hello Rafael,

Thank you for the report.
This is duplicate of Bug #91265, please see Bug #91265

regards,
Umesh
[14 Aug 2018 5:33] Rafael Bracho
Apologies for the duplicate.  I searched the bug database the best I could, and also posted in the Forum, thinking that there should have been a bug filed since I saw a note in StackOverflow.  Otherwise, I wouldn't have tried hard to duplicate it with the standard tables and minimum number of steps.  It is obviously not a critical bug, but it is extremely annoying.  Thanks!
[15 Apr 2022 16:19] Anagha Mohandas
I recently installed mysql for educational purposes.
When I query something or even if I create a table in mysql workbench action output is not seen. Let me know how to fix the bug?