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

[Aleksandar Brankovic (JIRA)]

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