Issue Details (XML | Word | Printable)

Key: NUCRDBMS-317
Type: Task Task
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

JDOQL2 Collection.contains of variable can find incorrect table (in primary query) when looking for field on variable

Created: 02/Mar/10 01:04 PM   Updated: 17/Mar/10 08:52 PM   Resolved: 02/Mar/10 01:21 PM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 2.0.2


 Description  « Hide
When we have a query like
SELECT FROM org.jpox.samples.models.company.Manager
WHERE subordinates.contains(emp1) && (emp1.lastName == "WakesUp" || emp1.lastName == "WakesUp2")

when it looks for the table/mapping of "emp1.lastName" it is finding the table in the primary query, whilst "emp1" is in a subquery. Should be looking in the subquery and add joins there as required

Andy Jefferson made changes - 02/Mar/10 01:04 PM
Field Original Value New Value
Assignee Andy Jefferson [ andy ]
Andy Jefferson made changes - 02/Mar/10 01:05 PM
Summary Collection.contains of variable can find incorrect table (in primary query) when looking for field on variable JDOQL2 Collection.contains of variable can find incorrect table (in primary query) when looking for field on variable
Fix Version/s 2.1.0.release [ 10832 ]
Andy Jefferson added a comment - 02/Mar/10 01:21 PM
SVN trunk fixes this also

Andy Jefferson made changes - 02/Mar/10 01:21 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.0.2 [ 10870 ]
Fix Version/s 2.1.0.release [ 10832 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 17/Mar/10 08:52 PM
Status Resolved [ 5 ] Closed [ 6 ]