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 2008/01/01 15:57:43 UTC
[jira] Commented: (JDO-435) Query with projected variables returns
duplicates and extra results that do not satisfy filter
[ 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.