[teiid-issues] [JBoss JIRA] (TEIID-4865) DISTINCT not pushed down to multisource sources
[
https://issues.jboss.org/browse/TEIID-4865?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4865:
---------------------------------------
Or are you requesting an enhancement for this case handling similar to the aggregate
decomposition, such that the distinct is both pushed and processed again in the engine?
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)