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

["Arina Ielchiieva (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arina Ielchiieva updated DRILL-5844:
------------------------------------
    Fix Version/s: 1.17.0

> 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
>    Affects Versions: 1.10.0
>            Reporter: second88
>            Priority: Minor
>             Fix For: 1.17.0
>
>
> 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
(v8.3.4#803005)