[ 
https://issues.apache.org/jira/browse/CALCITE-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16769992#comment-16769992
 ] 

Haisheng Yuan commented on CALCITE-2722:
----------------------------------------

I opened a PR to rewrite the function in iterative way:

[https://github.com/apache/calcite/pull/1048]

Can someone take a look?

> SqlImplementor createLeftCall method throws StackOverflowError
> --------------------------------------------------------------
>
>                 Key: CALCITE-2722
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2722
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Mykola Zerniuk
>            Assignee: Julian Hyde
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> SqlImplementor _createLeftCall_ method is implemented using recursion. In 
> this case if sql has a lot of AND or OR operators it throws 
> StackOverflowError.
> {code:java}
> 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){code}
> Since calcite converts IN list to OR this bug is also reproduces on huge IN 
> list.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to