[teiid-issues] [JBoss JIRA] (TEIID-2747) Wrong results with merge join SORT_DISTINCT with a full sort that is distinct beyond the join columns

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12928619#comment-12928619 ] 

RH Bugzilla Integration commented on TEIID-2747:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1033056|https://bugzilla.redhat.com/show_bug.cgi?id=1033056] from MODIFIED to ON_QA
                
> 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