I just want to let you know we are facing the exact same problem, when we execute a query with more than one group by field in projections list, the number of resulting rows is incorrect.
I will try the workaround proposed by Serge, but would be better to have a official solution for this issue.

Another solution is to use Hibernate Views, forcing the hibernate to count the row number using a subquery like: select count from (select ... )

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira