You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2014/10/10 04:03:33 UTC
[jira] [Updated] (PHOENIX-1332) Support correlated subqueries in
comparison with ANY/SOME/ALL
[ https://issues.apache.org/jira/browse/PHOENIX-1332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maryann Xue updated PHOENIX-1332:
---------------------------------
Attachment: 1332.patch
With some minor fixes for ArrayConstructorExpression
> Support correlated subqueries in comparison with ANY/SOME/ALL
> -------------------------------------------------------------
>
> Key: PHOENIX-1332
> URL: https://issues.apache.org/jira/browse/PHOENIX-1332
> Project: Phoenix
> Issue Type: Sub-task
> Affects Versions: 3.0.0, 4.0.0, 5.0.0
> Reporter: Maryann Xue
> Assignee: Maryann Xue
> Fix For: 3.0.0, 4.0.0, 5.0.0
>
> Attachments: 1332.patch
>
>
> Support grammar like:
> select * from OrderTable o where quantity >= ALL(select quantity from OrderTable where item_id = o.item_id)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)