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

"Group by" failed with paging ------------------------------ 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 Assignee: Dan Allen Fix For: 2.1.2.CR1 Attachments: Book-sample-2-log.txt, Book-sample-2.zip 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)