April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16483) Hibernate 6.2.0 Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error

by ukonnra (JIRA)

ukonnra ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=629aa08... ) *commented* on HHH-16483 ( https://hibernate.atlassian.net/browse/HHH-16483?atlOrigin=eyJpIjoiNDA1Nz... ) Re: Hibernate 6.2.0 Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error ( https://hibernate.atlassian.net/browse/HHH-16483?atlOrigin=eyJpIjoiNDA1Nz... ) Checked, 6.2.1 has the same problem. ( https://hibernate.atlassian.net/browse/HHH-16483#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16483#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:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16483) Hibernate 6.2.0 Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error

by ukonnra (JIRA)

ukonnra ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=629aa08... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjNkNDkyZWUx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16483?atlOrigin=eyJpIjoiYjNkND... ) HHH-16483 ( https://hibernate.atlassian.net/browse/HHH-16483?atlOrigin=eyJpIjoiYjNkND... ) Hibernate 6.2.0 Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error ( https://hibernate.atlassian.net/browse/HHH-16483?atlOrigin=eyJpIjoiYjNkND... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Components: hibernate-core, query-criteria Created: 17/Apr/2023 16:49 PM Priority: Major Reporter: ukonnra ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=629aa08... ) The HQL version of CTE Recursive query works fine: with accountChainTable as ( select child.id id, child. name name , child.parent.id parent_id from Account child where upper (child. name ) like '% NAME %' union all select account.id, account. name , account.parent.id from Account account, accountChainTable chain where account.id = chain.parent_id ) select c.id, c. name , c.parent_id from accountChainTable c But the translated Criteria version will throw errors: final HibernateCriteriaBuilder builder = session.getCriteriaBuilder(); final var query = builder.createTupleQuery(); final var nonRecurQuery = builder.createTupleQuery(); final var nonRecurRoot = nonRecurQuery.from(Account.class); nonRecurQuery.multiselect( nonRecurRoot.get(Account_.id).alias( "id" ), nonRecurRoot.get(Account_.name).alias( "name" ), nonRecurRoot .get(Account_.parent) .get(Account_.id) .alias( "parent_id" )); nonRecurQuery.where( builder.like( builder.upper(nonRecurRoot.get(Account_.name)), "%LIABILITY%" )); final var accountChainTable = query.withRecursiveUnionAll( nonRecurQuery, (cte) -> { final var innerQuery = builder.createTupleQuery(); final var accountRoot = innerQuery.from(Account.class); final var cteRoot = innerQuery.from(cte); innerQuery.multiselect( accountRoot.get(Account_.id), accountRoot.get(Account_.name), accountRoot.get(Account_.parent).get(Account_.id)); innerQuery.where( builder.equal( accountRoot.get(Account_.id), cteRoot.get( "parent_id" ))); return innerQuery; }); final var root = query.from(accountChainTable); query.multiselect( root.get( "id" ), root.get( "name" ), root.get( "parent_id" )); for ( final var tuple : session.createQuery(query).list()) { log.info( "=== Account:" ); for ( final var item : tuple.toArray()) { log.info( " - item: {}" , item); } } The error is: java.lang.IllegalArgumentException: Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement@19b19f46 at org.hibernate.query.sqm.tree.SqmCopyContext$1.registerCopy(SqmCopyContext.java:40) at org.hibernate.query.sqm.tree.cte.SqmCteStatement.copy(SqmCteStatement.java:149) at org.hibernate.query.sqm.tree.select.AbstractSqmSelectQuery.copyCteStatements(AbstractSqmSelectQuery.java:73) at org.hibernate.query.sqm.tree.select.SqmSelectStatement.copy(SqmSelectStatement.java:125) at org.hibernate.query.sqm.tree.select.SqmSelectStatement.copy(SqmSelectStatement.java:42) at org.hibernate.query.sqm.internal.QuerySqmImpl.<init>(QuerySqmImpl.java:228) at org.hibernate.internal.AbstractSharedSessionContract.createCriteriaQuery(AbstractSharedSessionContract.java:1343) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:1304) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:120) Any idea? ( https://hibernate.atlassian.net/browse/HHH-16483#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16483#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:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16482) Convert Functions in StandardConverters to static methods that can be used as method references

by Steve Ebersole (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16481) Add a new WrapperArrayHandling for enabled JPA compliance

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzAyN2U2YjBk... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16481?atlOrigin=eyJpIjoiYzAyN2... ) HHH-16481 ( https://hibernate.atlassian.net/browse/HHH-16481?atlOrigin=eyJpIjoiYzAyN2... ) Add a new WrapperArrayHandling for enabled JPA compliance ( https://hibernate.atlassian.net/browse/HHH-16481?atlOrigin=eyJpIjoiYzAyN2... ) Issue Type: Improvement Assignee: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 17/Apr/2023 13:36 PM Fix Versions: 6.2.2 Priority: Major Reporter: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) The premise is simple - JPA explicitly requires support for both Character[] and Byte[]. I propose adding a new setting PICK ( CHOOSE , <your-name-here> , …) that becomes the default when AvailableSettings.JPA_COMPLIANCE is enabled. ( https://hibernate.atlassian.net/browse/HHH-16481#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16481#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:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16469) Hibernate repeatedly issues identical SELECT queries to load an optional one-to-one association

by Puhong You (JIRA)

Puhong You ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16469 ( https://hibernate.atlassian.net/browse/HHH-16469?atlOrigin=eyJpIjoiM2YwYj... ) Re: Hibernate repeatedly issues identical SELECT queries to load an optional one-to-one association ( https://hibernate.atlassian.net/browse/HHH-16469?atlOrigin=eyJpIjoiM2YwYj... ) Correction – agency_id needs to be populated when populating the USER and GROUP tables – INSERT INTO TEST.USER VALUES (1, ‘TEST USER 1’, 1); INSERT INTO TEST.USER VALUES (2, ‘TEST USER 2’, 1); INSERT INTO TEST.USER VALUES (3, ‘TEST USER 3’, 1); INSERT INTO TEST.USER VALUES (4, ‘TEST USER 4’, 1); INSERT INTO TEST.USER VALUES (5, ‘TEST USER 5’, 1); INSERT INTO TEST.USER VALUES (6, ‘TEST USER 6’1, 1); INSERT INTO TEST.USER VALUES (7, ‘TEST USER 7’, 1); INSERT INTO TEST.USER VALUES (8, ‘TEST USER 8’, 1); INSERT INTO TEST.GROUP VALUES(1, ‘TEST GROUP 1’, 1); ( https://hibernate.atlassian.net/browse/HHH-16469#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16469#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:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Thomas Bosch (JIRA)

Thomas Bosch ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c19f84... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiOWFjNm... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiOWFjNm... ) Hi Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) What is the current state of this ticket? Thanks. ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16480) TiDB Supported Foreign Keys and Cascade Delete at v7.0

by Cheese Wong (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16480) TiDB Supported Foreign Keys and Cascade Delete at v7.0

by Cheese Wong (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16477) LAZY @ManyToOne may again break EAGER @ManyToOne when used on the same entity in a different parent with Bytecode Enhancement

by Andrea Boriero (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16468) Don't create fetch for _identifierMapper anymore

by Christian Beikov (JIRA)

2 years, 12 months

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