commit d0f99c01c7afa8fade70c4429899e36d3b29cc39
author Attila Szabo <maugli@apache.org> Tue Jan 17 16:30:04 2017 +0100
committer Attila Szabo <maugli@apache.org> Tue Jan 17 16:30:04 2017 +0100
tree 0905870696430f14860b6503b48a9fbb84827115
parent 4a74b8bced22d4be83e93ac185d0cd6a2b48b260

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)

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 @@
     + "  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