[OPENJPA-1893] Missing join clause in query with collection-table with two join-columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.1
• Fix Version/s: 2.1.0
• Assignee: Fay Wang
• Reporter: Patrice DUROUX
• Created: 22/Nov/10 16:33
• Updated: 22/Nov/10 21:50
• Resolved: 22/Nov/10 21:50

Description

Considering the following mapping:

<entity class="Feature">
<table name="features" />
<attributes>
<embedded-id name="id" />
<element-collection name="attributes">
<collection-table name="qualifiers" />
</element-collection>
</attributes>
</entity>

Without specifying any JoinColumn element in the CollectionTable element, I got the query:

(...) INNER JOIN qualifiers t3 ON t0.index = t3.FEATURE_INDEX AND t0.oid = t3.FEATURE_OID (...)

but changing the mapping by:
<collection-table name="qualifiers">
<join-column name="oid" />
<join-column name="index" />
</collection-table>

I got:

(...) INNER JOIN qualifiers t3 ON t0.index = t3.index (...)

where is missing the first JoinColumn.