[DRILL-5614] DatabaseMetadata.getColumns fails with ORACLE (Unknown SQL type 101, -104, -103, -101)

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

Description

Using the 1.10 JDBC driver and server, a plugin mapped to ORACLE will throw an exception when DatabaseMetadata.getColumns is called.

This will occur when an ORACLE table has a BINARY DOUBLE data type which they assign the type value 101.

CREATE TABLE "ABC"."TBINDOUBLE"
( "RNUM" NUMBER(*,0),
"C1" BINARY_DOUBLE
) ;

Exception in thread "main" java.sql.SQLException: Failure getting metadata: Unknown SQL type 101
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 issues with interval day second, interval year month, timestamp with time zone