Traversal of a OneToMany relationship returns an empty list when
InheritanceType.JOINED or SINGLE_TABLE is used.
----------------------------------------------------------------------------------------------------------------
Key: OPENJPA-2132
URL: https://issues.apache.org/jira/browse/OPENJPA-2132
Project: OpenJPA
Issue Type: Bug
Components: query
Affects Versions: 2.1.1, 2.0.1, 2.2.0
Reporter: Heath Thomann
Assignee: Heath Thomann
Attachments: OneManyJoinableTest.test
I will include a test, named 'OneManyJoinableTest.test' which recreates the
issue of this JIRA. Basically though, the test consists of a parent class
defined with '@Inheritance(strategy=InheritanceType.JOINED)'. One of the
subclasses in the hierarchy contains a (bidirectional) OneToMany relationship.
When traversing the ManyToOne side of the relations, all works well. But when
traversing the OneToMany side an empty list is returned. When running the
test, it can be seen that OpenJPA generate incorrect SQL, as follows:
SELECT t1.id, t0.id, t2.id, t3.id, t1.name FROM UMLType t0, UMLNamed t1,
UMLClass t2, UMLPrimitiveType t3 WHERE t0.OWNERPACKAGE_ID = ? AND t2.id IS NULL
AND t3.id IS NULL AND t0.id = t1.id AND t0.id = t2.id(+) AND t0.id = t3.id(+)
Note that the 't2.id IS NULL AND t3.id IS NULL' seems suspect.
This same test passes on OpenJPA 1.2.x but fails on OpenJPA 2.0.x on wards.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
