Sven Reinhardt updated an issue

Hibernate ORM / HHH-13434 order by attribute of joined entity with distinct: Order by expression must be in the result list JdbcSQLSyntaxErrorException SQLGrammarException Change By: Sven Reinhardt If an entity is requested by a distinct query and the result should be ordered by an attribute of a joined entity e.g. of an OneToMany relation the query created by hibernate does not contain the order attribute in the result list. Databases like postgres and h2 reject to can not process this query , The reason why is decribed in many places . This functinality is essential for many cases where data is filtered and ordered in paged tables with complex queries. Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100104-sha1:e744018)