March 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16414) Improve table group resolution for subqueries using the same alias as parent

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiY2UwYTRkZjI3... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16414?atlOrigin=eyJpIjoiY2UwYT... ) HHH-16414 ( https://hibernate.atlassian.net/browse/HHH-16414?atlOrigin=eyJpIjoiY2UwYT... ) Improve table group resolution for subqueries using the same alias as parent ( https://hibernate.atlassian.net/browse/HHH-16414?atlOrigin=eyJpIjoiY2UwYT... ) Issue Type: Improvement Affects Versions: 6.2.0 Assignee: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) Created: 31/Mar/2023 11:29 AM Priority: Major Reporter: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) With https://hibernate.atlassian.net/browse/HHH-16396 the resolution of {{TableGroup}}s inside subqueries was changed to correctly handle cases where the same alias was used in both the parent query and the internal one. This issue follows up on that work by improving the logic and handling some edge cases. ( https://hibernate.atlassian.net/browse/HHH-16414#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16414#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-16413) Subquery with multiple left joins broken in 6.2.0

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16413 ( https://hibernate.atlassian.net/browse/HHH-16413?atlOrigin=eyJpIjoiMjQ3OT... ) Re: Subquery with multiple left joins broken in 6.2.0 ( https://hibernate.atlassian.net/browse/HHH-16413?atlOrigin=eyJpIjoiMjQ3OT... ) How did you generate this query? It would be nice if you could provide a reproducer, you can start from our test case templates ( https://github.com/hibernate/hibernate-test-case-templates ). ( https://hibernate.atlassian.net/browse/HHH-16413#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16413#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-16413) Subquery with multiple left joins broken in 6.2.0

by Andreas Asplund (JIRA)

Andreas Asplund ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNDRjZmVkNTg5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16413?atlOrigin=eyJpIjoiNDRjZm... ) HHH-16413 ( https://hibernate.atlassian.net/browse/HHH-16413?atlOrigin=eyJpIjoiNDRjZm... ) Subquery with multiple left joins broken in 6.2.0 ( https://hibernate.atlassian.net/browse/HHH-16413?atlOrigin=eyJpIjoiNDRjZm... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Created: 31/Mar/2023 08:38 AM Priority: Major Reporter: Andreas Asplund ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Subquery with multiple joins broken in 6.2.0. With 6.2.0.CR4 the SQL sub select with joins is correct. select s1_0.id,s1_0.name from some_object_1 s1_0 where s1_0.id in( select a1_0.object_id_identity from acl_object_identity a1_0 left join acl_entry a2_0 on a1_0.id=a2_0.acl_object_identity left join acl_sid s2_0 on s2_0.id=a2_0.sid left join acl_class o1_0 on o1_0.id=a1_0.object_id_class left join acl_sid o2_0 on o2_0.id=a1_0.owner_sid where o1_0.class=? and (a2_0.granting=? and a2_0.mask>=? and s2_0.sid in(?,?) or o2_0.sid in(?,?) and o2_0.principal=?) ) But with 6.2.0.Final the left joins after the first left join becomes joins. select s1_0.id,s1_0.name from some_object_1 s1_0 where s1_0.id in( select a1_0.object_id_identity from acl_object_identity a1_0 left join acl_entry a2_0 on a1_0.id=a2_0.acl_object_identity join acl_sid s3_0 on s3_0.id=a2_0.sid join acl_class o3_0 on o3_0.id=a1_0.object_id_class join acl_sid o4_0 on o4_0.id=a1_0.owner_sid where o3_0.class=? and (a2_0.granting=? and a2_0.mask>=? and s3_0.sid in(?,?) or o4_0.sid in(?,?) and o4_0.principal=?) ) I tracked it down to https://hibernate.atlassian.net/browse/HHH-16396. Removing commit https://github.com/hibernate/hibernate-orm/commit/fb174d19c7fd41e597af066... restores the functionality. ( https://hibernate.atlassian.net/browse/HHH-16413#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16413#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-16406) Error in PaginationTest

by Jan Schatteman (JIRA)

1 year

1
0
0 / 0

[JIRA] (HHH-16406) Error in PaginationTest

by Jan Schatteman (JIRA)

1 year

1
0
0 / 0

[JIRA] (HHH-16406) Error in PaginationTest

by Jan Schatteman (JIRA)

1 year

1
0
0 / 0

[JIRA] (HHH-16385) QueryKey not serializable when working with @TenantId

by Alexis Hassler (JIRA)

Alexis Hassler ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16385 ( https://hibernate.atlassian.net/browse/HHH-16385?atlOrigin=eyJpIjoiMmFjYm... ) Re: QueryKey not serializable when working with @TenantId ( https://hibernate.atlassian.net/browse/HHH-16385?atlOrigin=eyJpIjoiMmFjYm... ) I could reproduce the issue with Hibernate 6.2.0.Final, when enabling query cache and a filter. I’ve added a link to an example that reproduces the bug. ( https://hibernate.atlassian.net/browse/HHH-16385#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16385#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-16299) Hibernate 6.2.0.CR3 does not deploy to Payara Micro due to java.lang.ClassCircularityError

by Martin Charlesworth (JIRA)

Martin Charlesworth ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a98884... ) *commented* on HHH-16299 ( https://hibernate.atlassian.net/browse/HHH-16299?atlOrigin=eyJpIjoiYzVlNz... ) Re: Hibernate 6.2.0.CR3 does not deploy to Payara Micro due to java.lang.ClassCircularityError ( https://hibernate.atlassian.net/browse/HHH-16299?atlOrigin=eyJpIjoiYzVlNz... ) Cédric Tabin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) thanks Cedric I didn’t get around to doing that. ( https://hibernate.atlassian.net/browse/HHH-16299#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16299#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-16387) Entity in key not returned when querying

by Andrea Boriero (JIRA)

1 year

1
0
0 / 0

[JIRA] (HSEARCH-4828) Lucene's unified highlighter should produce multiple highlighted snippets for multi-valued fields

by Yoann Rodière (JIRA)

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