second88 created DRILL-5837:
-------------------------------
Summary: Methods of DatabaseMetaData with names start with
supportsCatalogs in JDBC API should return false
Key: DRILL-5837
URL: https://issues.apache.org/jira/browse/DRILL-5837
Project: Apache Drill
Issue Type: Bug
Components: Client - JDBC
Affects Versions: 1.10.0
Reporter: second88
Priority: Minor
The following 5 methods of java.sqlDatabaseMetaData in JDBC API should return
false but they currently return true for Drill JDBC connection:
supportsCatalogsInDataManipulation()
supportsCatalogsInProcedureCalls()
supportsCatalogsInTableDefinitions()
supportsCatalogsInIndexDefinitions()
supportsCatalogsInPrivilegeDefinitions()
As far as I know, the synthetic catalog "DRILL" cannot be used in the creation
of table, view and function in Drill.
For example, the following statement is incorrect:
{code:sql}
CREATE TABLE DRILL.df.tmp.`name_key` (N_NAME, N_NATIONKEY) AS SELECT
N_NATIONKEY, N_NAME FROM
dfs.`/Users/drilluser/apache-drill-1.0/sample-data/nation.parquet`
{code}
For consistency, all 5 methods should return false though only
supportsCatalogsInProcedureCalls() and supportsCatalogsInTableDefinitions() are
currently meaningful to Drill.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
