[OPENJPA-2475] A query with LEFT FETCH JOIN returns incorrect results.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1.1, 2.2.2, 2.2.1.1, 2.3.0, 2.4.0
• Fix Version/s: 2.1.2, 2.2.1.1, 2.2.3, 2.4.0
• Component/s: query
• Assignee: Heath Thomann
• Reporter: Heath Thomann
• Created: 30/Jan/14 18:30
• Updated: 21/Sep/16 20:17
• Resolved: 05/May/14 17:53

Description

Take the following two entities:

@Entity
public class DepartmentTest{
@Id
private String primaryKey;

@OrderBy("name")
@OneToMany(mappedBy = "departmentTest")
private Set<PersonTest> persons = new HashSet<PersonTest>();
...........

@Entity
public class PersonTest {
@Id
private String primaryKey;

@ManyToOne
@ForeignKey
private DepartmentTest departmentTest;

private String name;
.....

With these entities, take this JPQL:

"SELECT DISTINCT dept FROM DepartmentTest dept LEFT JOIN FETCH dept.persons";

Depending on the data in the database (the order is important, see the provided test), this query can return a results set where some of the 'persons' are missing.

Thanks,

Heath Thomann