June 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16800) Wrong SELECT Statement Generation with setMaxResults in Hibernate 6.2.4

by Waldemar.Maier (JIRA)

Waldemar.Maier ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6329a18... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDVhMGUyYmVk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16800?atlOrigin=eyJpIjoiMDVhMG... ) HHH-16800 ( https://hibernate.atlassian.net/browse/HHH-16800?atlOrigin=eyJpIjoiMDVhMG... ) Wrong SELECT Statement Generation with setMaxResults in Hibernate 6.2.4 ( https://hibernate.atlassian.net/browse/HHH-16800?atlOrigin=eyJpIjoiMDVhMG... ) Issue Type: Bug Affects Versions: 6.2.4 Assignee: Unassigned Attachments: EntityA.java, EntityB.java, Testcase.java Components: hibernate-core Created: 14/Jun/2023 12:38 PM Priority: Major Reporter: Waldemar.Maier ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6329a18... ) Since the Version 6.2.4 the sql is wrong if you have follwing * EntityA * EntityB * EntityA has many-to-one relationship to EntityB * you select distinct EntityA.entityB and sets max results to something e.g. 2 Real Example attached hql: var list = em.createQuery( "select distinct a.entityB from EntityA a " , EntityA.class) .setMaxResults(2) .getResultList(); ---------------------------------------- Produced sql was correct in 6.2.1, 6.2.3 ---------------------------------------- select * from ( select distinct e2_0.tableBId c0 from TABLE_A e1_0 join TABLE_B e2_0 on e2_0.tableBId=e1_0.tableBId) where rownum <=? ------------------------------------- Since 6.2.4 the produces SQL is wrong ------------------------------------- select * from ( select distinct e2_0.tableBId c0, rownum rn from TABLE_A e1_0 join TABLE_B e2_0 on e2_0.tableBId=e1_0.tableBId) r_0_ where r_0_.rn<=? order by r_0_.rn this is wrong because if you include rownum as column and distinct over it then all rows will become unique even the real duplicates ( https://hibernate.atlassian.net/browse/HHH-16800#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16800#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#100226- sha1:c25eebb )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16739) Several failures when comparing enum parameters with constant values

by Christian Beikov (JIRA)

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16799) Using bytecode enhancement may result in incorrect AccessType being picked

by Marko Bekhta (JIRA)

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16799) Using bytecode enhancement may result in incorrect AccessType being picked

by Marko Bekhta (JIRA)

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16678) AssertionError in QueryLiteral.<init> when using "update versioned Entity ..." if @Version is a long

by Anders Wallgren (JIRA)

Anders Wallgren ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cb770d... ) *commented* on HHH-16678 ( https://hibernate.atlassian.net/browse/HHH-16678?atlOrigin=eyJpIjoiOTdlOT... ) Re: AssertionError in QueryLiteral.<init> when using "update versioned Entity ..." if @Version is a long ( https://hibernate.atlassian.net/browse/HHH-16678?atlOrigin=eyJpIjoiOTdlOT... ) Thanks for the fix – I’ve confirmed it against a 6.2.5-SNAPSHOT build. ( https://hibernate.atlassian.net/browse/HHH-16678#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16678#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#100226- sha1:c25eebb )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16799) Using bytecode enhancement may result in incorrect AccessType being picked

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOTU5NGQxMjcy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16799?atlOrigin=eyJpIjoiOTU5NG... ) HHH-16799 ( https://hibernate.atlassian.net/browse/HHH-16799?atlOrigin=eyJpIjoiOTU5NG... ) Using bytecode enhancement may result in incorrect AccessType being picked ( https://hibernate.atlassian.net/browse/HHH-16799?atlOrigin=eyJpIjoiOTU5NG... ) Issue Type: Bug Assignee: Unassigned Created: 14/Jun/2023 09:28 AM Priority: Major Reporter: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) With bytecode enhancement enabled and an entity like: @Entity private class SomeEntity { @Id Long id; @Basic String field; String property; @Basic @Access(AccessType.PROPERTY) public String getProperty() { // do some fun stuff before returning a return modifiedPropertyValue; } public void setProperty( String property) { this.property = property; } } PropertyAccessEnhancedImpl may end up picking an AccessType.FIELD for a property , which will end up saving the “unmodified” property value. This came up while looking into a bug reported at Quarkus. ( https://hibernate.atlassian.net/browse/HHH-16799#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16799#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#100226- sha1:c25eebb )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16721) HQL with subquery with entity path at least two levels deep produces wrong SQL

by Christian Beikov (JIRA)

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16797) Mark org.hibernate.metamodel as incubating

by Steve Ebersole (JIRA)

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16798) ClassCastException in Hibernate 6 when "join fetch" is used in a query with entity inheritance

by Victor Mariano Lessa de Assis (JIRA)

Victor Mariano Lessa de Assis ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNDhlNmUxZWNj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16798?atlOrigin=eyJpIjoiNDhlNm... ) HHH-16798 ( https://hibernate.atlassian.net/browse/HHH-16798?atlOrigin=eyJpIjoiNDhlNm... ) ClassCastException in Hibernate 6 when "join fetch" is used in a query with entity inheritance ( https://hibernate.atlassian.net/browse/HHH-16798?atlOrigin=eyJpIjoiNDhlNm... ) Issue Type: Bug Affects Versions: 6.2.4 Assignee: Unassigned Attachments: src.tar.gz Created: 14/Jun/2023 09:03 AM Priority: Major Reporter: Victor Mariano Lessa de Assis ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) em.createQuery("select e from " + Entity1.class.getSimpleName() + " e left join fetch e.subClass1 left join fetch e.subClass2 ", Entity1.class).getSingleResult() This query used to work in Hibernate 5, but I'm getting the following error in Hibernate 6: Exception in thread "main" java.lang.ClassCastException: class org.example.entity.SubClass1 cannot be cast to class org.example.entity.SubClass2 (org.example.entity.SubClass1 and org.example.entity.SubClass2 are in unnamed module of loader 'app') @Entity @Getter @Setter public class Entity1 { @Id String id; @OneToOne(fetch = FetchType.LAZY, mappedBy = "entity1") protected SubClass1 subClass1; @OneToOne(fetch = FetchType.LAZY, mappedBy = "entity1") protected SubClass2 subClass2; } @Entity @Getter @Setter @Inheritance(strategy = InheritanceType.SINGLE_TABLE) public abstract class SuperClass implements Serializable { @Id public String id; @ManyToOne protected Entity1 entity1; } @Entity @DiscriminatorValue("1") public class SubClass1 extends SuperClass { } @Entity @DiscriminatorValue("2") public class SubClass2 extends SuperClass { } ( https://hibernate.atlassian.net/browse/HHH-16798#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16798#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#100226- sha1:c25eebb )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16797) Mark org.hibernate.metamodel as incubating

by Steve Ebersole (JIRA)

2 years, 10 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 June 2023