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

[Hardy Ferentschik (JIRA)]

SQLServer2005Dialect changes the order of selected columns when using pagination
--------------------------------------------------------------------------------

                 Key: HHH-6849
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6849
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 4.0.0.CR6
            Reporter: Hardy Ferentschik
            Assignee: Hardy Ferentschik
             Fix For: 4.0.0.next


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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira