[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-7043) SQLServer2005Dialect should not use alias in the ORDER BY clause when paging
Steve Ebersole (JIRA)
noreply at atlassian.com
Thu Feb 9 00:11:10 EST 2012
[ https://hibernate.onjira.com/browse/HHH-7043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steve Ebersole updated HHH-7043:
--------------------------------
Pull Requests: https://github.com/hibernate/hibernate-orm/pull/272 (was: https://github.com/hibernate/hibernate-orm/pull/270)
> 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
>
> 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}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list