[seam-issues] [JBoss JIRA] (JBSEAM-4854) countQuery not correcly generated when group by is used
Tiago Peruzzo (JIRA)
issues at jboss.org
Mon Sep 28 14:22:00 EDT 2015
[ https://issues.jboss.org/browse/JBSEAM-4854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13112983#comment-13112983 ]
Tiago Peruzzo commented on JBSEAM-4854:
---------------------------------------
[~mnovotny] this change has affected my queries that have group by. Now the count returns without the distinct and appears a number of different records than return the select with group by.
Sample:
select min (e.birthYear), count (*) from Person p group by p.birthYear
The correct count should be:
select count (distinct p.birthYear) from Person p
https://github.com/seam2/jboss-seam/commit/a73ff489e9f62fcacf6c9593889018599ebd925b
> 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: Sergio Angelo
> 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 was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the seam-issues
mailing list