[jira] [Created] (DRILL-5844) Incorrect values of TABLE_TYPE returned from method DatabaseMetaData.getTables of JDBC API

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

second88 created DRILL-5844:
-------------------------------

             Summary: Incorrect values of TABLE_TYPE returned from method DatabaseMetaData.getTables of JDBC API
                 Key: DRILL-5844
                 URL: https://issues.apache.org/jira/browse/DRILL-5844
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - JDBC, Metadata
            Reporter: second88
            Priority: Minor


As far as I can see, the values of TABLE_TYPE returned from method DatabaseMetaData.getTables of JDBC API of a Drill Connection include:
TABLE
VIEW
SYSTEM_TABLE

According to [JDBC API|http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String\[\])], the typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

Therefore "SYSTEM_TABLE" should be replaced by "SYSTEM TABLE".

Besides, I wonder if this bug is related to another bug [DRILL-5843|https://issues.apache.org/jira/browse/DRILL-5843] reported by me.
It should be noted that the values of TABLE_TYPE returned from methods DatabaseMetaData.getTables and DatabaseMetaData.getTableTypes should be one-to-one matched with but may not be the same as those in INFORMATION_SCHEMA.TABLES.TABLE_TYPE, for instance, "TABLE" VS "BASE TABLE".



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