db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Erik Bengtson (JIRA)" <j...@apache.org>
Subject [jira] Commented: (JDO-435) Query with projected variables returns duplicates and extra results that do not satisfy filter
Date Sat, 14 Oct 2006 14:40:35 GMT
    [ http://issues.apache.org/jira/browse/JDO-435?page=comments#action_12442297 ] 
            
Erik Bengtson commented on JDO-435:
-----------------------------------

Status with JPOX CVS:
RUN VariableInResult.testNavigation	
RUN VariableInResult.testDistinctNavigation	
RUN VariableInResult.testDistinctNoNavigation	
RUN VariableInResult.testNoNavigation	
RUN VariableInResult.testMultipleProjectionWithConstraints	   FAILURE
RUN VariableInResult.testMultipleProjection	   FAILURE
RUN VariableInResult.testProjectionWithConstraints	

The checkQueryResultWithoutOrder method does not like the results for testMultipleProjectionWithConstrains
but the order is not important and the test should pass.

2) testMultipleProjectionWithConstraints(org.apache.jdo.tck.query.result.VariableInResult)junit.framework.AssertionFailedError:
Assertion A14.6.9-3 (VariableInResult) failed: 
Wrong query result: 
query: SELECT e, p FROM org.apache.jdo.tck.pc.company.Department WHERE employees.contains(e)
&& e.projects.contains(p)&& p.name == 'orange' VARIABLES Employee e; Project
p 
expected: [[
FullTimeEmployee(1, emp1Last, emp1First, born 10/Jun/1970, phone {work=123456-1, home=1111},
hired 1/Jan/1999, weeklyhours 40.0, $20000.0), Project(1, name orange, budget 2500000.99)],
[
FullTimeEmployee(2, emp2Last, emp2First, born 22/Dec/1975, phone {work=123456-2, home=2222},
hired 1/Jul/2003, weeklyhours 40.0, $10000.0), Project(1, name orange, budget 2500000.99)],
[
PartTimeEmployee(3, emp3Last, emp3First, born 5/Sep/1972, phone {work=123456-3, home=3333},
hired 15/Aug/2002, weeklyhours 19.0, $15.0), Project(1, name orange, budget 2500000.99)]]
got:      [[
PartTimeEmployee(3, emp3Last, emp3First, born 5/Sep/1972, phone {work=123456-3, home=3333},
hired 15/Aug/2002, weeklyhours 19.0, $15.0), Project(1, name orange, budget 2500000.99)],
[
FullTimeEmployee(1, emp1Last, emp1First, born 10/Jun/1970, phone {work=123456-1, home=1111},
hired 1/Jan/1999, weeklyhours 40.0, $20000.0), Project(1, name orange, budget 2500000.99)],
[
FullTimeEmployee(2, emp2Last, emp2First, born 22/Dec/1975, phone {work=123456-2, home=2222},
hired 1/Jul/2003, weeklyhours 40.0, $10000.0), Project(1, name orange, budget 2500000.99)]]
	at org.apache.jdo.tck.JDO_Test.fail(JDO_Test.java:638)
	at org.apache.jdo.tck.query.QueryTest.queryFailed(QueryTest.java:508)
	at org.apache.jdo.tck.query.QueryTest.checkQueryResultWithoutOrder(QueryTest.java:540)
	at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1229)
	at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1069)
	at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1006)
	at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:986)
	at org.apache.jdo.tck.query.result.VariableInResult.testMultipleProjectionWithConstraints(VariableInResult.java:253)


> Query with projected variables returns duplicates and extra results that do not satisfy
filter
> ----------------------------------------------------------------------------------------------
>
>                 Key: JDO-435
>                 URL: http://issues.apache.org/jira/browse/JDO-435
>             Project: JDO
>          Issue Type: Bug
>          Components: tck20
>    Affects Versions: JDO 2 final
>            Reporter: Craig Russell
>         Assigned To: Erik Bengtson
>             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.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message