Message Title

Ilya Bystrov created an issue

Issue Type:	Bug
Affects Versions:	5.0.12
Assignee:	Unassigned
Components:	hibernate-core
Created:	14/Apr/2017 06:40 AM
Priority:	Major
Reporter:	Ilya Bystrov

Hibernate Core

{5.0.12.Final}

JPQL implicit join causes Hibernate generate "CROSS JOIN" instead of "INNER JOIN" for joining tables with one-to-one relationship.

Looks like another old similar issue https://hibernate.atlassian.net/browse/HHH-7707.

Entities

 
                                                                import lombok.Data;

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToOne;

@Entity
@Data
public class Person {

    @Id
    private Long id;
    private String firstname;
    private String lastname;

    @OneToOne
    @JoinColumn(name = "id")
    private StreetAddress streetAddress;
}
 
                                                            

 
                                                                import lombok.Data;

import javax.persistence.Entity;
import javax.persistence.Id;

@Entity
@Data
public class StreetAddress {

    @Id
    private Long personId;
    private String address;
}

h5. Implicit Join (generates Cross Join)¶

{code:sql}
select p from Person p where p.streetAddress.address = ?1
 
                                                            

 
                                                                Hibernate:
    /* select
        p
    from
        Person p
    where
        p.streetAddress.address = ?1 */ select
            person0_.id as id1_0_,
            person0_.firstname as firstnam2_0_,
            person0_.lastname as lastname3_0_
        from
            person person0_ cross
        join
            street_address streetaddr1_
        where
            person0_.id=streetaddr1_.person_id
            and streetaddr1_.address=?
 
                                                            

Explicit Join (generates Inner Join)

 
                                                                select p from Person p join p.streetAddress a where a.address = ?1

 
                                                                Hibernate:
    /* select
        p
    from
        Person p
    join
        p.streetAddress a
    where
        a.address = ?1 */ select
            person0_.id as id1_0_,
            person0_.firstname as firstnam2_0_,
            person0_.lastname as lastname3_0_
        from
            person person0_
        inner join
            street_address streetaddr1_
                on person0_.id=streetaddr1_.person_id
        where
            streetaddr1_.address=?
 
                                                            

Full source code available on github. The same description can be found on my blog

Add Comment

This message was sent by Atlassian JIRA