[CALCITE-2842] Computing RexCall digest containing IN expressions leads to Exceptions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.19.0
• Labels: pull-request-available
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 12/Feb/19 13:23
• Updated: 27/Feb/24 22:24
• Resolved: 21/Feb/19 05:25

Description

Testcase:

 /*  RexProgramTest */
  @Test public void testInDigest() {
    RexNode e = in(vInt(), literal(1), literal(2));
    assertThat(e.toString(), is("IN(?0.int0, 1, 2)"));
  }
 /*  RexProgramBuilder */
  protected RexNode in(Iterable<? extends RexNode> nodes) {
    return rexBuilder.makeCall(SqlStdOperatorTable.IN,
        ImmutableList.copyOf(nodes));
  }

The exception is due to that it tries to look at the other operand https://github.com/apache/calcite/blob/883666929478aabe07ee5b9e572c43a6f1a703e2/core/src/main/java/org/apache/calcite/rex/RexCall.java#L115

SIMPLE_BINARY_OPS contains COMPARISION which also contains "IN"

this was introduced in CALCITE-2454 a few days ago; bug not released

Issue Links

• links to: GitHub Pull Request #1040