[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2655) SQLServer2005Dialect (ROW_NUMBER for Paging)

[Yoryos Valotassios (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39011#action_39011 ] 

Yoryos Valotassios commented on HHH-2655:
-----------------------------------------

Both fixes introduces another bug. When someone tries to select with the distinct keyword will can get back dublicated entities. I'll have a test case by night! A solution is to rewrite the sql with a groub by clause that will have the same effect with the distinct.

> SQLServer2005Dialect (ROW_NUMBER for Paging)
> --------------------------------------------
>
>                 Key: HHH-2655
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2655
>             Project: Hibernate Core
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: 3.2.2, 3.2.3, 3.2.4, 3.5.3
>         Environment: SQLServer 2005, Hibernate 3.2.2+
>            Reporter: Wells Tiedeman
>            Assignee: Strong Liu
>             Fix For: 3.6.1, 4.0.0.Alpha1
>
>         Attachments: BindingSqlServerDialect.java, SQLServer2005Dialect.java, SQLServer2005Dialect.java, SQLServer2005Dialect.java, SQLServer2005Dialect.java, SqlServer2008Dialect.java, SqlServer2008Dialect.java, SqlServer2008Dialect.java
>
>   Original Estimate: 1m
>  Remaining Estimate: 1m
>
> Add a SQLServer2005Dialect class to the product that leverages the new ROW_NUMBER capabilities within SQLServer2005 to do paged result sets more efficiently.  See attached source...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira