[JBoss JIRA] (JBSEAM-4854) countQuery not correcly generated when group by is used
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2008 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2007 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2006 -----
- December
- November
- October
[
https://issues.jboss.org/browse/JBSEAM-4854?page=com.atlassian.jira.plugi...
]
Tiago Peruzzo commented on JBSEAM-4854:
---------------------------------------
[~manaRH] I'm upgrading multiple projects (more than 40 projects in all) using the
seam 2.2 to 2.3, have many classes with group by using EntityQuery that worked in version
2.2.
It would be too costly and risky to find all places where I have a sql with group by and
change to set useWildcardAsCountQuerySubject to false.
Another issue is that the sql referenced in the bug is not wrong. The method makes the
count properly, what do happens is that some providers do not support multiple distincts
in the count or have a different semantics.
Mysql:
select count(distinct year(e.receivedDate), quarter(e.receivedDate)) from Entity e;
Oracle:
select count (distinct trunc(e.receivedDate, 'year') || trunc(e.receivedDate,
'Q')) from Entity e;
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)
3140
days inactive
3140
days old
0 comments
1 participants
tags (0)
participants (1)
-
Tiago Peruzzo (JIRA)