[teiid-issues] [JBoss JIRA] (TEIID-1993) Pushdown GROUP BY/DISTINCT over unions in more situations
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Thu Apr 26 16:02:17 EDT 2012
[ https://issues.jboss.org/browse/TEIID-1993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
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
More information about the teiid-issues
mailing list