April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16487) Invalid SQL query with unexpected join created for JPQL where clause

by Dennis van Holsteijn (JIRA)

Dennis van Holsteijn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjUxZjE3Njk1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16487?atlOrigin=eyJpIjoiMjUxZj... ) HHH-16487 ( https://hibernate.atlassian.net/browse/HHH-16487?atlOrigin=eyJpIjoiMjUxZj... ) Invalid SQL query with unexpected join created for JPQL where clause ( https://hibernate.atlassian.net/browse/HHH-16487?atlOrigin=eyJpIjoiMjUxZj... ) Issue Type: Bug Affects Versions: 6.1.7, 6.2.0, 6.2.1 Assignee: Unassigned Attachments: class-hierarchy.png Components: hibernate-core Created: 18/Apr/2023 06:47 AM Priority: Major Reporter: Dennis van Holsteijn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) JPQL where clause causes unexpected joins in resulting SQL query in the following scenario: * Class hierarchy with @Inheritance(strategy = InheritanceType.JOINED) , see image: * Class ImageItem has self-reference via ImageItem#original and ImageItem#thumbnail The following JPQL query: select i from ImageItem i where i.original is null and i.thumbnail is not null creates SQL query: Hibernate: select i1_0.id, case when i1_1.id is not null then 3 when i1_0.id is not null then 1 when i1_2.id is not null then 0 end, i1_2.fileName, i1_0.height, i1_0.original_id, i1_0.thumbnail_id, i1_0.width, i1_1.croppedHeight, i1_1.croppedWidth, i1_1.leftPosition, i1_1.presetKey, i1_1.topPosition from ImageItem i1_0 left join PartialImage i1_1 on i1_0.id=i1_1.id join MediaItem i1_2 on i1_0.id=i1_2.id join ImageItem o1_0 on o1_0.id=i1_0.original_id join ImageItem t1_0 on t1_0.id=i1_0.thumbnail_id where i1_0.original_id is null and i1_0.thumbnail_id is not null Due to the inner join: join ImageItem o1_0 on o1_0.id=i1_0.original_id This query will never return ImageItems where original is null! See testcase: https://github.com/dvholsteijn/hibernate-6-invalid-sql/tree/main In hibernate 5.6.15 a correct query is created, see testcase: https://github.com/dvholsteijn/hibernate-6-invalid-sql/tree/hibernate-5 ( https://hibernate.atlassian.net/browse/HHH-16487#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16487#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:c08beee )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16236) Cannot use lists and Enums in where clause

by German Chyzhov (JIRA)

German Chyzhov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16236 ( https://hibernate.atlassian.net/browse/HHH-16236?atlOrigin=eyJpIjoiNjdlMD... ) Re: Cannot use lists and Enums in where clause ( https://hibernate.atlassian.net/browse/HHH-16236?atlOrigin=eyJpIjoiNjdlMD... ) Same problem, that Enums does not work with Postgres in 6.1.7, I need to cast enums to strings every time I perform a query ( https://hibernate.atlassian.net/browse/HHH-16236#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16236#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:c08beee )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16392) @Where annotation generates bad query with entity name instead of alias in association subquery

by Marco Belladelli (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16392) @Where annotation generates bad query with entity name instead of alias in association subquery

by Marco Belladelli (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16435) Discriminators are completely ignored when Filter is active

by Jan Schatteman (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16435) Discriminators are completely ignored when Filter is active

by Jan Schatteman (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16435) Discriminators are completely ignored when Filter is active

by Jan Schatteman (JIRA)

Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16435 ( https://hibernate.atlassian.net/browse/HHH-16435?atlOrigin=eyJpIjoiYjU3MG... ) Re: Discriminators are completely ignored when Filter is active ( https://hibernate.atlassian.net/browse/HHH-16435?atlOrigin=eyJpIjoiYjU3MG... ) Indeed it is, forgot to set the fix version, my bad, apologies for that ( https://hibernate.atlassian.net/browse/HHH-16435#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16435#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:c08beee )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16362) SemanticException while checking JOIN FETCH owners for nested associations

by Marco Belladelli (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16362) SemanticException while checking JOIN FETCH owners for nested associations

by Marco Belladelli (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16435) Discriminators are completely ignored when Filter is active

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16435 ( https://hibernate.atlassian.net/browse/HHH-16435?atlOrigin=eyJpIjoiMTdhYm... ) Re: Discriminators are completely ignored when Filter is active ( https://hibernate.atlassian.net/browse/HHH-16435?atlOrigin=eyJpIjoiMTdhYm... ) One question: is this included in 6.2.1 version? Looking at github it seems so, but the Jira has no “fix version”. Thanks ( https://hibernate.atlassian.net/browse/HHH-16435#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16435#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:c08beee )

2 years, 12 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues April 2023