March 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16412) java.lang.ClassCircularityError after upgrading to 6.2.0.Final

by Cédric Tabin (JIRA)

Cédric Tabin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16412 ( https://hibernate.atlassian.net/browse/HHH-16412?atlOrigin=eyJpIjoiZDE1Zj... ) Re: java.lang.ClassCircularityError after upgrading to 6.2.0.Final ( https://hibernate.atlassian.net/browse/HHH-16412?atlOrigin=eyJpIjoiZDE1Zj... ) Note that we also tried to disable completely the bytecode enhancer during the compilation, the same error happen during the deployment. ( https://hibernate.atlassian.net/browse/HHH-16412#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16412#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-16412) java.lang.ClassCircularityError after upgrading to 6.2.0.Final

by Cédric Tabin (JIRA)

Cédric Tabin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjRhZGVlYTg2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16412?atlOrigin=eyJpIjoiNjRhZG... ) HHH-16412 ( https://hibernate.atlassian.net/browse/HHH-16412?atlOrigin=eyJpIjoiNjRhZG... ) java.lang.ClassCircularityError after upgrading to 6.2.0.Final ( https://hibernate.atlassian.net/browse/HHH-16412?atlOrigin=eyJpIjoiNjRhZG... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Components: bytecode-enhancement Created: 31/Mar/2023 03:03 AM Environment: Payara-embedded-all 6.2023.1 with enhanced entities maven-plugin 6.2.0.Final. Priority: Major Reporter: Cédric Tabin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hello, Our entities are enhanced at compile-time through the maven plugin. When the application is deployed, we get the following error: SEVERE: Exception during lifecycle processing java.lang.ClassCircularityError: org/hibernate/bytecode/enhance/spi/EnhancementContextWrapper at org.hibernate.jpa.internal.enhance.EnhancingClassTransformerImpl.transform(EnhancingClassTransformerImpl.java:50) at org.glassfish.persistence.jpa.ServerProviderContainerContractInfo$1.transform(ServerProviderContainerContractInfo.java:101) at com.sun.enterprise.loader.ASURLClassLoader.findClass(ASURLClassLoader.java:734) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:587) at com.sun.enterprise.loader.CurrentBeforeParentClassLoader.loadClass(CurrentBeforeParentClassLoader.java:83) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520) at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:166) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1380) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1451) at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:142) at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:207) at org.glassfish.persistence.jpa.PersistenceUnitLoader.<init>(PersistenceUnitLoader.java:114) at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:267) at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:571) at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:286) at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:183) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:1197) at org.glassfish.javaee.full.deployment.EarDeployer.prepareBundle(EarDeployer.java:301) at org.glassfish.javaee.full.deployment.EarDeployer.lambda$prepare$0(EarDeployer.java:164) at org.glassfish.javaee.full.deployment.EarDeployer.doOnBundles(EarDeployer.java:221) at org.glassfish.javaee.full.deployment.EarDeployer.doOnAllTypedBundles(EarDeployer.java:233) at org.glassfish.javaee.full.deployment.EarDeployer.doOnAllBundles(EarDeployer.java:259) at org.glassfish.javaee.full.deployment.EarDeployer.prepare(EarDeployer.java:162) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:1197) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepare(ApplicationLifecycle.java:511) at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:612) at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:556) at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:552) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/javax.security.auth.Subject.doAs(Subject.java:376) at com.sun.enterprise.v3.admin.CommandRunnerImpl$2.execute(CommandRunnerImpl.java:551) at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:582) at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:574) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/javax.security.auth.Subject.doAs(Subject.java:376) at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:573) at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1497) at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1869) at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1755) at com.sun.enterprise.admin.cli.embeddable.DeployerImpl.deploy(DeployerImpl.java:131) ... The only thing we changed was the version of Hibernate (from 6.1.7 which worked fine to 6.2.0). Also, we denoted a strange behavior of the enhancer, because after enhancement, the entities field became public which is unattended. Our entities are very basic (only private annotated fields an public getters/setters), there are only some inheritance of generic fields: @Entity @Table(name = "mytable" ) public class MyTable extends AbstractSimpleTable<MyTablePK> { private static final long serialVersionUID = 1L; @EmbeddedId private MyTablePK mytablePK; @Column(name = "COLUMN1" ) private String column1; @Column(name = "COLUMN2" ) private String column2; public MyTablePK getMytablePK() { return sysusrPK; } public void setMytablePK(MyTablePK mytablePK) { this.mytablePK = mytablePK; } public String getColumn1() { return column1; } public void setColumn1( String column1) { this.column1 = column1; } public String getColumn2() { return column2; } public void setColumn2( String column2) { this.column2 = column2; } } And the superclass: @MappedSuperclass public abstract class AbstractSimpleTable<P extends Shareable> { @Lob @Column(name = "GENERICFIELD" ) private String genericfield; public String getGenericfield() { return genericfield; } public void setGenericfield( String genericfield) { this.genericfield = genericfield; } } Thanks for the help ! ( https://hibernate.atlassian.net/browse/HHH-16412#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16412#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-16410) SingleIdEntityLoader repeatedly translates SQL AST

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGFjMjI1MjQw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMGFjMj... ) HHH-16410 ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMGFjMj... ) SingleIdEntityLoader repeatedly translates SQL AST ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMGFjMj... ) Change By: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) For byId lookups, it looks like {{org.hibernate.loader.ast.internal.SingleIdEntityLoaderDynamicBatch#load}} is called, and that causes SQL translation over and over again, though it should be cached. It is also looks fishy to me that we do not try to cache SQL statements for a certain batch size, though that isn’t important for now. In a throughput test, this was identified as causing perf issues compared to 5. ( https://hibernate.atlassian.net/browse/HHH-16410#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16410#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-16411) CollectionLoaderBatchKey seems to always translate SQL instead of caching

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjlkNjI0NzU3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16411?atlOrigin=eyJpIjoiMjlkNj... ) HHH-16411 ( https://hibernate.atlassian.net/browse/HHH-16411?atlOrigin=eyJpIjoiMjlkNj... ) CollectionLoaderBatchKey seems to always translate SQL instead of caching ( https://hibernate.atlassian.net/browse/HHH-16411?atlOrigin=eyJpIjoiMjlkNj... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Components: hibernate-core Created: 31/Mar/2023 01:57 AM Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) org.hibernate.loader.ast.internal.CollectionLoaderBatchKey#batchLoad should maybe try to cache the SQL it translates. In a throughput test, this was identified as causing perf issues compared to 5. ( https://hibernate.atlassian.net/browse/HHH-16411#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16411#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-16410) SingleIdEntityLoader repeatedly translates SQL AST

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDVmZGQwOTUy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMDVmZG... ) HHH-16410 ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMDVmZG... ) SingleIdEntityLoader repeatedly translates SQL AST ( https://hibernate.atlassian.net/browse/HHH-16410?atlOrigin=eyJpIjoiMDVmZG... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Components: hibernate-core Created: 31/Mar/2023 01:55 AM Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) For byId lookups, it looks like org.hibernate.loader.ast.internal.SingleIdEntityLoaderDynamicBatch#load is called, and that causes SQL translation over and over again, though it should be cached. It is also looks fishy to me that we do not try to cache SQL statements for a certain batch size, though that isn’t important for now. ( https://hibernate.atlassian.net/browse/HHH-16410#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16410#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-16409) SQLGrammarException when selecting property of grouped join association

by Bartlomiej Niemiec (JIRA)

Bartlomiej Niemiec ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cdd0b2... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTM3N2YyMzE4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16409?atlOrigin=eyJpIjoiNTM3N2... ) HHH-16409 ( https://hibernate.atlassian.net/browse/HHH-16409?atlOrigin=eyJpIjoiNTM3N2... ) SQLGrammarException when selecting property of grouped join association ( https://hibernate.atlassian.net/browse/HHH-16409?atlOrigin=eyJpIjoiNTM3N2... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Attachments: testcase.zip Components: hibernate-core Created: 31/Mar/2023 01:54 AM Environment: JDK 17, Postgres, HSQLDB Priority: Major Reporter: Bartlomiej Niemiec ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cdd0b2... ) Having entities like: @Entity @Table(schema = "test" , name = "t_primary" ) public class Primary implements Serializable { @Id private int id; @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "t_secondary_id" ) private Secondary secondary; private BigDecimal value; //getters & setters @Entity @Table(schema = "test" , name = "t_secondary" ) public class Secondary implements Serializable { @Id private int id; private String name; //getters & setters and executing following query: CriteriaBuilder cb = em.getCriteriaBuilder(); var query = cb.createTupleQuery(); Root<Primary> root = query.from(Primary.class); var secondaryJoin = root.join(Primary_.secondary); //when query.multiselect( secondaryJoin.get(Secondary_.name).alias( "secondary" ), cb.sum(root.get(Primary_.value)).alias( "sum" ) ).groupBy( secondaryJoin ).orderBy( cb.desc(secondaryJoin.get(Secondary_.name)) ); var list = em.createQuery(query).getResultList(); will cause exception: java. sql.SQLSyntaxErrorException: expression not in aggregate or GROUP BY columns : S1_0. NAME in statement [ select s1_0. name , sum (p1_0. value ) from test.t_primary p1_0 join test.t_secondary s1_0 on s1_0.id=p1_0.t_secondary_id group by p1_0.t_secondary_id order by 1 desc ] This example works fine in 5.6.x and 6.1.0 ( https://hibernate.atlassian.net/browse/HHH-16409#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16409#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-15806) Envers and Hibernate 6 and PostgreSQLEnumType

by Defives Kevin (JIRA)

Defives Kevin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ddbd5d... ) *commented* on HHH-15806 ( https://hibernate.atlassian.net/browse/HHH-15806?atlOrigin=eyJpIjoiNWYxYz... ) Re: Envers and Hibernate 6 and PostgreSQLEnumType ( https://hibernate.atlassian.net/browse/HHH-15806?atlOrigin=eyJpIjoiNWYxYz... ) Same issue here when we migrate from spring boot 2 to 3 ( https://hibernate.atlassian.net/browse/HHH-15806#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15806#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-16408) query.setMaxResults(1) with EntityGraph and @ElementCollection gives wrong result in Hibernate 6

by Fouad Almalki (JIRA)

Fouad Almalki ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGE2MzIwOGU4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16408?atlOrigin=eyJpIjoiMGE2Mz... ) HHH-16408 ( https://hibernate.atlassian.net/browse/HHH-16408?atlOrigin=eyJpIjoiMGE2Mz... ) query.setMaxResults(1) with EntityGraph and @ElementCollection gives wrong result in Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16408?atlOrigin=eyJpIjoiMGE2Mz... ) Change By: Fouad Almalki ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given: {code:java}@Table(name = "users") @Entity public class UserEntity { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id") Integer id; @NotNull @Column(name = "username") String username; @ElementCollection @CollectionTable(name = "users_roles_mapping", joinColumns = @JoinColumn(name = "user_id")) @Column(name = "role_name") Set<String> roles; // ... }{code} {code:sql} -- MSSQL 2022 CREATE TABLE users ( id INT NOT NULL IDENTITY, username VARCHAR(50) NOT NULL, CONSTRAINT pk_users PRIMARY KEY (id) ); CREATE TABLE roles ( name VARCHAR(50) NOT NULL, CONSTRAINT pk_roles PRIMARY KEY (name) ); CREATE TABLE users_roles_mapping ( user_id INT NOT NULL, role_name VARCHAR(50) NOT NULL, CONSTRAINT pk_users_roles_mapping PRIMARY KEY (user_id, role_name), CONSTRAINT fk_users_roles_mapping_user FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT fk_users_roles_mapping_role FOREIGN KEY (role_name) REFERENCES roles (name) ); INSERT INTO users (username) VALUES ('user1'); INSERT INTO roles (name) VALUES ('role1'), ('role2'); INSERT INTO users_roles_mapping (user_id, role_name) VALUES (1, 'role1'), (1, 'role2');{code} {code:java}public Set<String> getUserRoles() { EntityGraph<UserEntity> entityGraph = entityManager.createEntityGraph(UserEntity.class); entityGraph.addAttributeNodes("roles"); Query query = entityManager.createQuery("SELECT u FROM UserEntity u WHERE u.id = 1"); query.setMaxResults(1); query.setHint(EntityGraphType.FETCH.getKey(), entityGraph); UserEntity userEntity = (UserEntity) query.getSingleResult(); return userEntity.getRoles(); }{code} {{getUserRoles}} returns 2 roles in Hibernate {{5.6.15.Final}} and returns 1 role (which is wrong) in Hibernate {{6.1.7}}. ( https://hibernate.atlassian.net/browse/HHH-16408#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16408#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-16408) query.setMaxResults(1) with EntityGraph and @ElementCollection gives wrong result in Hibernate 6

by Fouad Almalki (JIRA)

Fouad Almalki ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16408 ( https://hibernate.atlassian.net/browse/HHH-16408?atlOrigin=eyJpIjoiNjZhM2... ) Re: query.setMaxResults(1) with EntityGraph and @ElementCollection gives wrong result in Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16408?atlOrigin=eyJpIjoiNjZhM2... ) Related: https://github.com/spring-projects/spring-data-jpa/issues/2894 ( https://hibernate.atlassian.net/browse/HHH-16408#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16408#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:57c27f3 )

1 year

1
0
0 / 0

[JIRA] (HHH-16408) query.setMaxResults(1) with EntityGraph and @ElementCollection gives wrong result in Hibernate 6

by Fouad Almalki (JIRA)

Fouad Almalki ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGQ0ODBiZjU3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16408?atlOrigin=eyJpIjoiNGQ0OD... ) HHH-16408 ( https://hibernate.atlassian.net/browse/HHH-16408?atlOrigin=eyJpIjoiNGQ0OD... ) query.setMaxResults(1) with EntityGraph and @ElementCollection gives wrong result in Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16408?atlOrigin=eyJpIjoiNGQ0OD... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core Created: 30/Mar/2023 20:21 PM Priority: Critical Reporter: Fouad Almalki ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given: @Table(name = "users" ) @Entity public class UserEntity { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id" ) Integer id; @NotNull @Column(name = "username" ) String username; @ElementCollection @CollectionTable(name = "users_roles_mapping" , joinColumns = @JoinColumn(name = "user_id" )) @Column(name = "role_name" ) Set< String > roles; // ... } CREATE TABLE users ( id INT NOT NULL IDENTITY , username VARCHAR (50) NOT NULL , CONSTRAINT pk_users PRIMARY KEY (id) ); CREATE TABLE roles ( name VARCHAR (50) NOT NULL , CONSTRAINT pk_roles PRIMARY KEY ( name ) ); CREATE TABLE users_roles_mapping ( user_id INT NOT NULL , role_name VARCHAR (50) NOT NULL , CONSTRAINT pk_users_roles_mapping PRIMARY KEY (user_id, role_name), CONSTRAINT fk_users_roles_mapping_user FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT fk_users_roles_mapping_role FOREIGN KEY (role_name) REFERENCES roles ( name ) ); INSERT INTO users (username) VALUES ( 'user1' ); INSERT INTO roles ( name ) VALUES ( 'role1' ), ( 'role2' ); INSERT INTO users_roles_mapping (user_id, role_name) VALUES (1, 'role1' ), (1, 'role2' ); public Set< String > getUserRoles() { EntityGraph<UserEntity> entityGraph = entityManager.createEntityGraph(UserEntity.class); entityGraph.addAttributeNodes( "roles" ); Query query = entityManager.createQuery( "SELECT u FROM UserEntity u WHERE u.id = 1" ); query.setMaxResults(1); query.setHint(EntityGraphType.FETCH.getKey(), entityGraph); UserEntity userEntity = (UserEntity) query.getSingleResult(); return userEntity.getRoles(); } getUserRoles returns 2 roles in Hibernate 5.6.15.Final and returns 1 role (which is wrong) in Hibernate 6.1.7. ( https://hibernate.atlassian.net/browse/HHH-16408#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16408#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:57c27f3 )

1 year

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues March 2023