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 ]