[
https://issues.apache.org/jira/browse/JDO-778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Bouschen updated JDO-778:
---------------------------------
Description:
I propose to add the following overloaded subquery methods to support
correlated subqueries using a relationship field of the from clause of the
subquery, e.g.
{{select firstname from org.apache.jdo.tck.pc.company.Employee }}
{{ where this.weeklyhours > }}
{{ (select AVG(e.weeklyhours) from this.department.employees e where
e.manager == this.manager)}}
{{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}>
subquery(CollectionExpression<Collection<{color:#20999d}E{color}>,
{color:#20999d}E{color}> candidateCollection, String candidateAlias);}}
{{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}>
subquery(ListExpression<List<{color:#20999d}E{color}>, {color:#20999d}E{color}>
candidateList, String candidateAlias);}}
{{<{color:#20999d}K{color}, {color:#20999d}V{color}>
JDOQLTypedSubquery<Map.Entry<{color:#20999d}K{color}, {color:#20999d}V{color}>>
subquery(MapExpression<Map<{color:#20999d}K{color}, {color:#20999d}V{color}>,
{color:#20999d}K{color}, {color:#20999d}V{color}> candidateMap, String
candidateAlias);}}
was:
I propose to add the following overloaded subquery methods to support
correlated subqueries using a relationship field of the from clause of the
subquery, e.g.
select firstname from org.apache.jdo.tck.pc.company.Employee
where this.weeklyhours >
(select AVG(e.weeklyhours) from this.department.employees e where e.manager
== this.manager)
{{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}>
subquery(CollectionExpression<Collection<{color:#20999d}E{color}>,
{color:#20999d}E{color}> candidateCollection, String candidateAlias);}}
{{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}>
subquery(ListExpression<List<{color:#20999d}E{color}>, {color:#20999d}E{color}>
candidateList, String candidateAlias);}}
{{<{color:#20999d}K{color}, {color:#20999d}V{color}>
JDOQLTypedSubquery<Map.Entry<{color:#20999d}K{color}, {color:#20999d}V{color}>>
subquery(MapExpression<Map<{color:#20999d}K{color}, {color:#20999d}V{color}>,
{color:#20999d}K{color}, {color:#20999d}V{color}> candidateMap, String
candidateAlias);}}
> Adding overloaded methods to JDOQLTypedQuery to create a correlated subquery
> -----------------------------------------------------------------------------
>
> Key: JDO-778
> URL: https://issues.apache.org/jira/browse/JDO-778
> Project: JDO
> Issue Type: Improvement
> Components: api
> Affects Versions: JDO 3.1
> Reporter: Michael Bouschen
> Priority: Critical
> Fix For: JDO 3.2
>
>
> I propose to add the following overloaded subquery methods to support
> correlated subqueries using a relationship field of the from clause of the
> subquery, e.g.
> {{select firstname from org.apache.jdo.tck.pc.company.Employee }}
> {{ where this.weeklyhours > }}
> {{ (select AVG(e.weeklyhours) from this.department.employees e where
> e.manager == this.manager)}}
> {{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}>
> subquery(CollectionExpression<Collection<{color:#20999d}E{color}>,
> {color:#20999d}E{color}> candidateCollection, String candidateAlias);}}
> {{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}>
> subquery(ListExpression<List<{color:#20999d}E{color}>,
> {color:#20999d}E{color}> candidateList, String candidateAlias);}}
> {{<{color:#20999d}K{color}, {color:#20999d}V{color}>
> JDOQLTypedSubquery<Map.Entry<{color:#20999d}K{color},
> {color:#20999d}V{color}>> subquery(MapExpression<Map<{color:#20999d}K{color},
> {color:#20999d}V{color}>, {color:#20999d}K{color}, {color:#20999d}V{color}>
> candidateMap, String candidateAlias);}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
