db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Craig Russell (JIRA)" <j...@apache.org>
Subject [jira] Commented: (JDO-435) Query with projected variables returns duplicates and extra results that do not satisfy filter
Date Sun, 05 Nov 2006 06:20:17 GMT
    [ http://issues.apache.org/jira/browse/JDO-435?page=comments#action_12447235 ] 
            
Craig Russell commented on JDO-435:
-----------------------------------

With the latest JPOX SNAPSHOT from 4-Nov-2006 I still get one exception from this test:

testMultipleProjection(org.apache.jdo.tck.query.result.VariableInResult)junit.framework.AssertionFailedError:
Assertion A14.6.9-3 (VariableInResult) failed: 
    [java] Wrong query result: 
    [java] query: SELECT e, p FROM org.apache.jdo.tck.pc.company.Department WHERE employees.contains(e)
&& e.projects.contains(p) VARIABLES Employee e; Project p 
    [java] expected: java.util.ArrayList of size 7
    [java] [
[FullTimeEmployee(1, emp1Last, emp1First, born 9/Jun/1970, phone {work=123456-1, home=1111},
hired 31/Dec/1998, weeklyhours 40.0, $20000.0), Project(1, name orange, budget 2500000.99)],

[FullTimeEmployee(2, emp2Last, emp2First, born 21/Dec/1975, phone {work=123456-2, home=2222},
hired 30/Jun/2003, weeklyhours 40.0, $10000.0), Project(1, name orange, budget 2500000.99)],

[PartTimeEmployee(3, emp3Last, emp3First, born 4/Sep/1972, phone {work=123456-3, home=3333},
hired 14/Aug/2002, weeklyhours 19.0, $15.0), Project(1, name orange, budget 2500000.99)],

[FullTimeEmployee(2, emp2Last, emp2First, born 21/Dec/1975, phone {work=123456-2, home=2222},
hired 30/Jun/2003, weeklyhours 40.0, $10000.0), Project(2, name blue, budget 50000.00)], 
[PartTimeEmployee(3, emp3Last, emp3First, born 4/Sep/1972, phone {work=123456-3, home=3333},
hired 14/Aug/2002, weeklyhours 19.0, $15.0), Project(2, name blue, budget 50000.00)], 
[PartTimeEmployee(4, emp4Last, emp4First, born 5/Sep/1973, phone {work=124456-3, home=3343},
hired 14/Apr/2001, weeklyhours 0.0, $13.0), Project(3, name green, budget 2000.99)], 
[FullTimeEmployee(5, emp5Last, emp5First, born 4/Jul/1962, phone {work=126456-3, home=3363},
hired 14/Aug/1998, weeklyhours 0.0, $45000.0), Project(3, name green, budget 2000.99)]]
    [java] got:      java.util.ArrayList of size 5
    [java] [
[FullTimeEmployee(5, emp5Last, emp5First, born 4/Jul/1962, phone {work=126456-3, home=3363},
hired 14/Aug/1998, weeklyhours 0.0, $45000.0), Project(3, name green, budget 2000.99)], 
[PartTimeEmployee(4, emp4Last, emp4First, born 5/Sep/1973, phone {work=124456-3, home=3343},
hired 14/Apr/2001, weeklyhours 0.0, $13.0), Project(3, name green, budget 2000.99)], 
[PartTimeEmployee(3, emp3Last, emp3First, born 4/Sep/1972, phone {work=123456-3, home=3333},
hired 14/Aug/2002, weeklyhours 19.0, $15.0), Project(1, name orange, budget 2500000.99)],

[FullTimeEmployee(1, emp1Last, emp1First, born 9/Jun/1970, phone {work=123456-1, home=1111},
hired 31/Dec/1998, weeklyhours 40.0, $20000.0), Project(1, name orange, budget 2500000.99)],

[FullTimeEmployee(2, emp2Last, emp2First, born 21/Dec/1975, phone {work=123456-2, home=2222},
hired 30/Jun/2003, weeklyhours 40.0, $10000.0), Project(1, name orange, budget 2500000.99)]]


> 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