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

[George Gastaldi (JIRA)]

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


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__ < ?


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