You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by "Michael Bouschen (JIRA)" <ji...@apache.org> on 2019/03/06 17:50:00 UTC
[jira] [Updated] (JDO-778) Adding overloaded methods to
JDOQLTypedQuery to create a correlated subquery
[ 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)