[jira] [Commented] (CALCITE-2706) Do not make IN conversion
[ https://issues.apache.org/jira/browse/CALCITE-2706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16699036#comment-16699036 ] Mykola Zerniuk commented on CALCITE-2706: - Yes, sorry. Let's to continue discussion there. > Do not make IN conversion > - > > Key: CALCITE-2706 > URL: https://issues.apache.org/jira/browse/CALCITE-2706 > Project: Calcite > Issue Type: Bug >Reporter: Mykola Zerniuk >Assignee: Julian Hyde >Priority: Major > > We current have only two options with IN operator handling - replace it with > ORs or sub-queries depending on the inSubQueryThreshold. Add third option to > prevent any conversions and leave IN `as is`. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (CALCITE-2706) Do not make IN conversion
[ https://issues.apache.org/jira/browse/CALCITE-2706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mykola Zerniuk closed CALCITE-2706. --- Resolution: Duplicate > Do not make IN conversion > - > > Key: CALCITE-2706 > URL: https://issues.apache.org/jira/browse/CALCITE-2706 > Project: Calcite > Issue Type: Bug >Reporter: Mykola Zerniuk >Assignee: Julian Hyde >Priority: Major > > We current have only two options with IN operator handling - replace it with > ORs or sub-queries depending on the inSubQueryThreshold. Add third option to > prevent any conversions and leave IN `as is`. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (CALCITE-2722) SqlImplementor createLeftCall method throws StackOverflowError
Mykola Zerniuk created CALCITE-2722: --- Summary: 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 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)