April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16473) Join fetch a recursive relationship with EmbeddedId fetches wrong values

by Staffan Hörke (JIRA)

Staffan Hörke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGQzZjFmNjFk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16473?atlOrigin=eyJpIjoiMGQzZj... ) HHH-16473 ( https://hibernate.atlassian.net/browse/HHH-16473?atlOrigin=eyJpIjoiMGQzZj... ) Join fetch a recursive relationship with EmbeddedId fetches wrong values ( https://hibernate.atlassian.net/browse/HHH-16473?atlOrigin=eyJpIjoiMGQzZj... ) Issue Type: Bug Affects Versions: 6.2.1 Assignee: Unassigned Components: hibernate-core Created: 14/Apr/2023 07:33 AM Priority: Minor Reporter: Staffan Hörke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) Given an entity with an embedded id and a recursive parent/child relationship, when querying a child instance with a join fetch to the parent, the child instance is populated with values that belongs to the parent instance. *Domain model* @Entity(name = "OrganizationWithEmbeddedId" ) public static class OrganizationWithEmbeddedId { @EmbeddedId private OrganizationId id; private String name; @ManyToOne private OrganizationWithEmbeddedId parent; @OneToMany(mappedBy = "parent" ) private Set<OrganizationWithEmbeddedId> children; public OrganizationWithEmbeddedId() { } public OrganizationWithEmbeddedId(OrganizationId id, String name) { this.id = id; this.name = name; } public String getName() { return name; } public void setName( String name) { this.name = name; } public OrganizationWithEmbeddedId getParent() { return parent; } public void setParent(OrganizationWithEmbeddedId parent) { this.parent = parent; } public Set<OrganizationWithEmbeddedId> getChildren() { return children; } public void addChild(OrganizationWithEmbeddedId child) { if (children == null ) { children = new HashSet<>(); } children.add(child); child.setParent( this ); } @Override public boolean equals( Object o) { if ( this == o) return true ; if (o == null || getClass() != o.getClass()) return false ; OrganizationWithEmbeddedId that = (OrganizationWithEmbeddedId) o; return Objects.equals(id, that.id); } @Override public int hashCode() { return Objects.hash(id); } } @Embeddable public static class OrganizationId implements java.io.Serializable { private static final long serialVersionUID = 1L; @Column(name = "id" ) private long value; OrganizationId() { super (); } OrganizationId( long value) { this.value = value; } @Override public String toString() { return Long.toString(value); } @Override public boolean equals( Object o) { if ( this == o) return true ; if (o == null || getClass() != o.getClass()) return false ; OrganizationId that = (OrganizationId) o; return value == that.value; } @Override public int hashCode() { return Objects.hash(value); } } *Query* SELECT child FROM OrganizationWithEmbeddedId child JOIN FETCH child.parent WHERE child.id = :id *Result* The name property of the child instance is wrong. It has the value from the parent instance. ( https://hibernate.atlassian.net/browse/HHH-16473#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16473#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:8830b7c )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-15726) Disjunction with treat results in too restrictive query

by Emond Papegaaij (JIRA)

Emond Papegaaij ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15726 ( https://hibernate.atlassian.net/browse/HHH-15726?atlOrigin=eyJpIjoiNzYxMT... ) Re: Disjunction with treat results in too restrictive query ( https://hibernate.atlassian.net/browse/HHH-15726?atlOrigin=eyJpIjoiNzYxMT... ) Can you give an update on this issue? It keeps getting moved to the next version. At the moment, this is a blocker for us to move to WildFly 28 and Hibernate 6.2. ( https://hibernate.atlassian.net/browse/HHH-15726#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15726#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:8830b7c )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16472) Treated left join with restriction on entity results in incorrect query

by Emond Papegaaij (JIRA)

Emond Papegaaij ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16472 ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiNDBlMm... ) Re: Treated left join with restriction on entity results in incorrect query ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiNDBlMm... ) It might be related, but the specifics are different. In this case, the DTYPE restriction is added twice where with https://hibernate.atlassian.net/browse/HHH-16438 it is only added once. ( https://hibernate.atlassian.net/browse/HHH-16472#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16472#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:8830b7c )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16472) Treated left join with restriction on entity results in incorrect query

by Jan Schatteman (JIRA)

Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16472 ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiYTRiZj... ) Re: Treated left join with restriction on entity results in incorrect query ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiYTRiZj... ) Yep, certainly seems related, I’ve attached the other issue ( https://hibernate.atlassian.net/browse/HHH-16472#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16472#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:8830b7c )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16472) Treated left join with restriction on entity results in incorrect query

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16472 ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiOTM3MG... ) Re: Treated left join with restriction on entity results in incorrect query ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiOTM3MG... ) This looks like a duplicate of https://hibernate.atlassian.net/browse/HHH-16438 , but I’ll let Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) confirm since he’s working on that issue. ( https://hibernate.atlassian.net/browse/HHH-16472#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16472#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:8830b7c )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16472) Treated left join with restriction on entity results in incorrect query

by Emond Papegaaij (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16472) Treated left join with restriction on entity results in incorrect query

by Emond Papegaaij (JIRA)

Emond Papegaaij ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNWZmOWMwMmFk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiNWZmOW... ) HHH-16472 ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiNWZmOW... ) Treated left join with restriction on entity results in incorrect query ( https://hibernate.atlassian.net/browse/HHH-16472?atlOrigin=eyJpIjoiNWZmOW... ) Issue Type: Bug Affects Versions: 6.2.1 Assignee: Unassigned Components: hibernate-core Created: 14/Apr/2023 06:50 AM Priority: Major Reporter: Emond Papegaaij ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) When adding a restriction on a path to an entity from a treated left outer join, the restriction on the dtype is rendered twice: once in a sub-select in the outer join (this is correct) and once in where clause of the outer select (this is incorrect). The second restriction effectively transforms the left outer join into an inner join, because DTYPE will be NULL for all other records. The resulting query looks like this: select m1_0.id, m1_0.ref2 from MyEntity1 m1_0 left join ( select * from MyEntity2 t where t.DTYPE= 'MySubEntity2' ) r1_0 on r1_0.id=m1_0.ref2 where ( m1_0.ref2 is null or m1_0.ref2 is not null and r1_0.ref3=? ) and r1_0.DTYPE= 'MySubEntity2' I’ve attached a testcase that shows the problem. This test runs fine against 5.6.15. ( https://hibernate.atlassian.net/browse/HHH-16472#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16472#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:8830b7c )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16471) Entities serialized in QueryKey

by Emond Papegaaij (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16470) Hibernate @TenantId is not applied to entities brought in by an unassociated left join

by saberwang (JIRA)

saberwang ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiODU4ODYwZGRi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16470?atlOrigin=eyJpIjoiODU4OD... ) HHH-16470 ( https://hibernate.atlassian.net/browse/HHH-16470?atlOrigin=eyJpIjoiODU4OD... ) Hibernate @TenantId is not applied to entities brought in by an unassociated left join ( https://hibernate.atlassian.net/browse/HHH-16470?atlOrigin=eyJpIjoiODU4OD... ) Change By: saberwang ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) Added @ TenantId to both entities {noformat} @TenantId @Override public String getZuHuID() { return zuHuID; }{noformat} Define Query: {noformat} @Query("select count(s) from SM_ZD_SHUJUYLBModel as s left join SM_SQ_ShenQingDMXModel as a on s.id=a.id ") int testCount();{noformat} Generated SQL: {noformat}select count(s1_0.id) from sm_zd_shujuylb s1_0 left join sm_sq_shenqingdmx s2_0 on s1_0.id=s2_0.id where s1_0.zuHuID = ?{noformat} Related to [https://hibernate.atlassian.net/browse/HHH-11659|https://hibernate.atlass...] ( https://hibernate.atlassian.net/browse/HHH-16470#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16470#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:8830b7c )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16471) Entities serialized in QueryKey

by Emond Papegaaij (JIRA)

2 years, 12 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues April 2023