June 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16856) Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16856 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiNWQ3NT... ) Re: Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiNWQ3NT... ) Hi Sebastiaan van den Broek ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , can you please provide a test case? you can use https://github.com/hibernate/hibernate-test-case-templates/tree/main/orm/... to create it. Thanks! ( https://hibernate.atlassian.net/browse/HHH-16856#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16856#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#100227- sha1:3bc807d )

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4884) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document

by Automation for Jira (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16856) Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1

by Sebastiaan van den Broek (JIRA)

Sebastiaan van den Broek ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16856 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiMmE2MD... ) Re: Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiMmE2MD... ) The query inSpring Boot 3.1.0/Hibernate 6.2.2 is fine: Hibernate: select a1_0.id,a1_0.created_date,a1_0.db_version,a1_0.expiry_date,a1_0.last_used,a1_0.name,a1_0.project_id,a1_0.public_part,a1_0.role_id,a1_0.secret_key_hash,a1_0.updated_date from api_key a1_0 left join role r1_0 on r1_0.id=a1_0.role_id where a1_0.project_id=? order by r1_0.name offset ? rows fetch first ? rows only ( https://hibernate.atlassian.net/browse/HHH-16856#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16856#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#100227- sha1:3bc807d )

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4884) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiMjIxZmMy... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiMjI... ) HSEARCH-4884 ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiMjI... ) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiMjI... ) Change By: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Essentially [https://hibernate.atlassian.net/browse/HSEARCH-4845|https://hibernate.atl...] , but as an option, and disabled by default. We know [https://hibernate.atlassian.net/browse/HSEARCH-4845|https://hibernate.atl...] is a breaking change, and we also know there’s no way around it if we upgrade to Lucene 9. This configuration option will provide a bit more flexibility regarding _when_ integrators actually break compatibility. I suspect this will be necessary for integrators such as EAP which need these incompatible change ADAP ASAP due to their release schedule. ( https://hibernate.atlassian.net/browse/HSEARCH-4884#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4884#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#100227- sha1:3bc807d )

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4884) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiY2I0NTk3... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiY2I... ) HSEARCH-4884 ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiY2I... ) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiY2I... ) Change By: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Essentially [https://hibernate.atlassian.net/browse/ HSEARCH-4845 |https://hibernate.atlassian.net/browse/HSEARCH-4845|smart-link] , but as an option, and disabled by default. We know [https://hibernate.atlassian.net/browse/HSEARCH-4845|https://hibernate.atl...] is a breaking change, and we also know there’s no way around it if we upgrade to Lucene 9. This configuration option will provide a bit more flexibility regarding _when_ integrators actually break compatibility. I suspect this will be necessary for integrators such as EAP which need these incompatible change ADAP due to their release schedule. ( https://hibernate.atlassian.net/browse/HSEARCH-4884#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4884#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#100227- sha1:3bc807d )

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16856) Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1

by Sebastiaan van den Broek (JIRA)

Sebastiaan van den Broek ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjgwZDU1MzU5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiMjgwZD... ) HHH-16856 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiMjgwZD... ) Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiMjgwZD... ) Issue Type: Bug Affects Versions: 6.2.5 Assignee: Unassigned Created: 26/Jun/2023 23:42 PM Environment: Java 17 and 20, Ubuntu and Windows 11. Priority: Major Reporter: Sebastiaan van den Broek ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Repository method defines a LEFT JOIN, as we need to sort on something in role, but it is an optional foreign key. @Query(""" SELECT ak FROM ApiKey ak LEFT JOIN ak.role r WHERE ak.projectId = :projectId """) Page<ApiKey> find(@Param("projectId") UUID projectId, Pageable pageable); Generated SQL creates a regular JOIN now, which means results go missing. Hibernate: select a1_0.id,a1_0.created_date,a1_0.db_version,a1_0.expiry_date,a1_0.last_used,a1_0.name,a1_0.project_id,a1_0.public_part,a1_0.role_id,a1_0.secret_key_hash,a1_0.updated_date from api_key a1_0 join role r2_0 on r2_0.id=a1_0.role_id where a1_0.project_id=? order by r2_0.name offset ? rows fetch first ? rows only ( https://hibernate.atlassian.net/browse/HHH-16856#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16856#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#100227- sha1:3bc807d )

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4884) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document

by Yoann Rodière (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4884) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document

by Yoann Rodière (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4884) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiMzhjYWQ0... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiMzh... ) HSEARCH-4884 ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiMzh... ) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiMzh... ) Issue Type: Improvement Assignee: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 26/Jun/2023 23:23 PM Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Essentially HSEARCH-4845 ( https://hibernate.atlassian.net/browse/HSEARCH-4845 ) Pull Request Sent , but as an option, and disabled by default. I suspect this will be necessary for integrators such as EAP which need these incompatible change ADAP due to their release schedule. ( https://hibernate.atlassian.net/browse/HSEARCH-4884#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4884#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#100227- sha1:3bc807d )

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4845) Have a dedicated docvalue field for the root document id in the Lucene backend's document

by Yoann Rodière (JIRA)

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