September 2022 - hibernate-issues

[JIRA] (HHH-15544) OrderColumn invalid value on add for LAZY entity

by Antoine Reilles (JIRA)

Antoine Reilles ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15544 ( https://hibernate.atlassian.net/browse/HHH-15544?atlOrigin=eyJpIjoiYzM5NT... ) Re: OrderColumn invalid value on add for LAZY entity ( https://hibernate.atlassian.net/browse/HHH-15544?atlOrigin=eyJpIjoiYzM5NT... ) Now, I’m getting closer to what I have in my code: the rank column is declared as int and not Integer , and in sql, as rank int not null default 0, With this, I do have a value in the JPA test, and the ORM test fails Strangely in this test, I see the wrong value of rank used now: 1 instead of 0 , but no null value in the list. 0002-with-int-instead-of-Integer.patch ( https://hibernate.atlassian.net/secure/attachment/50063/50063_0002-with-i... ) ( https://hibernate.atlassian.net/browse/HHH-15544#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15544#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#100207- sha1:1c92a42 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15544) OrderColumn invalid value on add for LAZY entity

by Antoine Reilles (JIRA)

Antoine Reilles ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15544 ( https://hibernate.atlassian.net/browse/HHH-15544?atlOrigin=eyJpIjoiZjUwZj... ) Re: OrderColumn invalid value on add for LAZY entity ( https://hibernate.atlassian.net/browse/HHH-15544?atlOrigin=eyJpIjoiZjUwZj... ) 0001-try-to-do-the-same-in-jpa.patch ( https://hibernate.atlassian.net/secure/attachment/50062/50062_0001-try-to... ) You are right, I most certainly missed something in my setup that causes the issue. In my case, the different operations are executing in a tomee instance, executing hibernate through jpa, and using either hsqldb or mariadb as a database (I reproduced it with both databases). I tried to develop on your sample code to do the same on jpa, but I see a problem in fetching the rank again, but here is is probably that I did something wrong. ( https://hibernate.atlassian.net/browse/HHH-15544#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15544#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#100207- sha1:1c92a42 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15545) @NotFound(Ignore) defaults to eager loading

by Gavin King (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15545) @NotFound(Ignore) defaults to eager loading

by Gavin King (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15545) @NotFound(Ignore) defaults to eager loading

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15545 ( https://hibernate.atlassian.net/browse/HHH-15545?atlOrigin=eyJpIjoiOTllNT... ) Re: @NotFound(Ignore) defaults to eager loading ( https://hibernate.atlassian.net/browse/HHH-15545?atlOrigin=eyJpIjoiOTllNT... ) Actually I might be wrong. There does seem to be some code there that looks like it’s supposed to be handling the @ManyToMany case, but I didn’t find any tests for that. So (due to the lack of tests) assumed it wasn’t actually something we supported. But I might be wrong. ( https://hibernate.atlassian.net/browse/HHH-15545#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15545#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#100207- sha1:1c92a42 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15547) Multi-fetch with a single bag returns duplicates

by naizarak (JIRA)

naizarak ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ac8b46... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2JmZjg0OTM0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiN2JmZj... ) HHH-15547 ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiN2JmZj... ) Multi-fetch with a single bag returns duplicates ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiN2JmZj... ) Change By: naizarak ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ac8b46... ) Fetching multiple bags isn't allowed and throws a 'MultipleBagFetchException'. However multi-fetching a bag with a non-bag collection is allowed even though it also produces indeterminate indeterminable duplicate values (i.e. can't differentiate deliberate vs cartesian duplicates). Logically this operation should also be illegal, otherwise it yields an incorrect representation of the object state. # {code:java}package org.hibernate.bugs; import static org.junit.jupiter.api.Assertions.assertEquals; import java.util.List; import java.util.Set; import java.util.function.Consumer; import org.junit.jupiter.api.AfterEach; import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; import jakarta.persistence.ElementCollection; import jakarta.persistence.Entity; import jakarta.persistence.EntityManager; import jakarta.persistence.EntityManagerFactory; import jakarta.persistence.Id; import jakarta.persistence.Persistence; import jakarta.persistence.TypedQuery; public class HHH15547 { private EntityManagerFactory entityManagerFactory; @Entity(name = "Library") public static class Library { @Id public Long id; @ElementCollection public Set<String> books; @ElementCollection public List<String> movies; } @BeforeEach public void init() { entityManagerFactory = Persistence.createEntityManagerFactory( "templatePU" ); } @AfterEach public void destroy() { entityManagerFactory.close(); } @Test public void hhh15547_test() { doInEM(em -> { Library lib = new Library(); lib.id = 1L; lib.books = Set.of("b1", "b2"); lib.movies = List.of("m1", "m2"); em.persist(lib); }); doInEM(em -> { TypedQuery<Library> query = em.createQuery( "SELECT l FROM Library AS l " + "LEFT JOIN FETCH l.books " + "LEFT JOIN FETCH l.movies", Library.class); Library lib = query.getSingleResult(); lib.movies.add("m3"); }); doInEM(em -> { Library lib = em.find(Library.class, 1L); // fails, is actually "m1", "m2", "m1", "m2", "m3" assertEquals(List.of("m1", "m2", "m3"), lib.movies); }); } void doInEM(Consumer<EntityManager> function) { EntityManager entityManager = entityManagerFactory.createEntityManager(); entityManager.getTransaction().begin(); function.accept(entityManager); entityManager.getTransaction().commit(); entityManager.close(); } } {code} ( https://hibernate.atlassian.net/browse/HHH-15547#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15547#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#100207- sha1:1c92a42 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15547) Multi-fetch with a single bag returns duplicates

by naizarak (JIRA)

naizarak ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ac8b46... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOTA2ZWQ4YjVl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiOTA2ZW... ) HHH-15547 ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiOTA2ZW... ) Multi-fetch with a single bag returns duplicates ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiOTA2ZW... ) Change By: naizarak ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ac8b46... ) Fetching multiple bags isn't allowed and throws a 'MultipleBagFetchException'. However multi-fetching a bag with a non-bag collection is allowed even though it also produces indeterminate duplicate values (i.e. can't differentiate deliberate vs cartesian duplicates). Logically this operation should also be illegal, otherwise it yields an incorrect representation of the object state. {code:java}package org.hibernate.bugs; import static org.junit.jupiter.api.Assertions.assertEquals; import java.util.List; import java.util.Set; import java.util.function.Consumer; import org.junit.jupiter.api.AfterEach; import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; import jakarta.persistence.ElementCollection; import jakarta.persistence.Entity; import jakarta.persistence.EntityManager; import jakarta.persistence.EntityManagerFactory; import jakarta.persistence.Id; import jakarta.persistence.Persistence; import jakarta.persistence.TypedQuery; public class HHH15547 { private EntityManagerFactory entityManagerFactory; @Entity(name = "Library") public static class Library { @Id public Long id; @ElementCollection public Set<String> books; @ElementCollection public List<String> movies; } @BeforeEach public void init() { entityManagerFactory = Persistence.createEntityManagerFactory( "templatePU" ); } @AfterEach public void destroy() { entityManagerFactory.close(); } @Test public void hhh15547_test() { doInEM(em -> { Library lib = new Library(); lib.id = 1L; lib.books = Set.of("b1", "b2"); lib.movies = List.of("m1", "m2"); em.persist(lib); }); doInEM(em -> { TypedQuery<Library> query = em.createQuery( "SELECT l FROM Library AS l " + "LEFT JOIN FETCH l.books " + "LEFT JOIN FETCH l.movies", Library.class); Library lib = query.getSingleResult(); lib.movies.add("m3"); }); doInEM(em -> { Library lib = em.find(Library.class, 1L); // fails, is actually "m1", "m2", "m1", "m2", "m3" assertEquals(List.of("m1", "m2", "m3"), lib.movies); }); } void doInEM(Consumer<EntityManager> function) { EntityManager entityManager = entityManagerFactory.createEntityManager(); entityManager.getTransaction().begin(); function.accept(entityManager); entityManager.getTransaction().commit(); entityManager.close(); } } {code} ( https://hibernate.atlassian.net/browse/HHH-15547#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15547#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#100207- sha1:1c92a42 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15547) Multi-fetch with a single bag returns duplicates

by naizarak (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15547) Multi-fetch with a single bag returns duplicates

by naizarak (JIRA)

naizarak ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ac8b46... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiY2NlNDMzZDE2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiY2NlND... ) HHH-15547 ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiY2NlND... ) Multi-fetch with a single bag returns duplicates ( https://hibernate.atlassian.net/browse/HHH-15547?atlOrigin=eyJpIjoiY2NlND... ) Issue Type: Bug Affects Versions: 6.1.3 Assignee: Unassigned Components: hibernate-core Created: 26/Sep/2022 00:30 AM Environment: Hibernate 6.1.3 JPA 3.0 JDK 11 Labels: MultipleBagFetchException bag duplicates Priority: Minor Reporter: naizarak ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ac8b46... ) Fetching multiple bags isn't allowed and throws a 'MultipleBagFetchException'. However multi-fetching a bag with a non-bag collection is allowed even though it also produces indeterminate duplicate values (i.e. can't differentiate deliberate vs cartesian duplicates). Logically this operation should also be illegal, otherwise it yields an incorrect representation of the object state. ( https://hibernate.atlassian.net/browse/HHH-15547#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15547#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#100207- sha1:1c92a42 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15545) @NotFound(Ignore) defaults to eager loading

by Manuel O (JIRA)

Manuel O ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HHH-15545 ( https://hibernate.atlassian.net/browse/HHH-15545?atlOrigin=eyJpIjoiZDAzZm... ) Re: @NotFound(Ignore) defaults to eager loading ( https://hibernate.atlassian.net/browse/HHH-15545?atlOrigin=eyJpIjoiZDAzZm... ) depends how you see it - is that the bug? I just see there a change in the behavior and in https://hibernate.atlassian.net/browse/HHH-15060 ( https://hibernate.atlassian.net/browse/HHH-15060 ) was a test an new bug requested!? ( https://hibernate.atlassian.net/browse/HHH-15545#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15545#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#100207- sha1:1c92a42 )

2 years, 2 months

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 September 2022