[CALCITE-2722] SqlImplementor createLeftCall method throws StackOverflowError - ASF JIRA

Voters

Watch issue

Watchers

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 1.19.0
Component/s: core
Labels:
- pull-request-available

Description

SqlImplementor createLeftCall method is implemented using recursion. In this case if sql has a lot of AND or OR operators it throws StackOverflowError.

Caused by: java.lang.StackOverflowError
at org.apache.calcite.util.Util.skipLast(Util.java:1940)
at org.apache.calcite.util.Util.skipLast(Util.java:1935)
at org.apache.calcite.rel.rel2sql.SqlImplementor$Context.createLeftCall(SqlImplementor.java:763)
at org.apache.calcite.rel.rel2sql.SqlImplementor$Context.createLeftCall(SqlImplementor.java:765)
at org.apache.calcite.rel.rel2sql.SqlImplementor$Context.createLeftCall(SqlImplementor.java:765)

Since calcite converts IN list to OR this bug is also reproduces on huge IN list.