[
https://issues.jboss.org/browse/TEIID-1993?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1993.
-----------------------------------
Resolution: Done
Also added handling to ensure dup remove / distinct is treated similar to group by.
RuleMergeVirtual will now split dup removal over a partition and RuleAssignOutputElements
(just as in the unnecessary group by case) will attempt to add a LIMIT 1 when the
duplicate removal is just over constants.
Pushdown GROUP BY/DISTINCT over unions in more situations
---------------------------------------------------------
Key: TEIID-1993
URL:
https://issues.jboss.org/browse/TEIID-1993
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.7
Reporter: Mark Addleman
Assignee: Steven Hawkins
Fix For: 8.1
Attachments: pushdown-example.txt
The datasource does not support inline views but does support distinct.
See attached plan and
https://community.jboss.org/message/728556
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira