You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Catalina Wei (JIRA)" <ji...@apache.org> on 2009/05/19 00:31:45 UTC
[jira] Resolved: (OPENJPA-1094) JPA2 Query support for KEY appear
in subquery
[ https://issues.apache.org/jira/browse/OPENJPA-1094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Catalina Wei resolved OPENJPA-1094.
-----------------------------------
Resolution: Fixed
Fix Version/s: 2.0.0
JPQ2 query updates to allow KEY appear in subquery.
Code checked in under r776117.
Sample queries:
"select i from Item1 i" +
" where ?1 = any " +
" (select KEY(e) from Item1 i, in(i.images) e) " +
" order by i",
"select i from Item2 i" +
" where ?1 = any " +
" (select KEY(e) from Item2 i, in(i.images) e) " +
" order by i",
"select i from Item3 i" +
" where ?1 = any " +
" (select KEY(e) from Item3 i, in(i.images) e) " +
" order by i",
"select i from Item1 i" +
" where exists " +
" (select e from Item1 i, in(i.images) e" +
" where ?1 = KEY(e)) " +
" order by i",
"select i from Item2 i" +
" where exists " +
" (select e from Item2 i, in(i.images) e" +
" where ?1 = KEY(e)) " +
" order by i",
"select i from Item3 i" +
" where exists " +
" (select e from Item3 i, in(i.images) e" +
" where ?1 = KEY(e)) " +
" order by i",
> JPA2 Query support for KEY appear in subquery
> ---------------------------------------------
>
> Key: OPENJPA-1094
> URL: https://issues.apache.org/jira/browse/OPENJPA-1094
> Project: OpenJPA
> Issue Type: Sub-task
> Components: query
> Affects Versions: 2.0.0
> Reporter: Catalina Wei
> Assignee: Catalina Wei
> Fix For: 2.0.0
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.