sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Szabolcs Vasas (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-3124) Fix ordering in column list query of PostgreSQL connector
Date Mon, 16 Jan 2017 08:03:26 GMT
Szabolcs Vasas created SQOOP-3124:
-------------------------------------

             Summary: 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


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)

Mime
View raw message