Community
Participate
Working Groups
The following JPQL queries seem to be valid JPQL, but do not work as expected, select e from Employee e where e.id in (select e.id from Employee x) -> not yet implemented select e from Employee e where e in (select x from Employee x) or, select e from Employee e where e.address in (select x.address from Employee x) -> bad SQL, missing expression select e from Employee e where e.address.id in (select a.id from e.address a) or, select e from Employee e where e.address.id in (select e.address.id from Address a where a.id = e.address.id) -> works, but extra joins used select a from Address a where exists (select e.firstName from Employee e where e.address = a) -> translates 1 instead of firstName? select a from Address a where exists (select e.address from Employee e where e.address = a) -> translates to 1, and joins address twice
Setting target and priority. See the following page for details of what this means: http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines
>See possibly related bug# 318225
Problems with "select e from Employee e where e in (select x from Employee x)" and "select e from Employee e where e.address in (select x.address from Employee x)" are described in bug 314025
These are mainly ok now except for, select e from Employee e where e.address.id in (select a.id from e.address a) This still joins the Employee table twice.
Fixed in Hermes Fixes everything but element collection, which still must join twice.
Fixed in 2.4
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
