Bug report: "Group by" failed with paging (Seam 2.1.0GA)

[kenneth.zhangsunny77.hotmail.com]

GroupBy is a new function at seam 2.1.0GA's Query module, but it cannot work with paging.

This is the test code:

@Name("bookStat")
public class BookStat extends EntityQuery<Book> {
        private static final String EJBQL = "select name, count(*) from Book book";
        (snip)
        public BookStat() {
               setEjbql(EJBQL);
               setRestrictionExpressionStrings(Arrays.asList(RESTRICTIONS));
               setMaxResults(3);
               setGroupBy("name");
         }
        (snip)
}

There is the error log:

13:05:09,578 INFO  [STDOUT] Hibernate:
    select
        count(*) as col_0_0_
    from
        test_seam.dbo.BOOK book0_
    group by
        book0_.name

Caused by: javax.persistence.NonUniqueResultException: result returns 21 elements
     at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:85)
     at org.jboss.seam.framework.EntityQuery.initResultCount(EntityQuery.java:129)
     at org.jboss.seam.framework.EntityQuery.getResultCount(EntityQuery.java:120)
     at org.jboss.seam.framework.Query.getPageCount(Query.java:202)
     at org.jboss.seam.framework.Query.getLastFirstResult(Query.java:163)

I have reported this issue. Please resolve it asap, thanks.

https://jira.jboss.org/jira/browse/JBSEAM-3643