result disabled on connection closed

Connection status:

• mysql+tcp
• compression on
• no ssl

Steps to produce:

1. connect
2. run select query
3. wait
4. log pane shows 'Connection to (IP here) closed at (datetime here)'

Current result: Result tab remains still but disabled. Cannot focus a cell, or scroll to read more cells.

Expected result:

1. not get disabled at all
2. or disabled but still scrollable to read, and select to copy

This is not possible. The results need their underlying connection. Otherwise mysql_fetch_field_direct would cause crashes in HeidiSQL.

Is 'freeze to readonly' impossible too?

If the query was slow, it becomes a big pain to run again the query. Or exporting the result cells immediately to another spreadsheet is yet another pain.

The various actions you can run on an enabled resultset would also implicitly trigger some MySQL API function, which then would crash in the same way.

Is there way to keep results at least visible on connection close after 7 years this question appear? I'm not asking data auto-refresh, just wanna be able to scroll and review table without that annoying "No data available for this item" in middle of work?

Sorry, cannot edit previous post to update info. I've just enabled timestamps in log and so far it loses connection (and clears results i'm reading) after 1 minute. Can it be customized somehow?

https://prnt.sc/NT2psBF28haE

Ping every 50 sec won't help.

You could increase the ping setting to a shorter interval. But probably there is some network problem causing your connection reset?