[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-7041) SQLServer2005Dialect handles DISTINCT clauses incorrectly

[ https://hibernate.onjira.com/browse/HHH-7041?page=com.atlassian.jira.plug... ] George Gastaldi edited comment on HHH-7041 at 2/8/12 10:21 PM: --------------------------------------------------------------- The Order by clause inside the OVER() statement is wrong also, as http://msdn.microsoft.com/en-us/library/ms189461.aspx states that {quote} When used in the context of a ranking window function, <ORDER BY Clause> can only refer to columns made available by the FROM clause. An integer cannot be specified to represent the position of the name or alias of a column in the select list. <ORDER BY Clause> cannot be used with aggregate window functions. {quote} This fix is NOT on the previous pull request was (Author: gastaldi): The Order by clause inside the OVER() statement is wrong also, as http://msdn.microsoft.com/en-us/library/ms189461.aspx states that {quote} When used in the context of a ranking window function, <ORDER BY Clause> can only refer to columns made available by the FROM clause. An integer cannot be specified to represent the position of the name or alias of a column in the select list. <ORDER BY Clause> cannot be used with aggregate window functions. {quote} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira