MySQL Bugs: #90875: result grid keeps disappearing

Bug #90875	result grid keeps disappearing
Submitted:	15 May 2018 19:26	Modified:	16 Oct 2018 14:59
Reporter:	John Montgomery	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.11	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
result grid keeps disappearing

How to repeat:
run query

Thank you for the bug report. I couldn't repeat this issue, please elaborate how to repeat (specific table, data, local connection/remote ?). Thanks.

I have hit this a few times since updating but have been unable to reliably reproduce it.

When it happens Workbench needs to be restarted to get the result window back. Just reopening the connection/IDE and running the query again does not help.

I have multiple remote (ssh tunneled) connections open and it doesn't appear tied to anything in particular

I can confirm what Fredric wrote (same version of Workbench). Suddenly the Result Grid disappear and I could only get it back by either 

a) execute with "explain" and then choose the result grid. Though this was the only way to actually get to the Result Grid.   

b) restart the Workbench application. Then it all of a sudden re-appeared where it should be.

It was not possible to just drag the Result Grid back with the mouse either as some posts on the Internet suggested. I really, really tried that one. It was totally missing.

I would suggest adding a menu item in View to be able to get it back since it apparently is possible to get rid of it.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

This bug seems duplicate elsewhere, not sure which bug is the active one, but I'll include my repro here just in case.

1. Start several query tabs
2. In at least one of the tabs, include statements that do not require an output (I used Prepare / Execute / Deallocate)
3. In any tab, run a query which requires output, the grid is gone and you have to click the lightening bolt with mag glass, then choose results grid.  This must be done for each execution of an output query.

Some things to note: 

1) you do not need to restart workbench to get your results grid back - that is not a true workaround
2) you can comment out the non-output statements, then run an output query and the grid displays
3) if you leave the non-output statements alone, you can leave and re-enter workbench until the cows come home - you will never get the results grid to display.

So the problem seems pinned to the existence of a statement which requires no output.

I cant reproduce it with the instructions given in the last comment

I can confirm that in Ubnutu 18.04 the same Issue

I'm using Workbench 8.0.12 and it usually happens when I forget to terminate a SQL statement with a semicolon. It's inconsistent though. The only way to get the result grid back is to shutdown the Workbench.

Yes, Several people here are having the very same problem. I don't know hoe to repeat it but it happens at random and usually when we are in a meeting trying to research an issue or solve a problem. 

MySQL Workbench 8.0.12, Windows 10

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

I am also experiencing this error on a Windows Server 2008 R2 computer running MySQL Workbench 8.0.12 community edition build 13312926.
The error seems to occur when I have opened several query tabs and the query I run does not return any rows or causes an error. Then the results pane is not shown. When I activate my first tab and attempt to re-run the same query that previously returned results the results pane disappears, even though the status bar shows the number of rows returned.

I too reliably have this bug.  It is very annoying. There doesn't appear to be any specific trigger other than running a query...  Works for a while, then poof! no result grid.  Explain Current Statement, click Result Grid shows it but I have to do that every time I run a query.

Once it is gone on one tab, it is gone on all (as soon as a query is executed on the tab)

Windows 10. Workbench 8.0.12

I am experiencing the same bug of the results grid disappearing. I have been able to reproduce it reliably by running a stored procedure. When I first run the stored procedure it will work fine, then when I alter the procedure and rerun it the results grid will not appear but the output window below will tell me the the query executed and x rows were returned in the message. Only way to make it come back is to exit workbench and then restart. 

I am running Windows 8

Appears to be fixed in 8.0.13.  Try update.  I have not seen it since I updated.
Regards