DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Unassigned
Reporter: Andy Jefferson
Votes: 0
Watchers: 0

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

Query that uses Collection.contains and needs subquery and is using FK collection adds join to wrong statement

Created: 14/May/12 05:35 PM   Updated: 14/May/12 07:45 PM   Resolved: 14/May/12 05:35 PM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 3.1.0.m4

 Description  « Hide
When we have something like
SELECT ... FROM ... WHERE ... AND coll.contains(elem) AND ...
the "elem" is unbound so tries to do a restrict on the correct element table.
Should add the join to the subquery statement, but is trying to add it to the outer statement

Andy Jefferson added a comment - 14/May/12 05:35 PM
SVN trunk fixes this

Andy Jefferson made changes - 14/May/12 05:35 PM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 14/May/12 07:45 PM
Status Resolved [ 5 ] Closed [ 6 ]