[
https://issues.jboss.org/browse/JBSEAM-4854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marek Novotny resolved JBSEAM-4854.
-----------------------------------
Resolution: Done
I have switched first condition for second to get correct count query
> 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
>
> Original Estimate: 4 hours
> Remaining Estimate: 4 hours
>
> 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
_______________________________________________
seam-issues mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/seam-issues