[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-7041) SQLServer2005Dialect handles DISTINCT clauses incorrectly

[George Gastaldi (JIRA)]

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

George Gastaldi commented on HHH-7041:
--------------------------------------

There is another bug with this class. There is a scenario that it writes blank fields on the select. Also, the protected methods are static (!) 

> SQLServer2005Dialect handles DISTINCT clauses incorrectly 
> ----------------------------------------------------------
>
>                 Key: HHH-7041
>                 URL: https://hibernate.onjira.com/browse/HHH-7041
>             Project: Hibernate ORM
>          Issue Type: Bug
>            Reporter: George Gastaldi
>             Fix For: 4.1.0
>
>
> SQLServer2005Dialect messes with the SQL when 
> Eg: 
> {code:sql}
> select xxx from yyy where yyy.id not in (select distinct(aaa) from bbb)
> {code}
> becomes: 
> {code:sql}
> WITH query AS (select 
>     xxx  
>     from yyy    
>     where
>         yyy.id not in ( select aaa from bbb ) 
> ) SELECT
>     * 
> FROM
>     query 
> WHERE
>     __hibernate_row_nr__ >= ? 
>     AND __hibernate_row_nr__ < ?
> {code}

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