[
https://issues.apache.org/jira/browse/JDO-435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12563296#action_12563296
]
Craig Russell commented on JDO-435:
-----------------------------------
> Column 'THIS_DEPARTMENTS_D_EMPLOYEES_E.DATASTORE_IDENTITY' is either not in
> any table in the FROM list or ...
This appears to be a bug in the JPOX SQL generation. The alias
THIS_DEPARTMENTS_D_EMPLOYEES_E is in the FROM clause of the nested WHERE EXISTS
but this clause is terminated by "))" before the final AND EXISTS clause.
I'll raise another JIRA for this issue, since it appears to be unrelated to the
current Derby issue.
> 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
> 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.
