[jbossseam-issues] [JBoss JIRA] Created: (JBSEAM-3643) "Group by" paging failed

[Kenneth Zhang (JIRA)]

"Group by" paging failed
------------------------

                 Key: JBSEAM-3643
                 URL: https://jira.jboss.org/jira/browse/JBSEAM-3643
             Project: Seam
          Issue Type: Bug
          Components: Framework
    Affects Versions: 2.1.0.GA
         Environment: JBoss 4.2.3GA, Seam 2.1.0GA,JDK 1.5.0_16
            Reporter: Kenneth Zhang


GroupBy is a new function at seam 2.1.0GA, 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)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira