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

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