[
https://issues.apache.org/jira/browse/CALCITE-1050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15964919#comment-15964919
]
Maryann Xue edited comment on CALCITE-1050 at 4/11/17 8:29 PM:
---------------------------------------------------------------
Not sure, but I think other than {{createArrayOf}}, {{setArray}}, and
{{getArray}} are enough for most test cases in Phoenix. And they have already
been implemented in the PR, thanks! One thing is that {{ResultSet.getString}}
is also used on array fields in Phoenix tests to get the "toString" value of an
array, I am not sure if it's SQL standard or if Avatica supports it that way.
[~jamestaylor], do you have any comment on this point?
Another problem I found by running the Phoenix array tests was that literal
string array values were taken as CHAR ARRAY type and could not be inserted
into VARCHAR ARRAY columns. I think this is a Calcite issue and I'll open a
separate JIRA.
was (Author: maryannxue):
Not sure, but I think other than {{createArrayOf}}, {{setArray}}, and
{{getArray}} are enough for most test cases in Phoenix. One thing is that
{{ResultSet.getString}} is used on array fields in Phoenix tests to get the
"toString" value of an array, I am not sure if it's SQL standard or if Avatica
supports it that way. [~jamestaylor], do you have any comment on this point?
Another problem I found by running the Phoenix array tests was that literal
string array values were taken as CHAR ARRAY type and could not be inserted
into VARCHAR ARRAY columns. I think this is a Calcite issue and I'll open a
separate JIRA.
> Avatica can't serialize java.sql.Array
> --------------------------------------
>
> Key: CALCITE-1050
> URL: https://issues.apache.org/jira/browse/CALCITE-1050
> Project: Calcite
> Issue Type: Improvement
> Components: avatica
> Affects Versions: 1.5.0
> Reporter: Lukas Lalinsky
> Assignee: Josh Elser
> Fix For: avatica-1.10.0
>
>
> As far as I can see, there is no way to serialize arrays in the Avatica RPC.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
