So I write a lot of complex queries in my job and often have to create temporary tables to manipulate the data a second time. I’m not sure whats going on with this query exactly but when I execute it in Toad for MySQL I get a nice little results set with one row showing me the count. In Toad Edge I get … nothing. The progress window clearly shows that it’s executing 5 different statements but once it’s done this is all I see (even if I get rid of the “DROP TABLE” so the last statement is the SELECT).
At present, for the results set to appear you need to execute the SELECT statement with nothing else included. You could try executing the part of the script before the SELECT statement, then the statement (and possibly save the results), and then the rest of the script.
I realize it is not optimal, so I have created a new CR to address this.