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

• Type: Bug
• Status: Reviewable
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.0
• Component/s: Storage - JDBC
• Assignee: Taras Supyk
• Reporter: N Campbell
• Created: 17/Feb/16 01:30
• Updated: 21/Mar/16 13:27

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.