openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catalina Wei (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (OPENJPA-1094) JPA2 Query support for KEY appear in subquery
Date Mon, 18 May 2009 22:31:45 GMT

     [ 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.


Mime
View raw message