Haisheng Yuan created CALCITE-4010:
--------------------------------------

             Summary: Revise codegen for EnumerableMergeJoin to accept any sort 
order
                 Key: CALCITE-4010
                 URL: https://issues.apache.org/jira/browse/CALCITE-4010
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Haisheng Yuan


Given MergeJoin on foo.a=bar.a and foo.b=bar.b,
The codegen for EnumerableMergeJoin always sort tuples by (a,b), but after 
1.23.0 calcite can generate MergeJoin on collation of (b,a), or even (a,b,c), 
(b,a,c), with any asc/desc, null direction, which are all legit. So the codegen 
should sort tuples exactly according to the requirement of collation.

See 
https://github.com/apache/calcite/blob/master/linq4j/src/main/java/org/apache/calcite/linq4j/EnumerableDefaults.java#L1966
and
https://github.com/apache/calcite/pull/1833



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

Reply via email to