[
https://issues.apache.org/jira/browse/JDO-435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12564683#action_12564683
]
Andy Jefferson 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.
Hi Craig,
that particular SQL generation is a bug in JPOX but it isn't one that will be
fixed before JPOX 1.2.0-final (estimated early March), and really requires
Eriks' query refactoring as a prerequisite (which won't be done for a while I'd
guess), so I suggest you raise an issue but for "Maintenance release 2", and
don't add the related test to SVN til after "Maintenance release 1" is out. Thx
> 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.
