[12.0.167 BETA] - Tab switching (SQL Server) + FR: tab color

[12.0.167 BETA] - Tab switching (SQL Server) + FR: tab color

I noticed that when having a long-running script being executed in a tab that uses RAISERROR to show some progress information from time to time, SQL Editor instantly switches to that tab. If the SQL Editor does not have the focus at the time of the tab switch, the tab bar still shows the original tab to be selected and not the one that is displayed (check this short video here).

It is also likely to result in something catastrophic when this tab switch happens in the middle of doing/typing something in another tab, eg. I'm about to abort the execution in the current tab, and suddenly, the current tab is no longer the same it was just a second ago and I end up killing the wrong query.

While it is useful to notify the users that there is some action going on (there are new messages in a tab's message pane), this is more a distraction/nuisance than a help. There's currently a color coding applied to tabs to mark them as executing a query (a whiter shade of pale, not very visible, though). Why not simply use more colors? The messages pane's tab gets a not-too-well distinguishable green marker when the query is executed successfully and a rather well-visible one when the was an error.

You could color the editor tabs in the same manner:
- the original gray when there's no result/messages pane open
- red when the query failed
- green when the query has been executed successfully
- yellow (a slightly more visible tinge of it, perhaps) when execution is in progress
- (flashing?) blue when the execution is in progress but the tab is not current and it has (yet) unseen messages.

I don't believe the described behavior is intentional, the messages should stay on the tab they belong to and the input focus can't jump just because some new message is received. Each tab has its own messages pane, could be actually multiple message panes on each tab if they are renamed.

I submitted new issue #SA0042123, hopefully this can be quickly fixed.

It's not the messages that wander around. The message pane does stay on the tab it belongs to, SE switches to the tab that receives a new message. The tab switch is clearly visible, it happens as if I had clicked that tab. The short video I attached presents the case when SE does not have the focus, in which case the tab is still switched that fact is not reflected on the tab row.

Thank you for additional clarifications, I have added them to the ticket.