You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "raymond tsui (Jira)" <ji...@apache.org> on 2022/10/29 18:43:00 UTC

[jira] [Created] (CALCITE-5350) SimplifyNot with a big overhead

raymond tsui created CALCITE-5350:
-------------------------------------

             Summary: SimplifyNot with a big overhead
                 Key: CALCITE-5350
                 URL: https://issues.apache.org/jira/browse/CALCITE-5350
             Project: Calcite
          Issue Type: Improvement
            Reporter: raymond tsui


i set the IN threshold to Integer.MAX_VALUE. Original Sql look like

 
{code:java}
select a,b from t1 where c=xxx and a in(...//500 element){code}
and then relNode look like

 

 
{code:java}
 {code}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)