[jira] [Created] (DRILL-5837) Methods of DatabaseMetaData with names start with supportsCatalogs in JDBC API should return false

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

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)