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: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 0
Watchers: 0

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

JDOQL2 : Support for subqueries using parameters linking back to main query, and navigating through relations can generate invalid SQL

Created: 27/Apr/10 01:11 PM   Updated: 24/May/10 03:43 PM   Resolved: 01/May/10 08:30 AM
Component/s: Queries
Affects Version/s: 2.1.0.m1, 2.1.0.m2
Fix Version/s: 2.1.0.m3

 Description  « Hide
If we have a subquery with a from clause as

sub_this.manager == this.manager

this can generate invalid SQL due to knowing where to add the join for the "this" (main query) to get to the manager

Andy Jefferson added a comment - 01/May/10 08:30 AM
SVN trunk now adds any required join to the statement containing the left side of the expression so, in this case, the "this.manager" adds a join in the parent statement.

Andy Jefferson made changes - 01/May/10 08:30 AM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.1.0.m3 [ 10943 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 24/May/10 03:43 PM
Status Resolved [ 5 ] Closed [ 6 ]