[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6849) SQLServer2005Dialect changes the order of selected columns when using pagination

SQLServer2005Dialect changes the order of selected columns when using pagination -------------------------------------------------------------------------------- Key: HHH-6849 URL: https://hibernate.onjira.com/browse/HHH-6849 Project: Hibernate ORM Issue Type: Bug Components: core Affects Versions: 4.0.0.CR6 Reporter: Hardy Ferentschik Assignee: Hardy Ferentschik Labels: dialect, sqlserver Fix For: 4.0.0.CR7 The _SQLServer2005Dialect_ uses _ROW_NUMBER()_ to generate a limit string. However, it prepend the row number column instead of appending it (or not returning it at all). This let for example _PaginationTest#testLimitOffset_ fail. See also HHH-2655.