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 : instanceof can omit necessary join in some relations

Created: 13/Mar/10 02:48 PM   Updated: 03/Apr/10 10:44 AM   Resolved: 14/Mar/10 09:52 AM
Component/s: Queries
Affects Version/s: 2.0.0.release, 2.0.1, 2.0.2
Fix Version/s: 2.1.0.m1

 Description  « Hide
When we have a 1-1 relation and the FK is at the candidate side and the query is

SELECT FROM mydomain.MyClass WHERE relatedField instanceof "mydomain.MyOtherClass"

this creates SQL for "relatedField" without the join to the other table.

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 14/Mar/10 09:52 AM
SVN trunk has been changed so that when evaluating the PrimaryExpression of an "instanceof" to pass in the operator on which it is used, and hence to force a join to the table of that PrimaryExpression. TCK test passes as a result.

SVN branches/2.0 doesn't have this.