We have also encountered a problem with temporary tables. We are able to
create the tables and retrieve data from them when the data is numeric. When
trying to retrieve string data (varchar, text, mediumtext, etc.), CF throws an
error saying that the temporary table could not be found. Trying to get
information about the temporary table after the error indicates that the
temporary table is still present -- it has not been dropped by MySQL.
Using CF MX6 and MySQL 4.1, the temporary tables work fine.
Using CF MX7 and MySQL 4.1, the temporary tables work fine.
Using CF MX6 and MySQL 5.0, the temporary tables work fine.
Using CF MX7 and MySQL 5.0, the temporary tables do not work.
We have tested various JConnectors, and they do not seem to be the source of
the problem. Creating and reading from temporary tables using Java (and the
same JConnectors) works fine. See MySQL site: