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 82DF2200BFE for ; Mon, 16 Jan 2017 09:03:34 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 818C6160B30; Mon, 16 Jan 2017 08:03:34 +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 D54C9160B22 for ; Mon, 16 Jan 2017 09:03:33 +0100 (CET) Received: (qmail 52022 invoked by uid 500); 16 Jan 2017 08:03:32 -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 52010 invoked by uid 99); 16 Jan 2017 08:03:32 -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; Mon, 16 Jan 2017 08:03:32 +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 9A0201A0633 for ; Mon, 16 Jan 2017 08:03:32 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-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 (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id SeMQ1xPazTwF for ; Mon, 16 Jan 2017 08:03:31 +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 09DCD5FB43 for ; Mon, 16 Jan 2017 08:03:31 +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 3E1D5E7BF1 for ; Mon, 16 Jan 2017 08:03: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 9606225289 for ; Mon, 16 Jan 2017 08:03:26 +0000 (UTC) Date: Mon, 16 Jan 2017 08:03:26 +0000 (UTC) From: "Szabolcs Vasas (JIRA)" To: dev@sqoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (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 08:03:34 -0000 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)