[
https://issues.apache.org/jira/browse/JDO-435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Craig Russell reassigned JDO-435:
---------------------------------
Assignee: Andy Jefferson (was: Craig Russell)
The latest release of Derby, 10.4.1.3, corrects the failure. But additional
testing reveals that DataNucleus now generates incorrect SQL for some
navigation projection queries.
The error is [java] javax.jdo.JDODataStoreException: Error executing JDOQL
query "SELECT
THIS.DATASTORE_IDENTITY,UNBOUND_E.DATASTORE_IDENTITY,UNBOUND_P.DATASTORE_IDENTITY
FROM datastoreidentity0.COMPANIES THIS , datastoreidentity0.PERSONS UNBOUND_E
, datastoreidentity0.PROJECTS UNBOUND_P WHERE EXISTS (SELECT 1 FROM
datastoreidentity0.DEPARTMENTS THIS_DEPARTMENTS_D WHERE EXISTS (SELECT 1 FROM
datastoreidentity0.PERSONS THIS_DEPARTMENTS_D_EMPLOYEES_E WHERE
THIS_DEPARTMENTS_D_EMPLOYEES_E.DEPARTMENT =
THIS_DEPARTMENTS_D.DATASTORE_IDENTITY AND THIS_DEPARTMENTS_D.COMPANYID =
THIS.DATASTORE_IDENTITY AND THIS."NAME" = ?)) AND EXISTS (SELECT 1 FROM
datastoreidentity0.PROJECT_MEMBER THIS_DEPARTMENTS_D_EMPLOYEES_E_PROJECTS_P
WHERE THIS_DEPARTMENTS_D_EMPLOYEES_E_PROJECTS_P."MEMBER" =
THIS_DEPARTMENTS_D_EMPLOYEES_E.DATASTORE_IDENTITY AND
UNBOUND_P.DATASTORE_IDENTITY =
THIS_DEPARTMENTS_D_EMPLOYEES_E_PROJECTS_P.PROJID)" : Column
'THIS_DEPARTMENTS_D_EMPLOYEES_E.DATASTORE_IDENTITY' is either not in any table
in the FROM list or appears within a join specification and is outside the
scope of the join specification or appears in a HAVING clause and is not in the
GROUP BY list. If this is a CREATE or ALTER TABLE statement then
'THIS_DEPARTMENTS_D_EMPLOYEES_E.DATASTORE_IDENTITY' is not a column in the
target table..
> 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: Andy Jefferson
> Fix For: JDO 2 maintenance release 2
>
>
> 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.
