[Zope] MySQL Temporary Tables & Z SQL Queries

10 Feb 2004

      I have a query much like:

CREATE TEMPORARY TABLE temp SELECT * FROM FOO, FOO2
 ... delimiter ...
SELECT * FROM BAR LEFT JOIN temp

The problem is that because Zope doesn't close the connection, the 
temporary table is left around.  If I drop the temporary table at the 
end of the query, I get no query results from Zope.  If I don't, it 
complains on subsequent queries that the temp table exists already.

Any suggestions?
-- 
Michael T. Babcock