[SQOOP-445] Wrong query for getListColumnsQuery in PostgresqlManager

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0-incubating, 1.4.1-incubating
• Fix Version/s: 1.4.2
• Component/s: connectors/postgresql

Environment

PostgreSQL 9.1

• Assignee: Cheolsoo Park
• Reporter: Davide Grohmann
• Created: 24/Feb/12 14:32
• Updated: 25/Jul/12 19:50
• Resolved: 27/Apr/12 16:37

Description

When querying for column available in a postgres table from postgres catalog, it returns also the dropped columns from the table in object. It can be easily fixed adding the extra constraint "AND col.ATTISDROPPED = 'f'" at the end of the query which sort out the dropped columns.

Sub-Tasks

• Create a unit test for SQOOP-445 Wrong query for getListColumnsQuery in PostgresqlManager: Resolved