[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6310) SQLServer2005Dialect produced select statement with a distinct keyword within an aggregate function does not work

[Yoryos Valotassios (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=42652#action_42652 ] 

Yoryos Valotassios commented on HHH-6310:
-----------------------------------------

https://github.com/hibernate/hibernate-core/pull/113

Can someone provide me with a good case where an aggregate function with a distinct keyword in it can be used with pagination? That would be a good functional test for this issue but can't think of something. You can force hibernate to try to paginate data by explicit calling setMaxResults but this is not real case scenario

> SQLServer2005Dialect produced select statement with a distinct keyword within an aggregate function does not work
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: HHH-6310
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6310
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core, query-sql
>    Affects Versions: 3.6.5
>            Reporter: Yoryos Valotassios
>            Assignee: Strong Liu
>
> As discussed on HHH-5715, the SQLServer2005Dialect does not handle the right the distinct keyword when that is inside an aggregate function.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira