[
https://issues.apache.org/jira/browse/PHOENIX-843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13933573#comment-13933573
]
Gabriel Reid commented on PHOENIX-843:
--------------------------------------
I think that it's the same deal with the unsigned types as with the arrays --
the type integer reported by in getColumnType should be the generic
java.sql.Types value that represents the type, and additional information can
be retrieved via the type name. I think in the general case of a basic SQL tool
that is executing queries, it (probably) doesn't need to know whether a column
is signed or not, but it's more important that it does know that it's a
numerical column so that it can do number formatting correctly, etc.
> Incorrect java.sql.Types value returned for array types in result set
> ---------------------------------------------------------------------
>
> Key: PHOENIX-843
> URL: https://issues.apache.org/jira/browse/PHOENIX-843
> Project: Phoenix
> Issue Type: Bug
> Reporter: Gabriel Reid
> Attachments: PHOENIX-843.patch
>
>
> All array PDataTypes currently return their Phoenix-specific type constant in
> PDataType#getResultSetSqlType. This causes issues with external tools which
> aren't familiar with the Phoenix array types, so java.sql.Types.ARRAY should
> be returned for array types instead.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
