Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#698 [MS-SQL] metaData.getTables broken during EXPLAIN

v1.2
open
nobody
None
1
2013-03-19
2013-03-19
Karol Bucek
No

on SQLServer connection.getTables fails when EXPLAIN is on, steps to reproduce :
- try a matching connection.getMetaData().getTables(catalog, schema, tableName, types);
ResultSet will be valid e.g. getColumn(1) will contain the table name(s)
- turn on EXPLAIN by running (on the same connection): "SET SHOWPLAN_TEXT ON"
- run the same connection.getMetaData().getTables(catalog, schema, tableName, types);
now the ResultSet contains "non-sense" e.g. getColumn(1) == null

testen on 2012 with jTDS 1.3.0

Discussion