[CALCITE-3869] Stackoverflow with large OR statements

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.22.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Stephan Pirnbaum
• Created: 24/Mar/20 07:27
• Updated: 24/Mar/20 16:42

Description

As described in CALCITE-2792 large OR clauses lead to a StackOverflowError. While the ticket was closed with the remark "Resolved in release 1.22.0", the issue originally stated was not (completely) resolved. To reproduce this, I implemented following simple test case:

@Test
public void testLargeOr() {
  String orClause = IntStream.range(0, 1000).boxed()
                             .map(i -> "e.\"empid\"=" + i)
                             .collect(Collectors.joining(" OR "));
  final String sql = "SELECT * FROM \"hr\".\"emps\" e WHERE " + orClause;
  CalciteAssert.model(JdbcTest.HR_MODEL)
      .query(sql)
      .runs();
}

 

The stackoverflow can be seen in the attached log.

As also CALCITE-2696 and CALCITE-2630 are not fixed, this is a blocking issue in our current use case.