[DRILL-4391] browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign keys as tables - ASF JIRA

Attach files

Attach Screenshot

Add vote

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Reviewable
Priority: Major
Resolution: Unresolved
Affects Version/s: 1.4.0
Fix Version/s: None
Component/s: Storage - JDBC
Labels:
None

Description

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.