March 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16397) Wrong SQL when HQL has subquery using FK attribute

by Jones (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16397) Wrong SQL when HQL has subquery using FK attribute

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWJhOWU0ZTkw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16397?atlOrigin=eyJpIjoiMWJhOW... ) HHH-16397 ( https://hibernate.atlassian.net/browse/HHH-16397?atlOrigin=eyJpIjoiMWJhOW... ) Wrong SQL when HQL has subquery using FK attribute ( https://hibernate.atlassian.net/browse/HHH-16397?atlOrigin=eyJpIjoiMWJhOW... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Components: query-hql Created: 29/Mar/2023 11:29 AM Priority: Critical Reporter: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given * Entity with @ManyToOne attribute When * Executing HQL with subquery using @ManyToOne attribute Then * Wrong query is generated and wrong results are returned @Entity @Table(name = "ENTITY_A" ) public class EntityA { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID" ) Integer id; @Column(name = "PROPERTY_A" ) int propertyA; @ManyToOne @JoinColumn(name = "REFERENCE" ) EntityA reference; } @Test public void hhhXXXXTest() throws Exception { // BaseCoreFunctionalTestCase automatically creates the SessionFactory and // provides the Session. try (Session s = openSession()) { Transaction tx = s.beginTransaction(); EntityA entityA1 = new EntityA(); s.persist(entityA1); s.flush(); Query<EntityA> query = s.createQuery( "select c from EntityA c where c.propertyA = (select max(e.propertyA) from EntityA e where (c.reference is null and e.reference is null ))" , EntityA.class); List<EntityA> actual = query.list(); assertThat(actual).hasSize(1); tx.commit(); } } Hibernate: select e1_0.ID, e1_0.PROPERTY_A, e1_0.REFERENCE from ENTITY_A e1_0 where e1_0.PROPERTY_A=( select max(e2_0.PROPERTY_A) from ENTITY_A e2_0, ENTITY_A r1_0 where ( r1_0.ID is null and e2_0.REFERENCE is null ) and r1_0.ID=e1_0.REFERENCE ) java.lang.AssertionError: Expected size:<1> but was:<0> in: <[]> Failing test scenario to be attached ( https://hibernate.atlassian.net/browse/HHH-16397#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16397#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#100219- sha1:6a6077b )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16272) Hibernate 6 fails to refresh when collections are accessed in entity setter method when access type is property

by Andrea Boriero (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16272) Hibernate 6 fails to refresh when collections are accessed in entity setter method when access type is property

by Andrea Boriero (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16395) Initialization of Hibernate Proxies for Abstract Entities can fail

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16395 ( https://hibernate.atlassian.net/browse/HHH-16395?atlOrigin=eyJpIjoiNzA5Zj... ) Re: Initialization of Hibernate Proxies for Abstract Entities can fail ( https://hibernate.atlassian.net/browse/HHH-16395?atlOrigin=eyJpIjoiNzA5Zj... ) thanks for your reply, I’m going to close this issue. ( https://hibernate.atlassian.net/browse/HHH-16395#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16395#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#100219- sha1:6a6077b )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16396) HQL with SubQuery having same alias of root Query generates wrong SQL

by Andrea Boriero (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16396) HQL with SubQuery having same alias of root query generates wrong SQL

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDA5MzFlNWE4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16396?atlOrigin=eyJpIjoiZDA5Mz... ) HHH-16396 ( https://hibernate.atlassian.net/browse/HHH-16396?atlOrigin=eyJpIjoiZDA5Mz... ) HQL with SubQuery having same alias of root query generates wrong SQL ( https://hibernate.atlassian.net/browse/HHH-16396?atlOrigin=eyJpIjoiZDA5Mz... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 29/Mar/2023 07:27 AM Environment: the following HQL query ``` select e.otherEntity.id, (select e.aString from MyEntity e where e.otherEntity.id = :anotherEntityId) from MyEntity e ``` uses the wrong alias for `e.manyToOne`, `m1_0.otherEntity_id` instead of `m1_0.otherEntity_id` ``` select m1_0.otherEntity_id, (select m2_0.aString from MyEntity m2_0 where m1_0.otherEntity_id=?) from MyEntity m1_0 where m1_0.id=? ``` Fix Versions: 6.2.0 Priority: Major Reporter: Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) ( https://hibernate.atlassian.net/browse/HHH-16396#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16396#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#100219- sha1:6a6077b )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16395) Initialization of Hibernate Proxies for Abstract Entities can fail

by Thorsten Goetzke (JIRA)

Thorsten Goetzke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6422e66... ) *commented* on HHH-16395 ( https://hibernate.atlassian.net/browse/HHH-16395?atlOrigin=eyJpIjoiZDQ5Zj... ) Re: Initialization of Hibernate Proxies for Abstract Entities can fail ( https://hibernate.atlassian.net/browse/HHH-16395?atlOrigin=eyJpIjoiZDQ5Zj... ) Hello, This issue seems to be caused by a typo in my mapping files. I had an hierary as Tiger extends Cat extends Animal It Should have been: Everything as Joined-Subclass, Animal and Cat using abstract=”true” and Tiger with abstract=”false” . It was: Animal and Tiger had abstract=”true” and Cat had abstract=”false”. Somehow this did not cause any issues in 61.5 and 6.1.6… I guess this is an invalid mapping state which can only be archieved using legacy hibernate mapping files. Best regards, Thorsten ( https://hibernate.atlassian.net/browse/HHH-16395#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16395#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#100219- sha1:6a6077b )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16337) EntityCollection is not deleted when replaced

by Alexander Schwartz (JIRA)

Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) *commented* on HHH-16337 ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiNDMyYT... ) Re: EntityCollection is not deleted when replaced ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiNDMyYT... ) Did a full test suite run with the current SNAPSHOT release, works fine. Thanks! ( https://hibernate.atlassian.net/browse/HHH-16337#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16337#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#100219- sha1:6a6077b )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16350) PreLoadEvent listeners always receive PreLoadEvent with null state

by Marco Belladelli (JIRA)

1 year, 9 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues March 2023