Bug #7159 Temporary Tables do not work on Query Browser
Submitted: 10 Dec 2004 9:37 Modified: 10 Dec 2004 12:42
Reporter: Conor Meegan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.2 OS:Windows (Windows XP SP2)
Assigned to: Michael G. Zinner CPU Architecture:Any

[10 Dec 2004 9:37] Conor Meegan 
Description:
Query Browser does not appear to be able to handle temporary tables.

How to repeat:
CREATE TEMPORARY TABLE test_table1(col1 INT NOT NULL, col2 CHAR(4));
INSERT INTO test_table1(col1, col2) VALUES(1, 'abcd');

Returns test_table1 does not exist.  Works perfectly on the command line.
[10 Dec 2004 12:42] Michael G. Zinner 
When executed as "query" in the query area, a new connection is opened for each query. Therefore you don't see the temporary table 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.

If you want to create a temporary table, you can only do this when you start a transaction or when you do it in a script (press Ctrl+Shift+T).