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)
