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)