Issue Details (XML | Word | Printable)

Key: NUCRDBMS-375
Type: Bug Bug
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 : 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

Sort Order: Ascending order - Click to sort in descending order
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.