[DRILL-5615] DatabaseMetadata.getColumns fails with SQL Server (Unknown SQL type -155, -150)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Client - Java
• Assignee: Unassigned
• Reporter: N Campbell
• Created: 28/Jun/17 15:31
• Updated: 29/Jun/17 11:11

Description

Attempting to call DatabaseMetadata.getColumns against SQL Server 2016 will fail for a datetimeoffset type.

create type DISTSTZ from datetimeoffset;
go

create table "TDISTSTZ" ( "RNUM" integer not null , "CDISTSTZ" DISTSTZ );

Exception in thread "main" java.sql.SQLException: Failure getting metadata: Unknown SQL type -155
at org.apache.drill.jdbc.impl.DrillMetaImpl$MetadataAdapter.getMeta(DrillMetaImpl.java:310)
at org.apache.drill.jdbc.impl.DrillMetaImpl.serverGetColumns(DrillMetaImpl.java:713)
at org.apache.drill.jdbc.impl.DrillMetaImpl.getColumns(DrillMetaImpl.java:971)
at oadd.org.apache.calcite.avatica.AvaticaDatabaseMetaData.getColumns(AvaticaDatabaseMetaData.java:621)
at org.apache.drill.jdbc.impl.DrillDatabaseMetaDataImpl.getColumns(DrillDatabaseMetaDataImpl.java:1186)

Similar problem with columns of VARIANT type