[
https://issues.apache.org/jira/browse/PHOENIX-1420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14202255#comment-14202255
]
James Taylor commented on PHOENIX-1420:
---------------------------------------
We based the column order on the javadoc:
http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[])
> 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)
