[jira] [Created] (IGNITE-14810) Calcite. SimpleJOIN with f1=f2 cannot be planned with CNLJ.

[Stanilovsky Evgeny (Jira)]

Stanilovsky Evgeny created IGNITE-14810:
-------------------------------------------

             Summary: Calcite. SimpleJOIN with f1=f2 cannot be planned with 
CNLJ.
                 Key: IGNITE-14810
                 URL: https://issues.apache.org/jira/browse/IGNITE-14810
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Stanilovsky Evgeny


For now simple JOIN requests like:

{noformat}
SELECT * FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k 
ORDER BY i
{noformat}

can be planned only through MergeJoin or NestedLoopJoin it would be useful to 
extend it with CNLJ too. Starting point : 
FilterSpoolMergeToSortedIndexSpoolRule#onMatch




--
This message was sent by Atlassian Jira
(v8.3.4#803005)