[
https://issues.apache.org/jira/browse/DRILL-5613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated DRILL-5613:
------------------------------
Summary: DatabaseMetadata.getTables throws exception when null used for
catalog/schema or % used for schema (was: DatabaseMetadata.getTables throws
exception is the catalog or schema parameter is set to NULL)
> DatabaseMetadata.getTables throws exception when null used for catalog/schema
> or % used for schema
> --------------------------------------------------------------------------------------------------
>
> Key: DRILL-5613
> URL: https://issues.apache.org/jira/browse/DRILL-5613
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
> Affects Versions: 1.10.0
> Reporter: N Campbell
>
> DatabaseMetadata.getTables supports being passed a NULL value for a catalog
> https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getTables-java.lang.String-java.lang.String-java.lang.String-java.lang.String:A-
> Doing so results in a JDBC exception from Drill
> 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)
> String [] tableTypes = { "VIEW", "SYNONYM", "TABLE"};
>
> ResultSet rs = dbMeta.getTables( null, null, "%", tableTypes);
> ResultSet rs = dbMeta.getTables( "DRILL", null, "%", tableTypes);
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
