[teiid-issues] [JBoss JIRA] (TEIID-4865) DISTINCT not pushed down to multisource sources

DISTINCT not pushed down to multisource sources ----------------------------------------------- Key: TEIID-4865 URL: https://issues.jboss.org/browse/TEIID-4865 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 9.2.2 Reporter: Harold Campbell Assignee: Steven Hawkins Fix For: 9.3 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 is an enhancement request to support partial distinct pushdown in the multi-source case.