[SQOOP-414] Column names are not guaranteed in order for getColumnNames of OracleManager

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.1-incubating
• Assignee: Bilung Lee
• Reporter: Bilung Lee
• Created: 19/Dec/11 19:42
• Updated: 08/Jan/12 16:47
• Resolved: 08/Jan/12 16:47

Description

OracleManager uses the following query to retrieve column names:
public static final String QUERY_COLUMNS_FOR_TABLE =
"SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE "
+ "OWNER = ? AND TABLE_NAME = ?";

However, it does not guarantee the order of the returned column names
unless a "ORDER BY" is specified. This may not work properly for newer
version of Oracle.