March 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16307) Finish Gradle plugin DSL

by Steve Ebersole (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-15972) entitygraph load error when Inheritance JOINED is used in 6.1.6

by Steve Ebersole (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16303) Could not locate TableGroup

by Jasper Timmer (JIRA)

Jasper Timmer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=615bf6f... ) *commented* on HHH-16303 ( https://hibernate.atlassian.net/browse/HHH-16303?atlOrigin=eyJpIjoiNjY4MT... ) Re: Could not locate TableGroup ( https://hibernate.atlassian.net/browse/HHH-16303?atlOrigin=eyJpIjoiNjY4MT... ) Based on this thread I found a solution: https://discourse.hibernate.org/t/question-about-subselects-in-hibernate-... ( https://discourse.hibernate.org/t/question-about-subselects-in-hibernate-... ) We cannot reuse the Expression<Boolean> used for Where. We have to make two instances of the Expression with different Roots. I’m not sure if this is intended, I’m not deep into this matter. Our problem is solved, though. Sorry for using up an issue number 😉 Maybe the exception could be more clear? ( https://hibernate.atlassian.net/browse/HHH-16303#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16303#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#100217- sha1:fd7c927 )

3 years

1
0
0 / 0

[JIRA] (HHH-16318) Wrong SQL query generated when type() tested inside selectCase() expression

by Archie Cobbs (JIRA)

Archie Cobbs ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16318 ( https://hibernate.atlassian.net/browse/HHH-16318?atlOrigin=eyJpIjoiODkwZT... ) Re: Wrong SQL query generated when type() tested inside selectCase() expression ( https://hibernate.atlassian.net/browse/HHH-16318?atlOrigin=eyJpIjoiODkwZT... ) > > > > I’m currently re-working all of the treat optimizations for Hibernate 6 > and will try to finish that for 6.2.0.Final, but I doubt that we can > reasonably fix this in 5. > > Sounds good - thanks. For the record, I found a workaround for this. You can avoid the bug by changing expressions like cb.treat(animal, Dog.class) into ((From<?, Dog>)(Object)animal) , and then adding @SuppressWarnings of course. ( https://hibernate.atlassian.net/browse/HHH-16318#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16318#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#100217- sha1:fd7c927 )

3 years

1
0
0 / 0

[JIRA] (HHH-16318) Wrong SQL query generated when type() tested inside selectCase() expression

by Archie Cobbs (JIRA)

Archie Cobbs ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16318 ( https://hibernate.atlassian.net/browse/HHH-16318?atlOrigin=eyJpIjoiMmQ4ZD... ) Re: Wrong SQL query generated when type() tested inside selectCase() expression ( https://hibernate.atlassian.net/browse/HHH-16318?atlOrigin=eyJpIjoiMmQ4ZD... ) Some more debug info relating to the 5.6.15 test case… It appears that the problem is that the root does not have an alias (yet) when the JQL is generated. So then PathTypeExpression.render() invokes Root.getPathIdentifier() which returns getAlias() , which is null at that time. The resulting JQL looks like this: select case when type(null) in (:param0) then treat(generatedAlias0 as org.hibernate.bugs.Dog).numSpots else 0 end from Animal as generatedAlias0 Note the type(null) , which causes the problem. This, even though later we have Animal as generatedAlias0. The bug in the test case can be worked around with this patch: iff --git a/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java b/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java index b30891f..06c285c 100644 --- a/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java +++ b/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java @@ -47,6 +47,7 @@ public class JPAUnitTestCase { final CriteriaQuery<Integer> query = cb.createQuery(Integer.class); final Root<Animal> animal = query.from(Animal.class); + animal.alias("a"); final Expression<Boolean> isDog = JPAUtil.instanceOf(entityManager, animal, Dog.class); final Expression<Integer> numSpots = cb.<Integer>selectCase() So the fix is to somehow force alias generation sooner. ( https://hibernate.atlassian.net/browse/HHH-16318#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16318#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#100217- sha1:fd7c927 )

3 years

1
0
0 / 0

[JIRA] (HHH-16308) NullPointerException when using CriteriaBuilder.function() inside CriteriaBuilder.construct()

by Archie Cobbs (JIRA)

Archie Cobbs ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16308 ( https://hibernate.atlassian.net/browse/HHH-16308?atlOrigin=eyJpIjoiZjI0NW... ) Re: NullPointerException when using CriteriaBuilder.function() inside CriteriaBuilder.construct() ( https://hibernate.atlassian.net/browse/HHH-16308?atlOrigin=eyJpIjoiZjI0NW... ) Some more debug info… It appears that the problem is that the root does not have an alias (yet) when the JQL is generated. So then PathTypeExpression.render() invokes Root.getPathIdentifier() which returns getAlias() , which is null at that time. The resulting JQL looks like this: select case when type(null) in (:param0) then treat(generatedAlias0 as org.hibernate.bugs.Dog).numSpots else 0 end from Animal as generatedAlias0 Note the type(null) , which causes the problem. This, even though later we have Animal as generatedAlias0. The bug in the test case can be worked around with this patch: iff --git a/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java b/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java index b30891f..06c285c 100644 --- a/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java +++ b/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java @@ -47,6 +47,7 @@ public class JPAUnitTestCase { final CriteriaQuery<Integer> query = cb.createQuery(Integer.class); final Root<Animal> animal = query.from(Animal.class); + animal.alias("a"); final Expression<Boolean> isDog = JPAUtil.instanceOf(entityManager, animal, Dog.class); final Expression<Integer> numSpots = cb.<Integer>selectCase() So the fix is to somehow force alias generation sooner. ( https://hibernate.atlassian.net/browse/HHH-16308#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16308#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#100217- sha1:fd7c927 )

3 years

1
0
0 / 0

[JIRA] (HHH-16319) H6: Problem with order insert to table with batch is ON

by Danilov Roman (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-14197) Criteria API doubly-nested subquery generates invalid SQL - missing subquery root

by Archie Cobbs (JIRA)

Archie Cobbs ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14197 ( https://hibernate.atlassian.net/browse/HHH-14197?atlOrigin=eyJpIjoiZDQ0ZT... ) Re: Criteria API doubly-nested subquery generates invalid SQL - missing subquery root ( https://hibernate.atlassian.net/browse/HHH-14197?atlOrigin=eyJpIjoiZDQ0ZT... ) Hi Nathan, I was not able to @mention you via Jira so I’m hoping this comment will catch your eye… I have a few new juicy bugs for you to look at in case you’re interested: my recently filed bugs ( https://hibernate.atlassian.net/browse/HHH-14197?filter=-2&jql=reporter%2... ). Thanks. ( https://hibernate.atlassian.net/browse/HHH-14197#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14197#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#100217- sha1:fd7c927 )

3 years

1
0
0 / 0

[JIRA] (HHH-16318) Wrong SQL query generated when type() tested inside selectCase() expression

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16318 ( https://hibernate.atlassian.net/browse/HHH-16318?atlOrigin=eyJpIjoiMTI5MT... ) Re: Wrong SQL query generated when type() tested inside selectCase() expression ( https://hibernate.atlassian.net/browse/HHH-16318?atlOrigin=eyJpIjoiMTI5MT... ) Thanks for the test case. I’m currently re-working all of the treat optimizations for Hibernate 6 and will try to finish that for 6.2.0.Final, but I doubt that we can reasonably fix this in 5. ( https://hibernate.atlassian.net/browse/HHH-16318#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16318#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#100217- sha1:fd7c927 )

3 years

1
0
0 / 0

[JIRA] (HHH-16318) Wrong SQL query generated when type() tested inside selectCase() expression

by Christian Beikov (JIRA)

3 years

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 March 2023