[hibernate-issues] [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