You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Cheolsoo Park (Assigned) (JIRA)" <ji...@apache.org> on 2012/04/17 08:13:30 UTC

[jira] [Assigned] (SQOOP-445) Wrong query for getListColumnsQuery in PostgresqlManager

     [ https://issues.apache.org/jira/browse/SQOOP-445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Cheolsoo Park reassigned SQOOP-445:
-----------------------------------

    Assignee: Cheolsoo Park
    
> Wrong query for getListColumnsQuery in PostgresqlManager
> --------------------------------------------------------
>
>                 Key: SQOOP-445
>                 URL: https://issues.apache.org/jira/browse/SQOOP-445
>             Project: Sqoop
>          Issue Type: Bug
>          Components: connectors/postgresql
>    Affects Versions: 1.4.0-incubating, 1.4.1-incubating
>         Environment: PostgreSQL 9.1
>            Reporter: Davide Grohmann
>            Assignee: Cheolsoo Park
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira