[
https://issues.apache.org/jira/browse/PHOENIX-116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid updated PHOENIX-116:
---------------------------------
Attachment: PHOENIX-116.patch
Patch to use a custom base value (3000) for the type constant for Phoenix typed
arrays.
> Phoenix array integer types overlap with existing java.sql.Types
> ----------------------------------------------------------------
>
> Key: PHOENIX-116
> URL: https://issues.apache.org/jira/browse/PHOENIX-116
> Project: Phoenix
> Issue Type: Bug
> Reporter: Gabriel Reid
> Attachments: PHOENIX-116.patch
>
>
> The type value returned for Phoenix typed arrays are currently created by
> taking the sum of java.sql.Types.ARRAY and the sql type of the element type.
> However, this causes some collisions with existing java.sql.Types values.
> For example, the SQL type value for BINARY_ARRAY is the value of Types.ARRAY
> + Types.BINARY, which is 2003 + (-2), or 2001. 2001 is an existing constant
> for java.sql.Types.DISTINCT.
> There is also a collision with java.sql.Types.BLOB and
> PDataTypes.CHAR_ARRAY.getSqlType().
> Next to the fact that these collisions occur, there's probably not much
> reason to base the SQL types for typed arrays on the java.sql.Types.ARRAY
> constant, as I assume that external tooling won't be aware of this convention
> anyhow.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
