[
https://issues.apache.org/jira/browse/PHOENIX-1420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14202467#comment-14202467
]
James Taylor commented on PHOENIX-1420:
---------------------------------------
Strange - for getSchemas() it should be schema name first followed by table
cat, but for getColumns and getTables table cat is first. We can fix this in
our next patch release. In the meantime, perhaps you can access via the name
instead of positionally?
> DatabaseMetaData.getschemas returns incorrect column order
> ----------------------------------------------------------
>
> Key: PHOENIX-1420
> URL: https://issues.apache.org/jira/browse/PHOENIX-1420
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.1
> Environment: all OS
> Reporter: Sergio Lob
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
