"Dittmar, Daniel" wrote:
hi!
> > would be nice, if EXPLAIN would return the "show" table as the result.
> Just an oversight in the JDBC driver. If you can't wait for the next
> version, here is the patch:
okay, i've applied the path and trie it:
I use DbVisualizer 2.1 for testing. for normal select it automatically
shows the ResultSet. when i prepend "EXPLAIN" it pops up a window "Rows
affected: -1" (as it would normally do for INSERT/UPDATE).
the interesting thing: DbVisualizer re-displays the table for the
ResultSet at this point. the header fields of the table do not contain
the columns of the "SHOW" table, but of the Query i wanted to have
EXPLAINed...
i dont know it this is a bug/feature of DbVisualizer or just a
misunderstanding between the JDBC driver DbVisualizer...
perhaps it is a bug related to the MetaData of the ResultSet ?
thank you very much anyway,
Raimund
--
Raimund Jacob
\|/ ____ \|/
Pinuts Media+Science GmbH "@'/ ,. \`@"
Potsdamer Str. 96 /_| \__/ |_\
D-10785 Berlin \__U_/
http://www.pinuts.de/ voice: +49 30 590090313 fax: +49 30 590090390
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
