[
https://issues.apache.org/jira/browse/PHOENIX-952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14003600#comment-14003600
]
ramkrishna.s.vasudevan commented on PHOENIX-952:
------------------------------------------------
I have tried out a approach so that both ANY/ALL can be used as expression.
Using as Function expression does not allow the ALL syntax to be used.
Here again using new type ComparisonExpression as before.
bq.What are the restrictions around where an ANY versus ALL may be used? Is it
only allowed in a comparison expression?
Am not sure. The link above says about comparison expression only.
One more thing is that only after the comparison expression gets both LHS and
RHS we could do the evaluate of that comparison expression and here the
evaluate is not the same as the usual comparisonExpression. Regarding the
comment to move the last few lines to utiltiy method, I have already moved the
positioning code to a static method.
> Support ANY and ALL built-ins for ARRAYs
> ----------------------------------------
>
> Key: PHOENIX-952
> URL: https://issues.apache.org/jira/browse/PHOENIX-952
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0, 4.0.0
> Reporter: James Taylor
> Fix For: 3.1, 4.1
>
> Attachments: Phoenix-932_1.patch, Phoenix-932_2.patch
>
>
> There's currently no good way to search array elements. We should support the
> ANY and ALL built-ins for our ARRAY type like Postgres does:
> http://www.postgresql.org/docs/9.1/static/arrays.html#ARRAYS-SEARCHING
--
This message was sent by Atlassian JIRA
(v6.2#6252)
