Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 4E124200C16 for ; Wed, 25 Jan 2017 12:06:31 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 4CA5A160B4E; Wed, 25 Jan 2017 11:06:31 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 9601C160B50 for ; Wed, 25 Jan 2017 12:06:30 +0100 (CET) Received: (qmail 7147 invoked by uid 500); 25 Jan 2017 11:06:29 -0000 Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@sqoop.apache.org Delivered-To: mailing list dev@sqoop.apache.org Received: (qmail 7136 invoked by uid 99); 25 Jan 2017 11:06:29 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jan 2017 11:06:29 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 204F91A0696 for ; Wed, 25 Jan 2017 11:06:29 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.999 X-Spam-Level: X-Spam-Status: No, score=-1.999 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 83xOBQA5001g for ; Wed, 25 Jan 2017 11:06:28 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 269335FC06 for ; Wed, 25 Jan 2017 11:06:28 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 4F6DBE036D for ; Wed, 25 Jan 2017 11:06:27 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 7F78825290 for ; Wed, 25 Jan 2017 11:06:26 +0000 (UTC) Date: Wed, 25 Jan 2017 11:06:26 +0000 (UTC) From: "Szabolcs Vasas (JIRA)" To: dev@sqoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (SQOOP-3124) Fix ordering in column list query of PostgreSQL connector MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 25 Jan 2017 11:06:31 -0000 [ https://issues.apache.org/jira/browse/SQOOP-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Szabolcs Vasas resolved SQOOP-3124. ----------------------------------- Resolution: Fixed > 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)