Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
EXPLAIN output on 18.104.22.168 and ODBC connection pooling
Date: Sat Apr 03 2004 - 19:32:32 CST
On Wiin32 (Windows XP or Windows 2000) with latest MaxDB 22.214.171.124 driver and server... two systems (one server, one client). Using the
Unicode ODBC driver.
If I do these two queries from the same connection:
EXPLAIN SELECT field FROM TABLE
SELECT * FROM SHOW
I get my explain output... however, it only works if ODBC Connection Pooling is enabled on the MaxDB ODBC driver. If I turn off ODBC driver
connection pooling, it always fails saying that there is no SHOW table.
Also I'm still intersted in why one has to do the "SELECT * FROM SHOW" in the first place. I notice that the Python sample (posted previously
on the mailing list) does not have to do this. Does the python driver internally do the SELECT FROM SHOW 'automagically' and the ODBC
driver does not?
Reference python explain.py code: http://lists.mysql.com/maxdb/9229
full time traveler with home on wheels
currently in Irving Texas, USA
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb