]
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
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.