[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6849) SQLServer2005Dialect changes the order of selected columns when using pagination
Strong Liu (JIRA)
noreply at atlassian.com
Fri Nov 25 10:34:19 EST 2011
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=44431#comment-44431 ]
Strong Liu commented on HHH-6849:
---------------------------------
Hardy,
do you have time to fix HHH-6310 as well?
> 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
> Labels: dialect, sqlserver
> 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
More information about the hibernate-issues
mailing list