[ 
https://issues.apache.org/jira/browse/PHOENIX-1420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14202452#comment-14202452
 ] 

Sergio Lob commented on PHOENIX-1420:
-------------------------------------

getSchema() answer set description in java doc does seem inconsistent with 
getTables , getColumns, I grant you that. I would also have thought that 
catalog should go before schema.  The description for getSchema seems to 
contradict this, however. As the java api doc is the 'standard', though, it 
should not be left to the reader to reinterpret the documentation. Are you 
aware of any other JDBC driver that sets the column-ordering this way?  

> 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)

Reply via email to