[teiid-issues] [JBoss JIRA] (TEIID-4865) DISTINCT not pushed down to multisource sources
Harold Campbell created TEIID-4865:
--------------------------------------
Summary: DISTINCT not pushed down to multisource sources
Key: TEIID-4865
URL: https://issues.jboss.org/browse/TEIID-4865
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 9.2.2
Reporter: Harold Campbell
Assignee: Steven Hawkins
Attachments: DEBUG_LOG
Simple DISTINCT queries do not push down DISTINCT to the underlying sources (SQL Server,
in this case) of a multisource schema. Instead, all values are selected, and the sorting
out is done in teiid.
{noformat}
select distinct bic_status
from account;
{noformat}
Debug plan attached.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)