February 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HBX-2484) Update hibernate tools dependency of org.jboss.tools.hibernate.runtime.v_5_6 to version 5.6.15.Final

by Koen Aers (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HBX-2481) Update version identifier to 5.6.15.Final

by Koen Aers (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HBX-2483) Update Hibernate ORM Dependency to Version 5.6.16.Final

by Koen Aers (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16165) Incorrect SQL generated when using SELECT DISTINCT and @OrderBy

by Andrea Boriero (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HBX-2439) Implement and use the generic adapter for ICriteria in the experimental Hibernate runtime

by Koen Aers (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16107) Circular entities throwing UnknownTableReferenceException in 6.x

by Christian Beikov (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15870) allow SchemaMigrator to update column types

by Christian Beikov (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16165) Incorrect SQL generated when using SELECT DISTINCT and @OrderBy

by Georgios Andrianakis (JIRA)

Georgios Andrianakis ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWZiYjA3ZjFk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16165?atlOrigin=eyJpIjoiMWZiYj... ) HHH-16165 ( https://hibernate.atlassian.net/browse/HHH-16165?atlOrigin=eyJpIjoiMWZiYj... ) Incorrect SQL generated when using SELECT DISTINCT and @OrderBy ( https://hibernate.atlassian.net/browse/HHH-16165?atlOrigin=eyJpIjoiMWZiYj... ) Change By: Georgios Andrianakis ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) When running Hibernate Reactive’s [ManyToManyTest|https://github.com/hibernate/hibernate-reactive/blob/wip/O...] , the test fails with: {noformat}java.util.concurrent.CompletionException: org.hibernate.HibernateException: java.util.concurrent.CompletionException: io.vertx.pgclient.PgException: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list (42P10){noformat} The problematic part is [this|https://github.com/hibernate/hibernate-reactive/blob/wip/ORM-6/hiber...] which leads to the following generated SQL: {code:sql} select distinct a1_0.id, b1_0.Author_id, b1_1.id, b1_1.title, a1_0.name from MTMAuthor a1_0 left join (MTMAuthor_MTMBook b1_0 join MTMBook b1_1 on b1_1.id = b1_0.books_id) on a1_0.id = b1_0.Author_id order by b1_0.books_id{code} The test worked just fine in Hibernate Reactive’s main branch (using ORM 5.5) A discussion of the issue can also be found [here|https://hibernate.zulipchat.com/#narrow/stream/205413-hibernate-reac...]. ( https://hibernate.atlassian.net/browse/HHH-16165#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16165#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#100215- sha1:a0f3b6a )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16165) Incorrect SQL generated when using SELECT DISTINCT and @OrderBy

by Georgios Andrianakis (JIRA)

Georgios Andrianakis ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNWE0Yzk4NTk0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16165?atlOrigin=eyJpIjoiNWE0Yz... ) HHH-16165 ( https://hibernate.atlassian.net/browse/HHH-16165?atlOrigin=eyJpIjoiNWE0Yz... ) Incorrect SQL generated when using SELECT DISTINCT and @OrderBy ( https://hibernate.atlassian.net/browse/HHH-16165?atlOrigin=eyJpIjoiNWE0Yz... ) Issue Type: Bug Affects Versions: 6.2.0.CR2 Assignee: Unassigned Created: 09/Feb/2023 21:45 PM Priority: Major Reporter: Georgios Andrianakis ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) When running Hibernate Reactive’s ManyToManyTest ( https://github.com/hibernate/hibernate-reactive/blob/wip/ORM-6/hibernate-... ) , the test fails with: java.util.concurrent.CompletionException: org.hibernate.HibernateException: java.util.concurrent.CompletionException: io.vertx.pgclient.PgException: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list (42P10) The problematic part is this ( https://github.com/hibernate/hibernate-reactive/blob/wip/ORM-6/hibernate-... ) which leads to the following generated SQL: select distinct a1_0.id, b1_0.Author_id, b1_1.id, b1_1.title, a1_0. name from MTMAuthor a1_0 left join (MTMAuthor_MTMBook b1_0 join MTMBook b1_1 on b1_1.id = b1_0.books_id) on a1_0.id = b1_0.Author_id order by b1_0.books_id The test worked just fine in Hibernate Reactive’s main branch (using ORM 5.5) A discussion of the issue can also be found here ( https://hibernate.zulipchat.com/#narrow/stream/205413-hibernate-reactive-... ). ( https://hibernate.atlassian.net/browse/HHH-16165#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16165#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#100215- sha1:a0f3b6a )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16164) Can the multi-tenant field type not be string

by 孙斯龙 (JIRA)

孙斯龙 ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63e5b47... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjYxMTYyMDdj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16164?atlOrigin=eyJpIjoiZjYxMT... ) HHH-16164 ( https://hibernate.atlassian.net/browse/HHH-16164?atlOrigin=eyJpIjoiZjYxMT... ) Can the multi-tenant field type not be string ( https://hibernate.atlassian.net/browse/HHH-16164?atlOrigin=eyJpIjoiZjYxMT... ) Issue Type: Bug Affects Versions: 6.1.6 Assignee: Unassigned Attachments: WeChat397fb20987e518b1d44def2d29162ab0.png, WeChat8b3dd5472157746b472e8de524733745.png Components: hibernate-core Created: 09/Feb/2023 19:11 PM Environment: spring-data-jpa:3.0.2 Priority: Major Reporter: 孙斯龙 ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63e5b47... ) my tenantId wants be Integer or Long ( https://hibernate.atlassian.net/browse/HHH-16164#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16164#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#100215- sha1:a0f3b6a )

1 year, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues February 2023