August 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-17028) Unrelated left join fails when query has multiple roots

by Christian Beikov (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-17028) Unrelated left join fails when query has multiple roots

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-17028 ( https://hibernate.atlassian.net/browse/HHH-17028?atlOrigin=eyJpIjoiZWJhOD... ) Re: Unrelated left join fails when query has multiple roots ( https://hibernate.atlassian.net/browse/HHH-17028?atlOrigin=eyJpIjoiZWJhOD... ) This is not a bug, but simply the semantics of the query language. The from clause has separate “spaces” which are separated syntactically by a comma. Every such “space” is isolated. If you want to be able to refer to aliases of other root nodes, then you will have to use a cross join instead. entityManager.createQuery(""" select r.name, u.someValue, oe.id from RootEntity r cross join OtherEntity oe left join UnrelatedEntity u on u.name = r.name """).getResultList(); ( https://hibernate.atlassian.net/browse/HHH-17028#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17028#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#100233- sha1:3ea1a2a )

11 months

1
0
0 / 0

[JIRA] (HHH-17030) Investigate performance drops

by Christian Beikov (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-17028) Unrelated left join fails when query has multiple roots

by Rastislav Budinsky (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-16919) Bidirectional mapping with @Any causes infinite loop on fetch

by Marco Belladelli (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-16918) Can't use the the primary id column as the joincolumn for @Any association

by Marco Belladelli (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-16918) Can't use the the primary id column as the joincolumn for @Any association

by Marco Belladelli (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-17019) EntityListener is not triggered for a LAZY loaded association when using bytecode enhancement

by Andrea Boriero (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-17029) Wrong translation of a DELETE JPQL Statement for H2 Database

by Igor Koropov (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-17029) Wrong translation of a DELETE JPQL Statement for H2 Database

by Igor Koropov (JIRA)

Igor Koropov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f75beb... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOTBhNjBkNTU0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-17029?atlOrigin=eyJpIjoiOTBhNj... ) HHH-17029 ( https://hibernate.atlassian.net/browse/HHH-17029?atlOrigin=eyJpIjoiOTBhNj... ) Wrong translation of a DELETE JPQL Statement for H2 Database ( https://hibernate.atlassian.net/browse/HHH-17029?atlOrigin=eyJpIjoiOTBhNj... ) Issue Type: Bug Affects Versions: 6.2.6 Assignee: Unassigned Attachments: delete-statement-failure.zip Created: 03/Aug/2023 01:17 AM Environment: JDK 20.0.2 Hibernate 6.2.6 Database H2 2.2.220 Priority: Major Reporter: Igor Koropov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f75beb... ) The concrete DELETE JPQL Statement is translated to wrong SQL statement for H2 underlying database. The test case provided as gradle project. Executing “gradle test” should be enough. ( https://hibernate.atlassian.net/browse/HHH-17029#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17029#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#100233- sha1:3ea1a2a )

11 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 August 2023