Description:
This is a re-submit of the old bug#7158 which was declared "not a bug":
----
[10 Dec 2004 13:49] Michael G. Zinner
When executed as "query" in the query area, a new connection is opened for each
query. Therefore you don't see a temporary table or session variable in the next select/insert.
The reason for this is, that we need to kill the connection if the user presses
the stop button, as well as to allow several queries on different tabsheets to
be executed at the same time.
----
Still, it does feel like a bug and it causes serious inconvenience, so I'd like to discuss the issue again.
When you can do a trivial thing like:
set @x = 'test';
select @x;
in the console client, but not in the GUI version, this is simply not right. It might have been by design, but it's a bug, not a feature.
At the very least, there should be an option in QBrowser's configuration dialog to change this behaviour.
As to:
> The reason for this is, that we need to kill the connection if the user presses the stop button,
THEN you can re-open the connection (and lose the context). No need to re-open it while everything is working fine.
> as well as to allow several queries on different tabsheets to
be executed at the same time.
Even if you have a very limited number of connections, you could reset the current connection when switching to another tab, but NOT after each statement.
How to repeat:
set @x = 'test';
select @x;