[DRILL-5619] DatabaseMetadata.getColumns fails with Postgres

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Client - JDBC

Environment

Drill JDBC 1.10 and Drill server 1.10

Using Postgres postgresql-42.0.0.jar accessing Postgres 9.6

• Assignee: Unassigned
• Reporter: N Campbell
• Created: 29/Jun/17 11:28
• Updated: 29/Jun/17 11:28

Description

While DatabaseMetadata.getCatalogs and getSchemas does not abort.

Attempting to invoke DatabaseMetadata.getTables passing the catalog name DRILL and the schema name returned by getSchemas will abort with Postgres.

The same logic when performed with Drill mapped to ORACLE, SQL Server etc. does not abort.

String [] types =

{ "TABLE" }

;
ResultSet tbl = dbMeta.getTables("DRILL", "certpostgres.dbcert", "%", types);

Exception in thread "main" java.sql.SQLException: Failure getting metadata:
at org.apache.drill.jdbc.impl.DrillMetaImpl$MetadataAdapter.getMeta(DrillMetaImpl.java:310)
at org.apache.drill.jdbc.impl.DrillMetaImpl.serverGetTables(DrillMetaImpl.java:394)
at org.apache.drill.jdbc.impl.DrillMetaImpl.getTables(DrillMetaImpl.java:428)
at oadd.org.apache.calcite.avatica.AvaticaDatabaseMetaData.getTables(AvaticaDatabaseMetaData.java:587)
at org.apache.drill.jdbc.impl.DrillDatabaseMetaDataImpl.getTables(DrillDatabaseMetaDataImpl.java:1145)