[jira] [Commented] (DRILL-4391) browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign keys as tables
[
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)
[jira] [Commented] (DRILL-4391) browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign keys as tables
[ https://issues.apache.org/jira/browse/DRILL-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15171677#comment-15171677 ] Taras Supyk commented on DRILL-4391: Confirmed > 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)
