April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16312) function with collection makes NullPointerException

by Florian Hof (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4839) Test Hibernate Search regularly against the latest version of Lucene

by Yoann Rodière (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HSEARCH-4839) Test Hibernate Search regularly against the latest version of Lucene

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=eyJpIjoiZTgxZjM2... ) / Task ( https://hibernate.atlassian.net/browse/HSEARCH-4839?atlOrigin=eyJpIjoiZTg... ) HSEARCH-4839 ( https://hibernate.atlassian.net/browse/HSEARCH-4839?atlOrigin=eyJpIjoiZTg... ) Test Hibernate Search regularly against the latest version of Lucene ( https://hibernate.atlassian.net/browse/HSEARCH-4839?atlOrigin=eyJpIjoiZTg... ) Issue Type: Task Assignee: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: backend-lucene, integration, tests Created: 21/Apr/2023 01:19 AM Fix Versions: 6.2-backlog Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) We already have branches such as wip/main/dependency-update/jandex and a Jenkins job to test Hibernate Search against the latest version of Jandex. I think it would be useful to also test against the latest version of Lucene (9.x), even if we currently can’t upgrade to that version (it requires JDK 11+), just so we are aware of features removed in Lucene 9.x. I’m thinking about highlighting in particular, since I suspect some highlighting features are only there for historical reasons and might be removed at some point. This would require: * adding something to the settings() function in ci/dependency-update/Jenkinsfile * adding something to the matrix axes in ci/dependency-update/Jenkinsfile * adding dependency update rules under ci/dependency-update * creating a branch wip/main/dependency-update/lucene-9 with a few commits to upgrade to JDK 11 and to address whatever changes are necessary in the Lucene backend. We can use the ticket keys https://hibernate.atlassian.net/browse/HSEARCH-4556 and https://hibernate.atlassian.net/browse/HSEARCH-4393 for those commits. ( https://hibernate.atlassian.net/browse/HSEARCH-4839#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4839#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#100223- sha1:bddbaa2 )

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16496) CLONE - Join fetching nested @OneToMany collections causes result multiplication

by Marco Belladelli (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16496) CLONE - Join fetching nested @OneToMany collections causes result multiplication

by Marco Belladelli (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=eyJpIjoiOTg5ZT... ) Re: Hibernate repeatedly issues identical SELECT queries to load an optional one-to-one association ( https://hibernate.atlassian.net/browse/HHH-16469?atlOrigin=eyJpIjoiOTg5ZT... ) Hi, Andrea, I figured out the reason why the 4th query is different between our test cases. I have the property hibernate.max_fetch_depth set to 1 in the SessionFactory of my environment and that property is not set in the SessionFactory of your test class. If you add this line to your settings then you will see the extra queries: @Setting(name=AvailableSettings.MAX_FETCH_DEPTH, value = "1"), Now the question is: If there is no row in the AGENCY_DETAIL table for the agency, there are as many extra SELECT FROM AGENCY_DETAIL queries as the number of rows in the GROUP_USER table. However, If there is one row in the AGENCY_DETAIL table for the agency, then there is NO extra SELECT FROM AGENCY_DETAIL query. Do you have any insight why that’s the case? ( 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] (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=eyJpIjoiYjFiNj... ) Re: Hibernate repeatedly issues identical SELECT queries to load an optional one-to-one association ( https://hibernate.atlassian.net/browse/HHH-16469?atlOrigin=eyJpIjoiYjFiNj... ) Hi, Andrea, Thanks for the update. I downloaded your test class HHH-16469Test.java, and copied my entity beans into it, it loaded the Agency with just 4 queries you listed. However when I ran my test outside of your test class, I saw the extra queries I reported originally – [04/20/23 15:23:11.139] DEBUG : main : SQL - select t1_0.AGENCY_ID,a1_0.AGENCY_ID,a1_0.AGENCY_DETAIL,t1_0.AGENCY_NAME from TEST.AGENCY t1_0 left join TEST.AGENCY_DETAIL a1_0 on a1_0.AGENCY_ID=t1_0.AGENCY_ID where t1_0.AGENCY_ID=? [04/20/23 15:23:11.140] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:11.292] DEBUG : main : SQL - select u1_0.AGENCY_ID,u1_0.USER_ID,u1_0.USER_NAME from TEST.USER u1_0 where u1_0.AGENCY_ID=? [04/20/23 15:23:11.292] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:11.388] DEBUG : main : SQL - select g1_0.AGENCY_ID,g1_0.GROUP_ID,g1_0.GROUP_NAME from TEST.GROUP g1_0 where g1_0.AGENCY_ID=? [04/20/23 15:23:11.388] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:11.499] DEBUG : main : SQL - select u1_0.GROUP_ID,u1_1.USER_ID,a1_0.AGENCY_ID,a1_0.AGENCY_NAME,u1_1.USER_NAME from TEST.GROUP_USER u1_0 join TEST.USER u1_1 on u1_1.USER_ID=u1_0.USER_ID left join TEST.AGENCY a1_0 on a1_0.AGENCY_ID=u1_1.AGENCY_ID where u1_0.GROUP_ID in(select g1_0.GROUP_ID from TEST.GROUP g1_0 where g1_0.AGENCY_ID=? ) [04/20/23 15:23:11.499] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:11.558] DEBUG : main : SQL - select t1_0.AGENCY_ID,t1_0.AGENCY_DETAIL from TEST.AGENCY_DETAIL t1_0 where t1_0.AGENCY_ID=? [04/20/23 15:23:11.558] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:11.649] DEBUG : main : SQL - select t1_0.AGENCY_ID,t1_0.AGENCY_DETAIL from TEST.AGENCY_DETAIL t1_0 where t1_0.AGENCY_ID=? [04/20/23 15:23:11.649] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:11.739] DEBUG : main : SQL - select t1_0.AGENCY_ID,t1_0.AGENCY_DETAIL from TEST.AGENCY_DETAIL t1_0 where t1_0.AGENCY_ID=? [04/20/23 15:23:11.740] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:11.837] DEBUG : main : SQL - select t1_0.AGENCY_ID,t1_0.AGENCY_DETAIL from TEST.AGENCY_DETAIL t1_0 where t1_0.AGENCY_ID=? [04/20/23 15:23:11.837] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:11.937] DEBUG : main : SQL - select t1_0.AGENCY_ID,t1_0.AGENCY_DETAIL from TEST.AGENCY_DETAIL t1_0 where t1_0.AGENCY_ID=? [04/20/23 15:23:11.937] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:12.037] DEBUG : main : SQL - select t1_0.AGENCY_ID,t1_0.AGENCY_DETAIL from TEST.AGENCY_DETAIL t1_0 where t1_0.AGENCY_ID=? [04/20/23 15:23:12.037] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:12.137] DEBUG : main : SQL - select t1_0.AGENCY_ID,t1_0.AGENCY_DETAIL from TEST.AGENCY_DETAIL t1_0 where t1_0.AGENCY_ID=? [04/20/23 15:23:12.137] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] [04/20/23 15:23:12.237] DEBUG : main : SQL - select t1_0.AGENCY_ID,t1_0.AGENCY_DETAIL from TEST.AGENCY_DETAIL t1_0 where t1_0.AGENCY_ID=? [04/20/23 15:23:12.237] TRACE : main : bind - binding parameter [1] as [INTEGER] - [1] As you can see, the first 3 queries are identical to yours. However the 4th query ( SELECT FROM TEST.GROUP_USER ) (in red above) does not join with the AGENCY_DETAIL table in my case, and that resulted in the extra 8 subsequent ( SELECT FROM TEST.AGENCY_DETAIL ) queries. I will continue to look at my end. Can you think of a code path where Hibernate generates these extra select queries? I am running hibernate 6.2.1.Final on JDK 20. ( 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-4827) Only allow nesting-aware projections within `object` projections

by Automation for Jira (JIRA)

1 year, 6 months

1
0
0 / 0

[JIRA] (HHH-16483) Hibernate 6.2.0 Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error

by ukonnra (JIRA)

ukonnra ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=629aa08... ) *commented* on HHH-16483 ( https://hibernate.atlassian.net/browse/HHH-16483?atlOrigin=eyJpIjoiZDFjNj... ) Re: Hibernate 6.2.0 Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error ( https://hibernate.atlassian.net/browse/HHH-16483?atlOrigin=eyJpIjoiZDFjNj... ) https://hibernate.atlassian.net/browse/HHH-16483?focusedCommentId=111328 Hi, the test case is updated. https://github.com/UkonnRa/HHH-16483 ( https://hibernate.atlassian.net/secure/attachment/50316/50316_image-20230... ) ( https://hibernate.atlassian.net/browse/HHH-16483#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16483#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 Yoann Rodière (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