[PHOENIX-1420] DatabaseMetaData.getschemas returns incorrect column order

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1.0
• Fix Version/s: 4.3.0, 3.3.0, 4.2.1, 3.2.1

Environment

all OS

• Assignee: Unassigned
• Reporter: Sergio Lob
• Created: 07/Nov/14 15:47
• Updated: 21/Nov/15 02:16
• Resolved: 13/Nov/14 07:42

Description

DatabaseMetaData.getSchemas returns incorrect column order. According to java 6 api doc, getSchemas should return answer set columns in the following order:

1.TABLE_SCHEM String => schema name
2.TABLE_CATALOG String => catalog name

The Phoenix JDBC driver returns these in reverse column order, i.e.
1. TABLE_CATALOG
2. TABLE_SCHEM

Our experience with other JDBC drivers is that they return the data w/ TABLE_SCHEM being the first column.