Repository: sqoop
Updated Branches:
  refs/heads/trunk 4a74b8bce -> d0f99c01c


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)


Project: http://git-wip-us.apache.org/repos/asf/sqoop/repo
Commit: http://git-wip-us.apache.org/repos/asf/sqoop/commit/d0f99c01
Tree: http://git-wip-us.apache.org/repos/asf/sqoop/tree/d0f99c01
Diff: http://git-wip-us.apache.org/repos/asf/sqoop/diff/d0f99c01

Branch: refs/heads/trunk
Commit: d0f99c01c7afa8fade70c4429899e36d3b29cc39
Parents: 4a74b8b
Author: Attila Szabo <[email protected]>
Authored: Tue Jan 17 16:30:04 2017 +0100
Committer: Attila Szabo <[email protected]>
Committed: Tue Jan 17 16:30:04 2017 +0100

----------------------------------------------------------------------
 src/java/org/apache/sqoop/manager/PostgresqlManager.java | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/sqoop/blob/d0f99c01/src/java/org/apache/sqoop/manager/PostgresqlManager.java
----------------------------------------------------------------------
diff --git a/src/java/org/apache/sqoop/manager/PostgresqlManager.java 
b/src/java/org/apache/sqoop/manager/PostgresqlManager.java
index bd882b9..44e041a 100644
--- a/src/java/org/apache/sqoop/manager/PostgresqlManager.java
+++ b/src/java/org/apache/sqoop/manager/PostgresqlManager.java
@@ -155,7 +155,8 @@ public class PostgresqlManager
     + "  AND sch.NSPNAME = " + getSchemaSqlFragment()
     + "  AND tab.RELNAME = '" + escapeLiteral(tableName) + "' "
     + "  AND col.ATTNUM >= 1"
-    + "  AND col.ATTISDROPPED = 'f'";
+    + "  AND col.ATTISDROPPED = 'f' "
+    + "ORDER BY col.ATTNUM ASC";
   }
 
   @Override

Reply via email to