db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Jefferson (JIRA)" <j...@apache.org>
Subject [jira] Commented: (JDO-435) Query with projected variables returns duplicates and extra results that do not satisfy filter
Date Fri, 01 Feb 2008 08:37:08 GMT

    [ 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.


Mime
View raw message