You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@grails.apache.org by GitBox <gi...@apache.org> on 2026/10/22 21:12:21 UTC

[GH] (grails-core/fix/criteria-count-ignores-orders-8.0.x): Workflow run "CI" failed!

The GitHub Actions job "CI" on grails-core.git/fix/criteria-count-ignores-orders-8.0.x has failed.
Run started by GitHub user borinquenkid (triggered by borinquenkid).

Head commit for run:
ebc4b2a4e3bfbb4147513a627575fad7a1639a41 / Walter Duque de Estrada <wb...@mac.com>
fix(hibernate7): leave the criteria's orders out of a count query

A count has one row whatever the order, and an ORDER BY on a column that is
not aggregated fails on H2 and most other databases, so `count()` on a
DetachedCriteria or a criteria builder with an `order` threw a
SQLGrammarException ("Column ... must be in the GROUP BY list"). Only the
paged-list total escaped it, because it clears the orders first.

JpaCriteriaQueryCreator now skips the orders when every projection of the
query is a count, as `count()` and `countDistinct()` set it up. A query that
groups and counts keeps its orders.

Report URL: https://github.com/apache/grails-core/actions/runs/39815775339

With regards,
GitHub Actions via GitBox