We encountered a bug in Derby with JDO-310 where the variable field was mapped to many-to-many relationships. We should add new tests for the next release cycle to test:
SELECT e FROM Department WHERE deptid==2 & employees.contains(e) VARIABLES Employee e
SELECT distinct e FROM Department WHERE deptid==2 & employees.contains(e) VARIABLES Employee e
SELECT p FROM Employee WHERE projects.contains(p) & p.name == 'orange' VARIABLES Project p
SELECT distinct p FROM Employee WHERE projects.contains(p) & p.name == 'orange' VARIABLES Project p
Description
We encountered a bug in Derby with JDO-310 where the variable field was mapped to many-to-many relationships. We should add new tests for the next release cycle to test:
SELECT e FROM Department WHERE deptid==2 & employees.contains(e) VARIABLES Employee e
SELECT distinct e FROM Department WHERE deptid==2 & employees.contains(e) VARIABLES Employee e
SELECT p FROM Employee WHERE projects.contains(p) & p.name == 'orange' VARIABLES Project p
SELECT distinct p FROM Employee WHERE projects.contains(p) & p.name == 'orange' VARIABLES Project p
JDO-344 Add new tests for projection of variables and fields of variables
where the projected variables are mapped to one-to-many and many-to-many
relationships.
Test
Resolved
Minor
Add new tests for query projection of variables where the field is mapped to one-to-many and many-to-many relationships
Sending src/java/org/apache/jdo/tck/query/result/VariableInResult.java
Transmitting file data .
Committed revision 463364.