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 "Andy Jefferson (JIRA)" <ji...@apache.org> on 2019/03/15 07:10:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16793391#comment-16793391 ]
Andy Jefferson commented on JDO-778:
------------------------------------
No objections to these methods. If wanting these methods in DataNucleus the simplest way is to provide a PR to [https://github.com/datanucleus/datanucleus-api-jdo]
> 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
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)