[seam-issues] [JBoss JIRA] (JBSEAM-4854) countQuery not correcly generated when group by is used

Marek Novotny (Updated) (JIRA) jira-events at lists.jboss.org
Mon Nov 7 09:18:45 EST 2011

     [ https://issues.jboss.org/browse/JBSEAM-4854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marek Novotny updated JBSEAM-4854:

      Fix Version/s: 2.3.0.BETA1
    Forum Reference: http://seamframework.org/Community/Seam222FinalSecurityRelease#comment173491  (was: http://seamframework.org/Community/Seam222FinalSecurityRelease#comment173491)

> countQuery not correcly generated when group by is used
> -------------------------------------------------------
>                 Key: JBSEAM-4854
>                 URL: https://issues.jboss.org/browse/JBSEAM-4854
>             Project: Seam 2
>          Issue Type: Bug
>          Components: Framework
>    Affects Versions: 2.3.0.ALPHA
>            Reporter: Serkan Eskici
>            Assignee: Marek Novotny
>             Fix For: 2.3.0.BETA1
> When an EntityQuery contains a group-by, then the select statement of the count-query is not correctly generated.
> Example query for reproducing the problem:
> select min(e.receivedDate), count(*) 
> from Entity e 
> where ... 
> groupby date_trunc('year', e.receivedDate), date_trunc('quarter', e.receivedDate)
> The count-query becomes as follows (which generates an exception when run):
> select distinct date_trunc('year', l.receivedDate), date_trunc('quarter', e.receivedDate)
> from etc.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


More information about the seam-issues mailing list