Hi Andy,
This is good news. Congratulations.
Craig
On Mar 19, 2010, at 11:08 AM, Andy Jefferson (JIRA) wrote:
[ https://issues.apache.org/jira/browse/JDO-573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12847486
#action_12847486 ]
Andy Jefferson commented on JDO-573:
------------------------------------
For reference, DataNucleus 2.1.x passes this test, using the
replacement JDOQL implementation.
Since DN 2.1 is not yet released this can wait until after JDO2.3
release for enabling of these excluded tests.
RI creates bad SQL for navigational queries
-------------------------------------------
Key: JDO-573
URL: https://issues.apache.org/jira/browse/JDO-573
Project: JDO
Issue Type: Bug
Components: tck2, tck2-legacy
Affects Versions: JDO 2 maintenance release 1, JDO 2 maintenance
release 2
Reporter: Craig L Russell
Assignee: Andy Jefferson
The test org.apache.jdo.tck.query.result.VariableInResultNavigation
fails with incorrect SQL generated.
[java] 1)
testNavigationWithThisAndCompany
(org
.apache
.jdo
.tck
.query.result.VariableInResultNavigation)javax.jdo.JDOException:
JDOException thrown while executing query:
[java] SELECT this, e, p FROM
org.apache.jdo.tck.pc.company.Company WHERE name == "Sun
Microsystems, Inc." && departments.contains(d) &&
d.employees.contains(e) && e.projects.contains(p) VARIABLES
Department d; Employee e; Project p
[java] at
org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1314)
[java] at
org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1135)
[java] at
org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:
1071)
[java] at
org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:
1051)
[java] at
org
.apache
.jdo
.tck
.query
.result
.VariableInResultNavigation
.testNavigationWithThisAndCompany(VariableInResultNavigation.java:
251)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
[java] at
sun
.reflect
.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at
sun
.reflect
.DelegatingMethodAccessorImpl
.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:254)
[java] at
org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:
108)
[java] at
org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:
148)
[java] at
org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:
123)
[java] NestedThrowablesStackTrace:
[java] javax.jdo.JDODataStoreException: [JPOX-042007] 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..
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Craig L Russell
Architect, Oracle
http://db.apache.org/jdo
408 276-5638 mailto:[email protected]
P.S. A good JDO? O, Gasp!
