[
https://issues.apache.org/jira/browse/DRILL-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15171691#comment-15171691
]
Taras Supyk commented on DRILL-4391:
------------------------------------
Reproduce steps:
create sequence user_ids;
create table users (id integer primary key default nextval('user_ids'), login
char(64);
In drill console:
show tables in psql.public;
user_ids and users_pkey are also shown in result as tables
> browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign
> keys as tables
> --------------------------------------------------------------------------------------------
>
> Key: DRILL-4391
> URL: https://issues.apache.org/jira/browse/DRILL-4391
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Affects Versions: 1.4.0
> Reporter: N Campbell
> Assignee: Taras Supyk
>
> Apache Drill has storage defined to access a Postgres database
> A schema in the database has several tables which either have indexes,
> primary keys, foreign keys or combination of them all.
> When SQLSquirrel presents metadata from the Drill JDBC driver the list of
> tables will include entries which correspond to the indexes, primary or
> foreign keys in the schema. The implication being that non-standard JDBC
> metadata methods to obtain information is being used.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
