[teiid-issues] [JBoss JIRA] (TEIID-2747) Wrong results with merge join SORT_DISTINCT with a full sort that is distinct beyond the join columns
Steven Hawkins (JIRA)
issues at jboss.org
Mon Apr 21 07:26:35 EDT 2014
[ https://issues.jboss.org/browse/TEIID-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-2747.
---------------------------------
> Wrong results with merge join SORT_DISTINCT with a full sort that is distinct beyond the join columns
> -----------------------------------------------------------------------------------------------------
>
> Key: TEIID-2747
> URL: https://issues.jboss.org/browse/TEIID-2747
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 8.4.1, 8.6
>
>
> To speed up processing of a sort merge join we attempt to eliminate extra comparisons by detecting if the equi-join column values are distinct. In plans where the sorted values are distinct beyond the equi-join values such that the equi-join column values are non-distinct, then incorrect results can be returned.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list