> 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:
====
//sapdb/V73/c_00/develop/sys/src/jv/com/sap/dbtech/vsp001/FunctionCode.java
#2 - d:\V73\c_00\develop\sys\src\jv\com\sap\dbtech\vsp001\FunctionCode.java
====
@@ -28,6 +28,7 @@
public static final int Select_FC = 4;
public static final int Update_FC = 5;
public static final int Delete_FC = 9;
+ public static final int Explain_FC = 27;
public static final int DBProcExecute_FC = 34;
public static final int Select_for_update_FC = 45;
public static final int Reuse_mass_select_FC = 46;
====
//sapdb/V73/c_00/develop/sys/src/jv/com/sap/dbtech/jdbc/StatementSapDB.java
#5 - d:\V73\c_00\develop\sys\src\jv\com\sap\dbtech\jdbc\StatementSapDB.java
====
@@ -165,7 +165,9 @@
int functionCode = replyPacket.functionCode ();
- if ((functionCode == FunctionCode.Select_FC) || (functionCode
== FunctionCode.Show_FC)) {
+ if ((functionCode == FunctionCode.Select_FC)
+ || (functionCode == FunctionCode.Show_FC)
+ || (functionCode == FunctionCode.Explain_FC)) {
isQuery = true;
this.parseSelectResult (replyPacket, sql);
}
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
