[teiid-issues] [JBoss JIRA] (TEIID-2363) proactive buffering not occurring for the inner side of an outer join on "MERGE JOIN (SORT/ALREADY_SORTED)"

[Johnathon Lee (JIRA)]

Johnathon Lee created TEIID-2363:
------------------------------------

             Summary: proactive buffering not occurring for the inner side of an outer join on "MERGE JOIN (SORT/ALREADY_SORTED)"
                 Key: TEIID-2363
                 URL: https://issues.jboss.org/browse/TEIID-2363
             Project: Teiid
          Issue Type: Feature Request
          Components: Query Engine
    Affects Versions: 7.7.2
            Reporter: Johnathon Lee
            Assignee: Steven Hawkins


The issue here is this is an outer join and the inner side (the already sorted side) will be buffered regardless.  Current logic does not catch blocked exceptions from one side and pro-actively buffer the other - rather we are serially performing the sort and then continue with the loading of the inner side

There is a clear trade-off between execution speed and buffering so this behavior may have to be hint or config driven.

--
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