[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6627) SQLServer2008Dialect Bad Query

[Dzmitry Liushtyk (JIRA)]

    [ https://hibernate.onjira.com/browse/HHH-6627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=46395#comment-46395 ] 

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