[jira] [Created] (DRILL-5619) DatabaseMetadata.getColumns fails with Postgres

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created DRILL-5619:
---------------------------------

             Summary: DatabaseMetadata.getColumns fails with Postgres
                 Key: DRILL-5619
                 URL: https://issues.apache.org/jira/browse/DRILL-5619
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - JDBC
    Affects Versions: 1.10.0
         Environment: Drill JDBC 1.10 and Drill server 1.10

Using Postgres postgresql-42.0.0.jar accessing Postgres 9.6
            Reporter: N Campbell


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)




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)