[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-7041) SQLServer2005Dialect handles DISTINCT clauses incorrectly
[
https://hibernate.onjira.com/browse/HHH-7041?page=com.atlassian.jira.plug...
]
Hardy Ferentschik updated HHH-7041:
-----------------------------------
Description:
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}
was:
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__ < ?
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__ < ?
{code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira