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

[Galen Dunkleberger (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6627?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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