[
https://issues.apache.org/jira/browse/SQOOP-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15826240#comment-15826240
]
ASF subversion and git services commented on SQOOP-3124:
--------------------------------------------------------
Commit d0f99c01c7afa8fade70c4429899e36d3b29cc39 in sqoop's branch
refs/heads/trunk from [~maugli]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=d0f99c0 ]
SQOOP-3124: Fix ordering in column list query of
PostgreSQL connector to reflect the logical order
instead of adhoc ordering
(Szabolcs Vasas via Attila Szabo)
> Fix ordering in column list query of PostgreSQL connector
> ---------------------------------------------------------
>
> Key: SQOOP-3124
> URL: https://issues.apache.org/jira/browse/SQOOP-3124
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.4.6
> Reporter: Szabolcs Vasas
> Assignee: Szabolcs Vasas
> Fix For: 1.4.7
>
> Attachments: SQOOP-3124.patch
>
>
> PostgreSQL connector gets the lit of column names from pg_attribute system
> catalog table using the following query:
> {code}
> SELECT col.ATTNAME FROM PG_CATALOG.PG_NAMESPACE sch, PG_CATALOG.PG_CLASS
> tab, PG_CATALOG.PG_ATTRIBUTE col
> WHERE sch.OID = tab.RELNAMESPACE AND tab.OID = col.ATTRELID AND
> sch.NSPNAME = (SELECT CURRENT_SCHEMA()) AND tab.RELNAME = ? AND col.ATTNUM
> >= 1 AND col.ATTISDROPPED = 'f'
> {code}
> This SELECT statement does not contain an ORDER BY clause so the order of the
> result set is not guaranteed to be the column order defined during table
> creation and this can cause issues for the users.
> The task is to make sure that the result set of this query is sorted by the
> attnum column of the pg_attribute table
> (https://wiki.postgresql.org/wiki/Alter_column_position).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
