Hello, I’m writing a HQL query similar to this simple example: Select sum(l.orderedQuantity), p From OrderLine l Join l.product p Group By p I’m very interested in returning the whole Product entity p (not just a concrete set of columns). This HQL is transformed to this (simplified) SQL query: s…

Thanks for the reply. I will monitor it.

Because the HQL parser was rewritten in 6.0, this issue might be addressed in that version.

Wrong SQL generated for Oracle when using GROUP BY

vlad May 24, 2018, 3:13pm 2

The HHH-11513 was created for this issue.

1 Like

Topic		Replies	Views
Hibernate 6 / Wrong order by and group by generated with MappedSuperclass and Generics Hibernate ORM	16	1870	April 17, 2023
Criteria - Select vs Group By with case Hibernate ORM	4	913	August 2, 2023
Bug with grouping and HQL Hibernate ORM	7	904	April 9, 2018
GroupBy After Chained InnerJoins Produced invalid Postgres SQL after upgrading to Hibernate6 Hibernate ORM	1	59	July 29, 2024
Hibernate throws "Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause" - SQL Server Hibernate ORM	1	6076	November 23, 2018