10:23 a.m.
SQLServer2008Dialect Bad Query
------------------------------
Key: HHH-6627
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6627
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.6.7, 3.6.6
Environment: JBoss 6.1.0 AS, SQL Server 2008
Reporter: Aleksandar Brankovic
Attachments: crit-prob.txt
Look at the file attached.
Focus is on the next line:
group by count(sale0_.id)
It results in next error:
Cannot use an aggregate or a subquery in an expression used for the group by list of a
GROUP BY clause.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:28 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-6627) SQLServer2008Dialect Bad Query
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6627?page=c...
]
Galen Dunkleberger updated HHH-6627:
------------------------------------
Attachment: SQLServer2005Dialect.patch
This seems to fix the group by aggregate issue for us.
SQLServer2008Dialect Bad Query
------------------------------
Key: HHH-6627
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6627
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.6.6, 3.6.7
Environment: JBoss 6.1.0 AS, SQL Server 2008
Reporter: Aleksandar Brankovic
Attachments: crit-prob.txt, SQLServer2005Dialect.patch
Look at the file attached.
Focus is on the next line:
group by count(sale0_.id)
It results in next error:
Cannot use an aggregate or a subquery in an expression used for the group by list of a
GROUP BY clause.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:13 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6627) SQLServer2008Dialect Bad Query
[
https://hibernate.onjira.com/browse/HHH-6627?page=com.atlassian.jira.plug...
]
Dzmitry Liushtyk commented on HHH-6627:
---------------------------------------
The same issue on 3.6.10 version. Proposed fix is not working with sql script contains
count in column name, for instance select distinct enCOUNTter.id from Encounter encounter.
It corrupts query. It's better to use regex instead of indexOf.
SQLServer2008Dialect Bad Query
------------------------------
Key: HHH-6627
URL: https://hibernate.onjira.com/browse/HHH-6627
Project: Hibernate ORM
Issue Type: Bug
Components: query-sql
Affects Versions: 3.6.6, 3.6.7
Environment: JBoss 6.1.0 AS, SQL Server 2008
Reporter: Aleksandar Brankovic
Attachments: crit-prob.txt, SQLServer2005Dialect.patch
Look at the file attached.
Focus is on the next line:
group by count(sale0_.id)
It results in next error:
Cannot use an aggregate or a subquery in an expression used for the group by list of a
GROUP BY clause.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:40 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6627) SQLServer2008Dialect Bad Query
[
https://hibernate.onjira.com/browse/HHH-6627?page=com.atlassian.jira.plug...
]
Dzmitry Liushtyk commented on HHH-6627:
---------------------------------------
protected static void replaceDistinctWithGroupBy(StringBuilder sql) {
int distinctIndex = sql.indexOf(DISTINCT);
int selectEndIndex = sql.indexOf(FROM);
if (distinctIndex > 0 && distinctIndex < selectEndIndex) {
boolean aggregateFunctionAvailable = false;
StringBuilder selectFieldsWithoutAlias = new
StringBuilder(getSelectFieldsWithoutAliases(sql));
for (String functionName : AGGREGATE_FUNCTION_NAMES)
{
Pattern p = Pattern.compile("\\s" + functionName + "\\s*\\(");
Matcher matcher = p.matcher(selectFieldsWithoutAlias);
if(matcher.find())
{
aggregateFunctionAvailable = true;
break;
}
}
if (!aggregateFunctionAvailable)
{
sql.delete(distinctIndex, distinctIndex + DISTINCT.length() + 1);
sql.append(" group by").append(getSelectFieldsWithoutAliases(sql));
}
}
}
SQLServer2008Dialect Bad Query
------------------------------
Key: HHH-6627
URL: https://hibernate.onjira.com/browse/HHH-6627
Project: Hibernate ORM
Issue Type: Bug
Components: query-sql
Affects Versions: 3.6.6, 3.6.7
Environment: JBoss 6.1.0 AS, SQL Server 2008
Reporter: Aleksandar Brankovic
Attachments: crit-prob.txt, SQLServer2005Dialect.patch
Look at the file attached.
Focus is on the next line:
group by count(sale0_.id)
It results in next error:
Cannot use an aggregate or a subquery in an expression used for the group by list of a
GROUP BY clause.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:42 a.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-6627) SQLServer2008Dialect Bad Query
[
https://hibernate.onjira.com/browse/HHH-6627?page=com.atlassian.jira.plug...
]
Dzmitry Liushtyk edited comment on HHH-6627 at 4/24/12 10:41 AM:
-----------------------------------------------------------------
//
was (Author: dzmitry):
protected static void replaceDistinctWithGroupBy(StringBuilder sql) {
int distinctIndex = sql.indexOf(DISTINCT);
int selectEndIndex = sql.indexOf(FROM);
if (distinctIndex > 0 && distinctIndex < selectEndIndex) {
boolean aggregateFunctionAvailable = false;
StringBuilder selectFieldsWithoutAlias = new
StringBuilder(getSelectFieldsWithoutAliases(sql));
for (String functionName : AGGREGATE_FUNCTION_NAMES)
{
Pattern p = Pattern.compile("\\s" + functionName + "\\s*\\(");
Matcher matcher = p.matcher(selectFieldsWithoutAlias);
if(matcher.find())
{
aggregateFunctionAvailable = true;
break;
}
}
if (!aggregateFunctionAvailable)
{
sql.delete(distinctIndex, distinctIndex + DISTINCT.length() + 1);
sql.append(" group by").append(getSelectFieldsWithoutAliases(sql));
}
}
}
SQLServer2008Dialect Bad Query
------------------------------
Key: HHH-6627
URL: https://hibernate.onjira.com/browse/HHH-6627
Project: Hibernate ORM
Issue Type: Bug
Components: query-sql
Affects Versions: 3.6.6, 3.6.7
Environment: JBoss 6.1.0 AS, SQL Server 2008
Reporter: Aleksandar Brankovic
Attachments: crit-prob.txt, SQLServer2005Dialect.patch
Look at the file attached.
Focus is on the next line:
group by count(sale0_.id)
It results in next error:
Cannot use an aggregate or a subquery in an expression used for the group by list of a
GROUP BY clause.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4343
days inactive
4819
days old
hibernate-issues@lists.jboss.org
7 comments
5 participants
participants (5)
-
Aleksandar Brankovic (JIRA) -
Anthony Ogier (JIRA)
-
Brett Meyer (JIRA)
-
Dzmitry Liushtyk (JIRA)
-
Galen Dunkleberger (JIRA)