May 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16721) HQL with subquery with entity path at least two deep produces wrong SQL

by Nemanja Jovanovic (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16721) HQL with subquery with entity path at least two deep produces wrong SQL

by Nemanja Jovanovic (JIRA)

Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmM3YjhlY2Y3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16721?atlOrigin=eyJpIjoiNmM3Yj... ) HHH-16721 ( https://hibernate.atlassian.net/browse/HHH-16721?atlOrigin=eyJpIjoiNmM3Yj... ) HQL with subquery with entity path at least two deep produces wrong SQL ( https://hibernate.atlassian.net/browse/HHH-16721?atlOrigin=eyJpIjoiNmM3Yj... ) Issue Type: Bug Affects Versions: 6.2.2, 6.2.3 Assignee: Unassigned Created: 30/May/2023 08:46 AM Environment: If we have for example these entities: Priority: Major Reporter: Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) If we have for example these entities: @Entity class A implements Serializable { private static final long serialVersionUID = -5412503864464287451L; @Id @GeneratedValue long id; @ManyToOne B b; } @Entity class B implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue long id; @ManyToOne C c; } @Entity class C implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue long id; } HQL like this: select a.id from A a where exists (select b.id from B b where a.b.c.id = 5) will produce SQL: select a1_0.id from A a1_0 where exists(select b1_0.id from B b1_0,B b2_0 where b2_0.c_id=5) This is obviously wrong as b2_0 should be in correlation with a1_0 . Exists is not a factor here as this does not work with in either. Attached test contains more examples, see console output. ( https://hibernate.atlassian.net/browse/HHH-16721#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16721#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#100225- sha1:d82e018 )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16720) Fix for HHH-15759 broke our code

by Andrea Boriero (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16720) Fix for HHH-15759 broke our code

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16720 ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiNmE3NG... ) Re: Fix for HHH-15759 broke our code ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiNmE3NG... ) Hi Armen Chouldjian ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , please provide a test case so I can investigate the issue and work an a solution. Thanks ( https://hibernate.atlassian.net/browse/HHH-16720#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16720#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#100225- sha1:d82e018 )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16701) "persister" is null during validation with lazy collections

by Jan Schatteman (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16720) Fix for HHH-15759 broke our code

by Andrea Boriero (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16696) hibernate-core >= 6.2.0 stopped invoking PostgreSQLDialect.initializeFunctionRegistry(QueryEngine)

by Jan Schatteman (JIRA)

Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16696 ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiZDAwZG... ) Re: hibernate-core >= 6.2.0 stopped invoking PostgreSQLDialect.initializeFunctionRegistry(QueryEngine) ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiZDAwZG... ) I’m not sure I understand your difficulty; you shouldn’t have to do anything other than change the implementation you already have, that is, change @Override public void initializeFunctionRegistry(QueryEngine queryEngine) { super.initializeFunctionRegistry(queryEngine); queryEngine.getSqmFunctionRegistry().register(PostgresqlJsonArrayFunction.NAME, new PostgresqlJsonArrayFunction()); } to @Override public void initializeFunctionRegistry(FunctionContributions functionContributions) { super.initializeFunctionRegistry(functionContributions); functionContributions.getFunctionRegistry().register(PostgresqlJsonArrayFunction.NAME, new PostgresqlJsonArrayFunction()); } Let me know if this helps. ( https://hibernate.atlassian.net/browse/HHH-16696#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16696#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#100225- sha1:d82e018 )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16720) Fix for HHH-15759 broke our code

by Armen Chouldjian (JIRA)

Armen Chouldjian ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGUzMGMwNWUz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiMGUzMG... ) HHH-16720 ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiMGUzMG... ) Fix for HHH-15759 broke our code ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiMGUzMG... ) Issue Type: Bug Affects Versions: 6.1.7, 6.2.3 Assignee: Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 30/May/2023 08:37 AM Priority: Major Reporter: Armen Chouldjian ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hello Hibernate Team, My team and I have tried updating one of our main software projects from Hibernate 6.1.6 to 6.2.3 and we are unable to perform this upgrade due to an issue. I have dug around enough, and have figured out the particular commit which is causing the issue. The following code (hibernate-core/src/main/java/org/hibernate/mapping/Set.java:createPrimaryKey) needs to be looked at again and re-evaluated. I can provide a test-case in time, but as of right now, I do not have the test-case for you. Here is a link to the particular commit which prevents us from upgrading to 6.2.3: https://github.com/hibernate/hibernate-orm/commit/9341df0b8b5c1eee2a54efd... Old (working) code from 6.1.6 tag: void createPrimaryKey() { if ( !isOneToMany() ) { PrimaryKey pk = new PrimaryKey( getCollectionTable() ); pk.addColumns( getKey() ); New (broken) code from 6.2.3 tag: void createPrimaryKey() { if ( !isOneToMany() ) { final Table collectionTable = getCollectionTable(); PrimaryKey pk = collectionTable.getPrimaryKey(); if ( pk == null ) { pk = new PrimaryKey( getCollectionTable() ); } pk.addColumns( getKey() ); It looks like dreab8 ( *Andrea Boriero* ) was trying to solve this particular Jira ID: https://hibernate.atlassian.net/browse/HHH-15759 Now I am not sure what the final fix should be, as reverting this commit may cause the original issue to break as well, however I am certain that current state the code is in is not the correct solution, as it causes major breakage in our (very) large project. I would suggest playing around with a debugger to understand what is going on here. Here’s my annotation: @ElementCollection(fetch=FetchType.EAGER) @CollectionTable(name="interlocking",joinColumns=@JoinColumn(name="ctl_interlocking")) @Column(name="idn") private Set<Integer> ctlInterlockingInterlockingIdns = new HashSet<Integer>(); Here is the original exception I got: Exception in thread "main" org.hibernate.MappingException: Foreign key (FKntc3fe3p6srhxyr5cbmvtcq40:contact_rail_at_location [interlocking])) must have same number of columns as the referenced primary key (interlocking [idn,ctl_interlocking]) at org.hibernate.mapping.ForeignKey.alignColumns(ForeignKey.java:138) at org.hibernate.mapping.ForeignKey.alignColumns(ForeignKey.java:119) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.secondPassCompileForeignKeys(InFlightMetadataCollectorImpl.java:2010) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.secondPassCompileForeignKeys(InFlightMetadataCollectorImpl.java:1974) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processSecondPasses(InFlightMetadataCollectorImpl.java:1818) at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:328) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1380) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1451) at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:55) at jakarta.persistence.Persistence.createEntityManagerFactory(Persistence.java:80) at g.b.c.p.JpaManager.<init>(JpaManager.java:122) at g.b.i.r.c.SvgLoad.<init>(SvgLoad.java:47) at g.b.i.r.c.SvgLoad.main(SvgLoad.java:65) In our particular situation, we believe “idn” in this case should not be part of the referenced primary key (interlocking [idn,ctl_interlocking] ). That is the mistake that is breaking the code. ( https://hibernate.atlassian.net/browse/HHH-16720#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16720#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#100225- sha1:d82e018 )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16693) MappedSuperClass with generic collections not mapped correctly

by Marco Belladelli (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16693) MappedSuperClass with generic collections not mapped correctly

by Marco Belladelli (JIRA)

1 year, 1 month

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