| 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: | |
| 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: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?
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".