This was fixed at some point within Hibernate as Spring Data never merged the proposed fix.
Since upgrading to Hibernate 6.5.3 this error has returned. This problem also occurs in 6.6.0 and 6.6.1.
Activity
Show:
Marco Belladelli September 27, 2024 at 6:51 AM
Hello @Ben Ganley, the issues that were addressed are continuously tested against the latest ORM versions to prevent regressions.
There might me more cases which we don't test, but we're going to need a reproducer test case which demonstrates the issue using Hibernate only (no spring) to troubleshoot the problem.
Previously an issue was raised in Spring Data JPA Order by expression missing in select list after update to Spring Boot 3.0.1 with DISTINCT queries · Issue #2756 · spring-projects/spring-data-jpa (github.com) in which a “SELECT DISTINCT … ORDER BY” query would fail due to queries joining the same table multiple times and using different table references in the select and order by.
This was fixed at some point within Hibernate as Spring Data never merged the proposed fix.
Since upgrading to Hibernate 6.5.3 this error has returned. This problem also occurs in 6.6.0 and 6.6.1.