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 <[email protected]> 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
