April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16425) Can not perform some aggregates over subquery

by Čedomir Igaly (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16425) Can not perform some aggregates over subquery

by Čedomir Igaly (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16425) Can not perform some aggregates over subquery

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjg5NmQxMjAx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiMjg5Nm... ) HHH-16425 ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiMjg5Nm... ) Can not perform some aggregates over subquery ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiMjg5Nm... ) Issue Type: Bug Affects Versions: 6.1.7, 6.2.0 Assignee: Unassigned Components: hibernate-core Created: 03/Apr/2023 10:10 AM Priority: Major Reporter: Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Some aggregates can not be used over subqueries. select a.name, sum(a.amount) from (select name as name, amount as amount from EntityB) as a group by a.name is not working in both 6.1 and 6.2 versions select a.name, min(a.amount) from (select name as name, amount as amount from EntityB) as a group by a.name and select a.name, max(a.amount) from (select name as name, amount as amount from EntityB) as a group by a. are not working in 6.1, but working in 6.2 ( https://hibernate.atlassian.net/browse/HHH-16425#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16425#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:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16272) Hibernate 6 fails to refresh when collections are accessed in entity setter method when access type is property

by Scott Marlow (JIRA)

Scott Marlow ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16272 ( https://hibernate.atlassian.net/browse/HHH-16272?atlOrigin=eyJpIjoiMWU3Mm... ) Re: Hibernate 6 fails to refresh when collections are accessed in entity setter method when access type is property ( https://hibernate.atlassian.net/browse/HHH-16272?atlOrigin=eyJpIjoiMWU3Mm... ) I’m not yet sure why but the change for this pr seems to cause a WildFly test failure WFLY-17830 ( https://issues.redhat.com/browse/WFLY-17830 ) that blocks https://github.com/wildfly/wildfly/pull/16684. To recreate, cd wildfly/testsuite/integration/basic mvn install -Dtest=org.jboss.as.test.integration.jpa.hibernate.sessionfactorytest.SessionFactoryTestCase ( https://hibernate.atlassian.net/browse/HHH-16272#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16272#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:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16418) Request clearer logged error message when @GeneratedValue stategy = IDENTITY and USE_GET_GENERATED_KEYS setting is false

by Jan Schatteman (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16401) Hibernate does not escape Parameters correctly when using Oracle which causes ORA-00904

by Christoph Aigensberger (JIRA)

Christoph Aigensberger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a72294... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYTQ5NDY4ZDU5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiYTQ5ND... ) HHH-16401 ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiYTQ5ND... ) Hibernate does not escape Parameters correctly when using Oracle which causes ORA-00904 ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiYTQ5ND... ) Change By: Christoph Aigensberger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a72294... ) I have updated to the latest Development Version, and I am now seeing ORA-00904 poping up all over my Spring Boot development environment. JDBC exception executing SQL [… (b1_0.field1!=K or (b1_0. field1 field !=H …] [ORA-00904: "H": invalid identifier ] [n/a]; SQL [n/a] It seems like HQL Parameters are incorrectly escaped This is how they look in the HQL … test.field1='K' or test.field<>'H' … The same issue arrises when a Boolean with a converter is converted to a String. I.e. lets take a converter that translates true → “Y” and false → “N“ JDBC exception executing SQL [… (b1_0.field1=Y …] [ORA-00904: "Y": invalid identifier ] [n/a]; SQL [n/a] This is how the query looks in the HQL … test.field1= true … Is this a issue caused by Hibernate or should I reach out to Spring Data? I am also unsure how to build a test case for this as it only seems to apply to Oracle, I still attempted it, but was unable to reproduce it on my end with it ( https://hibernate.atlassian.net/browse/HHH-16401#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16401#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:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4832) Upgrade to Elasticsearch client 8.7.0 and add compatibility with Elasticsearch 8.7.0

by Marko Bekhta (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16413) Subquery with multiple left joins broken in 6.2.0

by Marco Belladelli (JIRA)

1 year, 2 months

1
0
0 / 0

[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... ) *resolved* as *Fixed* Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWUxNWQyZmE0... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16414?atlOrigin=eyJpIjoiMWUxNW... ) HHH-16414 ( https://hibernate.atlassian.net/browse/HHH-16414?atlOrigin=eyJpIjoiMWUxNW... ) Improve table group resolution for subqueries using the same alias as parent ( https://hibernate.atlassian.net/browse/HHH-16414?atlOrigin=eyJpIjoiMWUxNW... ) Change By: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) Fix versions: 6.2.1 Resolution: Fixed Status: Open Resolved ( 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:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16424) dot id subquery

by Christian Beikov (JIRA)

1 year, 2 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