April 2023 - hibernate-issues - Jboss List Archives

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

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16469 ( https://hibernate.atlassian.net/browse/HHH-16469?atlOrigin=eyJpIjoiMTZlZG... ) Re: Hibernate repeatedly issues identical SELECT queries to load an optional one-to-one association ( https://hibernate.atlassian.net/browse/HHH-16469?atlOrigin=eyJpIjoiMTZlZG... ) Hi Puhong You ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , I updated the test following your suggestions ( see https://github.com/dreab8/hibernate-test-case-templates/blob/HHH-16469/or... ) and Hibernate executes 4 queries select a1_0.AGENCY_ID, a2_0.AGENCY_ID, a2_0.AGENCY_DETAIL, a1_0.AGENCY_TXT from AGENCY_TABLE a1_0 left join AGENCY_DETAIL_TABLE a2_0 on a2_0.AGENCY_ID=a1_0.AGENCY_ID where a1_0.AGENCY_ID=? select u1_0.AGENCY_ID, u1_0.USER_ID, u1_0.USER_NAME from USER_TABLE u1_0 where u1_0.AGENCY_ID=? select g1_0.AGENCY_ID, g1_0.GROUP_ID, g1_0.GROUP_NAME from GROUP_TABLE g1_0 where g1_0.AGENCY_ID=? select u1_0.GROUP_ID, u1_1.USER_ID, a1_0.AGENCY_ID, a2_0.AGENCY_ID, a2_0.AGENCY_DETAIL, a1_0.AGENCY_TXT, u1_1.USER_NAME from GROUP_USER u1_0 join USER_TABLE u1_1 on u1_1.USER_ID=u1_0.USER_ID left join AGENCY_TABLE a1_0 on a1_0.AGENCY_ID=u1_1.AGENCY_ID left join AGENCY_DETAIL_TABLE a2_0 on a2_0.AGENCY_ID=a1_0.AGENCY_ID where u1_0.GROUP_ID in(select g1_0.GROUP_ID from GROUP_TABLE g1_0 where g1_0.AGENCY_ID=?) ( https://hibernate.atlassian.net/browse/HHH-16469#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16469#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#100222- sha1:57eb20e )

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4837) An Id projection within a multivalued nested object leads to unexpected results with the Lucene backend

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiODQ5MjI3... ) / Bug ( https://hibernate.atlassian.net/browse/HSEARCH-4837?atlOrigin=eyJpIjoiODQ... ) HSEARCH-4837 ( https://hibernate.atlassian.net/browse/HSEARCH-4837?atlOrigin=eyJpIjoiODQ... ) An Id projection within a multivalued nested object leads to unexpected results with the Lucene backend ( https://hibernate.atlassian.net/browse/HSEARCH-4837?atlOrigin=eyJpIjoiODQ... ) Issue Type: Bug Assignee: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: backend-lucene Created: 20/Apr/2023 01:28 AM Fix Versions: 6.2-backlog Priority: Major Reporter: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Even though we are planning to restrict usage of id projection - https://hibernate.atlassian.net/browse/HSEARCH-4827 we still want to allow it with that fromRoot projection. Calling currentLeafIdDocValues.advance( doc ); inside of an accumulating function leads to unpredictable projection results. ( https://hibernate.atlassian.net/browse/HSEARCH-4837#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4837#add-comment?atlOrigin... ) 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#100222- sha1:57eb20e )

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-1813) Fetch only fields needed for indexing during index build

by masrawi (JIRA)

masrawi ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-1813 ( https://hibernate.atlassian.net/browse/HSEARCH-1813?atlOrigin=eyJpIjoiOWN... ) Re: Fetch only fields needed for indexing during index build ( https://hibernate.atlassian.net/browse/HSEARCH-1813?atlOrigin=eyJpIjoiOWN... ) is there any update on this issue? ( https://hibernate.atlassian.net/browse/HSEARCH-1813#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-1813#add-comment?atlOrigin... ) 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#100222- sha1:57eb20e )

1 year, 6 months

1
0
0 / 0

[JIRA] (WEBSITE-642) Broken link: https://hibernate.org/downloads.

by Yoann Rodière (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16438) Left outer joins do not work with polymorphic entities due to use of discriminator in the main query condition

by Jan Schatteman (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16438) Left outer joins do not work with polymorphic entities due to use of discriminator in the main query condition

by Jan Schatteman (JIRA)

1 year, 6 months

1
0
0 / 0

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

by Puhong You (JIRA)

Puhong You ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16469 ( https://hibernate.atlassian.net/browse/HHH-16469?atlOrigin=eyJpIjoiMmVkOT... ) Re: Hibernate repeatedly issues identical SELECT queries to load an optional one-to-one association ( https://hibernate.atlassian.net/browse/HHH-16469?atlOrigin=eyJpIjoiMmVkOT... ) Hi, Andrea, Thanks for looking into this. I think your test initialization routine failed to establish the agency ↔︎ group and group ↔︎ user association properly. Can you try this instead? @BeforeAll public void setUp(SessionFactoryScope scope) { scope.inTransaction( session -> { Agency agency = new Agency( 1, "Test Agency" ); Group group = new Group( 1, "Test Group 1" ); agency.addGroup(group); for ( int i = 1; i < 9; i++ ) { User user = new User( i, "User " + i ); agency.addUser(user); group.addUser(user); } session.persist( agency ); } ); } This requires a addGroup() method be added to the Agency entity bean – public void addGroup(Group group){ if (groups == null){ groups = new HashSet<>(); } groups.add( group ); group.setAgency( this ); } Please check the database content after the initialization routine to see if the table contents look ok. Please let me know if you have any further questions. ( https://hibernate.atlassian.net/browse/HHH-16469#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16469#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#100222- sha1:cb3bdf0 )

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16492) Hibernate 6 does not auto flush when calling Query.stream()

by Andrea Boriero (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16494) Right or full joining on single tablepolymorphic entities gives incorrect results

by Jan Schatteman (JIRA)

Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTI5M2EzN2I0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16494?atlOrigin=eyJpIjoiMTI5M2... ) HHH-16494 ( https://hibernate.atlassian.net/browse/HHH-16494?atlOrigin=eyJpIjoiMTI5M2... ) Right or full joining on single tablepolymorphic entities gives incorrect results ( https://hibernate.atlassian.net/browse/HHH-16494?atlOrigin=eyJpIjoiMTI5M2... ) Change By: Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) See {{JoinWithSingleTableInheritanceTest}}.{{testRightJoinOnSingleTableInheritance}}`and {{JoinWithSingleTableInheritanceTest.testFullJoinOnSingleTableInheritance}} for examples of this. The problem is that the {{<tablealias>.dtype=xxx}}part gets added to the on clause, and this leads to incorrect results. [~accountid:557058:0222998d-a0c8-4789-91ec-6a92d10dfb9a] stated that that condition should be pushed down into the tablereference, e.g `ight join (select * from child_tbl where disc = 'child_a') c on ...` The aforementioned tests have been disabled for now, but should be reenabled when this is fixed. ( https://hibernate.atlassian.net/browse/HHH-16494#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16494#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#100222- sha1:cb3bdf0 )

1 year, 6 months

1
0
0 / 0

[JIRA] (HBX-2507) Update version identifier to 6.2.2.SNAPSHOT

by Koen Aers (JIRA)

1 year, 6 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 April 2023