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 245B6200BFE for ; Mon, 16 Jan 2017 10:09:39 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 213C5160B30; Mon, 16 Jan 2017 09:09:39 +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 69E61160B22 for ; Mon, 16 Jan 2017 10:09:38 +0100 (CET) Received: (qmail 64720 invoked by uid 500); 16 Jan 2017 09:09:37 -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 64709 invoked by uid 99); 16 Jan 2017 09:09:37 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Jan 2017 09:09:37 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 247BCC00B6 for ; Mon, 16 Jan 2017 09:09:37 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.998 X-Spam-Level: X-Spam-Status: No, score=-1.998 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=-2.999, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 4E0u1PZIz9lV for ; Mon, 16 Jan 2017 09:09:36 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 90F2E5F4A7 for ; Mon, 16 Jan 2017 09:09:35 +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 4C0C8E865F for ; Mon, 16 Jan 2017 09:09:28 +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 ADD0425288 for ; Mon, 16 Jan 2017 09:09:26 +0000 (UTC) Date: Mon, 16 Jan 2017 09:09:26 +0000 (UTC) From: "Szabolcs Vasas (JIRA)" To: dev@sqoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (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: Mon, 16 Jan 2017 09:09:39 -0000 [ https://issues.apache.org/jira/browse/SQOOP-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Szabolcs Vasas updated SQOOP-3124: ---------------------------------- Attachment: SQOOP-3124.patch > 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)