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

[Piotr Findeisen (JIRA)]

    [ https://hibernate.onjira.com/browse/HHH-6849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=46644#comment-46644 ] 

Piotr Findeisen commented on HHH-6849:
--------------------------------------

Oh, i see -- my case may be fixed by HHH-6950 (not yet released :( )

> 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.

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