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 of an e.g. OneToMany Relation relation the query created by hibernate does not conttain contain the order attribute in the resultset result list . Databases like postgres and h2 reject to Process process this query. This functinality is essential for us in 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)