August 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-17067) Incorrect native SQL when joining entity with inheritance

by Ruslan Gryn (JIRA)

Ruslan Gryn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZWY2OTg2NzM4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiZWY2OT... ) HHH-17067 ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiZWY2OT... ) Incorrect native SQL when joining entity with inheritance ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiZWY2OT... ) Change By: Ruslan Gryn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I discovered this issue during migration to Spring Boot 3 and Hibernate 6.2 The problem is that Hibernate 6 generates invalid native SQL and the SQL is correct when using Hibernate 5 We have the following entity which has a reference to the {{parent}} class(abstract class) {noformat} @Entity public class Main { @Id private Long id; @OneToMany(mappedBy = "main") private Collection<Parent> parents = new HashSet<>(); }{noformat} {{Parent}} class {noformat}@Entity @Inheritance(strategy = InheritanceType.JOINED) public abstract class Parent { @Id private Long id; @ManyToOne private Main main; }{noformat} and implementation of the {{parent}} class {noformat}@Entity public class Child extends Parent { @Column private String data; }{noformat} You will get incorrect native SQL when executing the following query {{select s from Main s left join s.parents as p left join Child c on c = p where c.data is not null}} The error {noformat}org.hibernate.exception.SQLGrammarException: could not prepare statement [Column "C1_1.ID" not found; SQL statement: select m1_0.id from Main m1_0 left join (Parent p1_0 left join Child p1_1 on p1_0.id=p1_1.id) on m1_0.id=p1_0.main_id left join Child c1_0 on c1_1.id=p1_1.id where c1_0.data is not null [42122-220]] [select m1_0.id from Main m1_0 left join (Parent p1_0 left join Child p1_1 on p1_0.id=p1_1.id) on m1_0.id=p1_0.main_id left join Child c1_0 on c1_1.id=p1_1.id where c1_0.data is not null] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:187) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:152){noformat} This query works fine on Hibernate 5 without issues The workaround to join entities using ids for example {{left join Child c on c.id = p.id}} I’ve attached a reproducer. The reproducer in {{ORMStandaloneTestCase}} class ( https://hibernate.atlassian.net/browse/HHH-17067#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17067#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#100234- sha1:6fcbbaf )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17067) Incorrect native SQL when joining entity with inheritance

by Ruslan Gryn (JIRA)

Ruslan Gryn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYTE3ZTBkN2Mw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiYTE3ZT... ) HHH-17067 ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiYTE3ZT... ) Incorrect native SQL when joining entity with inheritance ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiYTE3ZT... ) Issue Type: Bug Affects Versions: 6.2.7 Assignee: Unassigned Attachments: orm.zip Components: hibernate-core Created: 10/Aug/2023 08:49 AM Environment: Linux Postgres h2 Java 17 Priority: Major Reporter: Ruslan Gryn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I discovered this issue during migration to Spring Boot 3 and Hibernate 6.2 The problem is that Hibernate 6 generates invalid native SQL and the SQL is correct when using Hibernate 5 We have the following entity which has a reference to the parent class(abstract class) @Entity public class Main { @Id private Long id; @OneToMany(mappedBy = "main") private Collection<Parent> parents = new HashSet<>(); } Parent class @Entity @Inheritance(strategy = InheritanceType.JOINED) public abstract class Parent { @Id private Long id; @ManyToOne private Main main; } and implementation of the parent class @Entity public class Child extends Parent { @Column private String data; } You will get incorrect native SQL when executing the following query select s from Main s left join s.parents as p left join Child c on c = p where c.data is not null The error org.hibernate.exception.SQLGrammarException: could not prepare statement [Column "C1_1.ID" not found; SQL statement: select m1_0.id from Main m1_0 left join (Parent p1_0 left join Child p1_1 on p1_0.id=p1_1.id) on m1_0.id=p1_0.main_id left join Child c1_0 on c1_1.id=p1_1.id where c1_0.data is not null [42122-220]] [select m1_0.id from Main m1_0 left join (Parent p1_0 left join Child p1_1 on p1_0.id=p1_1.id) on m1_0.id=p1_0.main_id left join Child c1_0 on c1_1.id=p1_1.id where c1_0.data is not null] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:187) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:152) This query works on Hibernate 5 without issues The workaround to join entities using ids for example left join Child c on c.id = p.id I’ve attached a reproducer. The reproducer in ORMStandaloneTestCase class ( https://hibernate.atlassian.net/browse/HHH-17067#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17067#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#100234- sha1:6fcbbaf )

1 year, 1 month

1
0
0 / 0

[JIRA] (HBX-2575) Update version identifier to 5.3.31.Final

by Koen Aers (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HBX-2190) Make the tests run with the Oracle database

by Koen Aers (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HBX-2190) Make the tests run with the Oracle database

by Koen Aers (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HSEARCH-4915) Errors returned by OpenSearch/ElasticSearch not forwarded to caller

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4915 ( https://hibernate.atlassian.net/browse/HSEARCH-4915?atlOrigin=eyJpIjoiNTI... ) Re: Errors returned by OpenSearch/ElasticSearch not forwarded to caller ( https://hibernate.atlassian.net/browse/HSEARCH-4915?atlOrigin=eyJpIjoiNTI... ) FWIW fixing this will require using a different “result assessor”, i.e. setting a different value for field org.hibernate.search.backend.elasticsearch.work.impl.AbstractNonBulkableWork.AbstractBuilder#resultAssessor in org.hibernate.search.backend.elasticsearch.work.impl.SearchWork.Builder. ( https://hibernate.atlassian.net/browse/HSEARCH-4915#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4915#add-comment?atlOrigin... ) 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#100234- sha1:6fcbbaf )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16798) ClassCastException in Hibernate 6 when "join fetch" is used in a query with entity inheritance

by Marco Belladelli (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HSEARCH-4915) Errors returned by OpenSearch/ElasticSearch not forwarded to caller

by Yoann Rodière (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HBX-2564) Update Hibernate ORM Dependency to Version 5.3.31.Final

by Koen Aers (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HSEARCH-4915) Errors returned by OpenSearch/ElasticSearch not handled correctly

by Yoann Rodière (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 August 2023