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

[raymond tsui (Jira)]

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)