TTSneko: So as 1 example, SQL Server Management Studio doesn't behave this way. If after running a query and getting back results, the underlying data later changes or the connection becomes invalid I DON'T CARE. And SSMS is quite content to display the original result set until the world ends, or until I re-run the query. I want my results to stay the way I left them. Apparently SSMS users are happy with that scenario and have been for decades. The fact that the underlying data in the database may have actually changed is fine. I don't care. I can run the query again if I want fresh data. Want I don't want is to suddenly lose my result set against my wishes.
Your use case is a valid one I guess, but mine is too. That's why from the very beginning I simply requested a setting. Some kind of bool flag that tells Heidi whether to aggressively screw up my result set (why anyone would want that is still bizarre to me, but whatever) OR to leave my results alone until I requery.
My mind is open to your desired scenario, and thus a setting could make sense. Why is your mind so closed to my scenario? (Which is also how other sql clients work).
Also you are highly prone to making assumptions: >> "Which probably explains why you went through so many SQL editors" - The fact is, Heidi is only my 2nd MySQL query client after Workbench. I like Heidi better for a number of reasons, but are you aware that Workbench doesn't do this weird NODE results behavior? I have used other clients for other database engines, like SSMS and 1 for Oracle. None of these other clients behave in the way that you believe is correct.
And how do you figure it's lazy to want my results to remain after running a query? I still don't see why anyone would want that, and certainly in the MS world nobody does.
In summary, it seems like the root of the whole issue is that you WANT to know (after getting back results) if the connection is gone or if the data has changed or etc. So tell me what's wrong with this alternative: if the connection drops or the data changes or whatever, why not have a little icon indicate that, or a change in background color, or a status bar message saying "your connection is gone" or etc. Can you tell me what is so great about having your results STOMPED rather than a little indicator that the connection is gone or stale?