[ https://issues.apache.org/jira/browse/JDO-435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12555202 ]
Andy Jefferson commented on JDO-435: ------------------------------------ In case someone has time to look at this JDOQL Query SELECT e,p FROM org.apache.jdo.tck.pc.company.Department WHERE employees.contains(e) && e.projects.contains(p) VARIABLES Employee e; Project p SQL invoked SELECT UNBOUND_E.PERSONID, UNBOUND_P.PROJID FROM applicationidentity0.DEPARTMENTS THIS, applicationidentity0.PERSONS UNBOUND_E, applicationidentity0.PROJECTS UNBOUND_P WHERE EXISTS ( SELECT 1 FROM applicationidentity0.PERSONS THIS_EMPLOYEES_E WHERE EXISTS ( SELECT 1 FROM applicationidentity0.PROJECT_MEMBER THIS_EMPLOYEES_E_PROJECTS_P WHERE THIS_EMPLOYEES_E_PROJECTS_P."MEMBER" = THIS_EMPLOYEES_E.PERSONID AND THIS_EMPLOYEES_E_PROJECTS_P."MEMBER" = THIS_EMPLOYEES_E.PERSONID AND THIS_EMPLOYEES_E.DEPARTMENT = THIS.ID AND THIS_EMPLOYEES_E.DEPARTMENT = THIS.ID AND UNBOUND_P.PROJID = THIS_EMPLOYEES_E_PROJECTS_P.PROJID AND UNBOUND_E.PERSONID = THIS_EMPLOYEES_E.PERSONID) ) > Query with projected variables returns duplicates and extra results that do > not satisfy filter > ---------------------------------------------------------------------------------------------- > > Key: JDO-435 > URL: https://issues.apache.org/jira/browse/JDO-435 > Project: JDO > Issue Type: Bug > Components: tck2 > Affects Versions: JDO 2 final > Reporter: Craig Russell > Assignee: Erik Bengtson > Fix For: JDO 2 maintenance release 1 > > > org.apache.jdo.tck.query.result.VariableInResult fails with several queries > that return variables that are mapped to one-many and many-many > relationships. In some cases, the filter is not satisfied. In others, > duplicate results are returned. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.