May 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16513) Wrong query generated for a parent-child relation within the same table

by Tomáš Müller (JIRA)

Tomáš Müller ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b50823... ) *commented* on HHH-16513 ( https://hibernate.atlassian.net/browse/HHH-16513?atlOrigin=eyJpIjoiN2JjZm... ) Re: Wrong query generated for a parent-child relation within the same table ( https://hibernate.atlassian.net/browse/HHH-16513?atlOrigin=eyJpIjoiN2JjZm... ) Hi Marco, The test now passes, and the generated SQL is correct: select s1_0.id, p1_0.id from subpart s1_0 join subpart p1_0 on p1_0.id=s1_0.parent So, the issue appears to be fixed in Hibernate 6.2.2. Thanks, Tomas ( https://hibernate.atlassian.net/browse/HHH-16513#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16513#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#100224- sha1:07bd2b7 )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-15871) Update EDB testing to version 15

by Christian Beikov (JIRA)

1 year, 8 months

1
0
0 / 0

[JIRA] (HSEARCH-4848) Fix unpredictable order of some associations in automatic reindexing tests

by Yoann Rodière (JIRA)

1 year, 8 months

1
0
0 / 0

[JIRA] (HSEARCH-4848) Fix unpredictable order of some associations in automatic reindexing tests

by Yoann Rodière (JIRA)

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16469) Hibernate repeatedly issues identical SELECT queries to load an optional one-to-one association

by Andrea Boriero (JIRA)

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-14944) Detaching entity removes NaturalIdCrossReference in 2nd-level cache too

by Guenther Demetz (JIRA)

Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14944 ( https://hibernate.atlassian.net/browse/HHH-14944?atlOrigin=eyJpIjoiZGI5Mz... ) Re: Detaching entity removes NaturalIdCrossReference in 2nd-level cache too ( https://hibernate.atlassian.net/browse/HHH-14944?atlOrigin=eyJpIjoiZGI5Mz... ) Please consider This PR https://github.com/hibernate/hibernate-orm/pull/6486 instead to the first one ( https://hibernate.atlassian.net/browse/HHH-14944#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14944#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#100224- sha1:07bd2b7 )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16513) Wrong query generated for a parent-child relation within the same table

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16513 ( https://hibernate.atlassian.net/browse/HHH-16513?atlOrigin=eyJpIjoiZDllYj... ) Re: Wrong query generated for a parent-child relation within the same table ( https://hibernate.atlassian.net/browse/HHH-16513?atlOrigin=eyJpIjoiZDllYj... ) Hello Tomáš Müller ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b50823... ) , this issue looks like a duplicate of https://hibernate.atlassian.net/browse/HHH-16488 which was fixed in version 6.2.2 (along with other self-reference query improvements, see https://hibernate.atlassian.net/browse/HHH-16382 ). Could you please test with the latest version and let us know if it fixes your case too? ( https://hibernate.atlassian.net/browse/HHH-16513#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16513#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#100224- sha1:07bd2b7 )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16537) Wrong SQL generated when root join is not used in sub-query

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjlhNzM1Nzk2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16537?atlOrigin=eyJpIjoiNjlhNz... ) HHH-16537 ( https://hibernate.atlassian.net/browse/HHH-16537?atlOrigin=eyJpIjoiNjlhNz... ) Wrong SQL generated when root join is not used in sub-query ( https://hibernate.atlassian.net/browse/HHH-16537?atlOrigin=eyJpIjoiNjlhNz... ) Change By: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given * Join with alias in root query * sub-query using same join path but not using the defined alias When * executing HQL Then * Wrong SQL is generated {code:java}@Entity @Table(name = "REFERENCED_ENTITY") public class ReferencedEntity { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") Integer id; @Column(name = "foo") Integer foo; }{code} {code:java}@Entity @Table(name = "ENTITY_A") public class EntityA { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") Integer id; @JoinColumn(name = "ENTITY_B") @ManyToOne EntityB entityB; }{code} {code:java}@Entity @Table(name = "ENTITY_B") public class EntityB { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") Integer id; @Column(name = "REF_NUMBER") Integer reference; }{code} {code:java} @Test public void hhhXXXXTest() throws Exception { try (Session s = openSession()) { Transaction tx = s.beginTransaction(); ReferencedEntity ref1 = new ReferencedEntity(); ref1.foo = 1; ReferencedEntity ref2 = new ReferencedEntity(); ref2.foo = 2; s.persist(ref1); s.persist(ref2); EntityA entityA1 = new EntityA(); EntityB entityB1 = new EntityB(); entityA1.entityB = entityB1; entityB1.reference = ref1.id; s.persist(entityB1); s.persist(entityA1); EntityA entityA2 = new EntityA(); EntityB entityB2 = new EntityB(); entityA2.entityB = entityB2; entityB2.reference = ref2.id; s.persist(entityB2); s.persist(entityA2); tx.commit(); } try (Session s = openSession()) { Query<EntityA> query = s.createQuery("select a from EntityA a join a.entityB ab " // + " where 0 < (select count(*) from ReferencedEntity r where r.foo = 1 and r.id = a.entityB.reference)", EntityA.class); List<EntityA> actual = query.getResultList(); assertThat(actual).hasSize(1); } }{code} The generated SQL is wrong since {{e3_0}} has no reference to root query and the test fails: {code:sql} select e1_0.ID, e1_0.ENTITY_B from ENTITY_A e1_0 join ENTITY_B e2_0 on e2_0.ID=e1_0.ENTITY_B where 0<( select count(*) from REFERENCED_ENTITY r1_0, ENTITY_B e3_0 where r1_0.foo=1 and r1_0.ID=e3_0.REF_NUMBER ){code} Changing the HQL to use the join alias from root query works fine: {code:java} try (Session s = openSession()) { Query<EntityA> query = s.createQuery("select a from EntityA a join a.entityB ab " // + " where 0 < (select count(*) from ReferencedEntity r where r.foo = 1 and r.id = ab.reference)", EntityA.class); List<EntityA> actual = query.getResultList(); assertThat(actual).hasSize(1); }{code} I decided to report this case since the original HQL works fine on latest hibernate 5.6 series Test case to be attached and available at [https://github.com/ratoaq2/HHH-16537|https://github.com/ratoaq2/HHH-16537...] ( https://hibernate.atlassian.net/browse/HHH-16537#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16537#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#100224- sha1:07bd2b7 )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16537) Wrong SQL generated when root join is not used in sub-query

by Jones (JIRA)

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16499) adapt to MAX_STRING_SIZE=EXTENDED on Oracle

by Christian Beikov (JIRA)

1 year, 8 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 May 2023