[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-7043) SQLServer2005Dialect should not use alias in the ORDER BY clause when paging

SQLServer2005Dialect should not use alias in the ORDER BY clause when paging ---------------------------------------------------------------------------- Key: HHH-7043 URL: https://hibernate.onjira.com/browse/HHH-7043 Project: Hibernate ORM Issue Type: Bug Reporter: George Gastaldi Assignee: Steve Ebersole Fix For: 4.1.0 Using alias in the OVER() statement is wrong, 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}