[MS-SQL] metaData.getTables broken during EXPLAIN
Brought to you by:
ickzon
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