Message Title

Apanasionak Sviataslau created an issue

Issue Type:	Bug
Affects Versions:	5.2.17, 5.4.3
Assignee:	Unassigned
Components:	hibernate-core
Created:	09/Jul/2019 01:20 AM
Environment:	h2, mariadb
Labels:	hibernate
Priority:	Major
Reporter:	Apanasionak Sviataslau

Given following entities:

 
                                                                @Entity
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;


    @OneToOne(fetch = FetchType.LAZY)
    @JoinColumn
    private Chair chair;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Chair getChair() {
        return chair;
    }

    public void setChair(Chair chair) {
        this.chair = chair;
    }
}
 
                                                            

 
                                                                @Entity
public class Chair {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @OneToOne( fetch = FetchType.LAZY, mappedBy = "chair")
    private User user;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn
    private Room room;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    public Room getRoom() {
        return room;
    }

    public void setRoom(Room room) {
        this.room = room;
    }
}

 
                                                            

 
                                                                @Entity
public class Chair {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @OneToOne( fetch = FetchType.LAZY, mappedBy = "chair")
    private User user;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn
    private Room room;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    public Room getRoom() {
        return room;
    }

    public void setRoom(Room room) {
        this.room = room;
    }
}
 
                                                            

When I try to retrieve all user and sort by room name, I get only users which have chair and room, but users without chair and room are not retrieved:

 
                                                                //work wrong, cross joins
		Order order2 =  cb.asc(root.get("chair").get("room").get("name"));
		query.orderBy(order2);

		users = entityManager.createQuery(query).
				setHint("javax.persistence.fetchgraph", entityGraph).getResultList();

The following sql output printed, which contains unexpected cross join filtering null values:

 
                                                                select
        user0_.id as id1_2_0_,
        chair1_.id as id1_0_1_,
        room2_.id as id1_1_2_,
        user0_.chair_id as chair_id2_2_0_,
        chair1_.room_id as room_id2_0_1_,
        room2_.name as name2_1_2_ 
    from
        User user0_ 
    left outer join
        Chair chair1_ 
            on user0_.chair_id=chair1_.id 
    left outer join
        Room room2_ 
            on chair1_.room_id=room2_.id cross 
    join
        Room room4_ 
    where
        chair1_.room_id=room4_.id 
    order by
        room4_.name asc
 
                                                            

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira