[jira] [Created] (CALCITE-6924) FilterIntoJoinRule make JdbcJoin contains expressions that it does not support

["xiong duan (Jira)" <ji...@apache.org>]

xiong duan created CALCITE-6924:
-----------------------------------

             Summary: FilterIntoJoinRule make JdbcJoin contains expressions that it does not support
                 Key: CALCITE-6924
                 URL: https://issues.apache.org/jira/browse/CALCITE-6924
             Project: Calcite
          Issue Type: Bug
            Reporter: xiong duan


The unit test in JdbcTest:
{code:java}
@Test void testJdbcJoin() {
  CalciteAssert.that()
      .with(CalciteAssert.Config.JDBC_FOODMART)
      .query("select *\n"
          + "from \"foodmart\".\"store\" as p1\n"
          + "inner join \"foodmart\".\"store\" as p2 on true\n"
          + "where p1.\"store_id\" between 10 and 20 or p1.\"grocery_sqft\" = p2.\"grocery_sqft\"")
      .explainContains("PLAN=" +
          "JdbcToEnumerableConverter\n" +
          "  JdbcJoin(condition=[OR(SEARCH($0, Sarg[[10..20]]), =($16, $40))], joinType=[inner])\n" +
          "    JdbcTableScan(table=[[foodmart, store]])\n" +
          "    JdbcTableScan(table=[[foodmart, store]])\n\n");
}

@Test void testJdbcJoin2() {
  CalciteAssert.that()
      .with(CalciteAssert.Config.JDBC_FOODMART)
      .query("select *\n"
          + "from \"foodmart\".\"store\" as p1\n"
          + "inner join \"foodmart\".\"store\" as p2\n"
          + "on p1.\"store_id\" between 10 and 20 or p1.\"grocery_sqft\" = p2.\"grocery_sqft\"")
      .explainContains("PLAN=" +
          "EnumerableNestedLoopJoin(condition=[OR(SEARCH($0, Sarg[[10..20]]), =($16, $40))], joinType=[inner])\n" +
          "  JdbcToEnumerableConverter\n" +
          "    JdbcTableScan(table=[[foodmart, store]])\n" +
          "  JdbcToEnumerableConverter\n" +
          "    JdbcTableScan(table=[[foodmart, store]])\n\n");
} {code}
The testJdbcJoin test generate :
{code:java}
JdbcJoin(condition=[OR(SEARCH($0, Sarg[[10..20]]), =($16, $40))], joinType=[inner]){code}
But the JdbcJoinRule#canJoinOnCondition doesn't include the SEARCH operator, so the condition can't push down to JdbcJoin like testJdbcJoin2.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)