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

[Serkan Eskici (Created) (JIRA)]

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


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