[CALCITE-4155] Simplify IN expression of discrete values
See https://issues.apache.org/jira/browse/CALCITE-4155 After introducing the Sarg framework, we need to support it based on that.
@liyafan82 I will try to give a code review soon.
@amaliujia Thank you in advance!
I noticed that in the JIRA Julian mentioned he is working on https://github.com/julianhyde/calcite/tree/4159-simplify which might solve this case. It might be still good to postpone this PR a bit to what is the outcome from 4159-simplify.
I noticed that in the JIRA Julian mentioned he is working on https://github.com/julianhyde/calcite/tree/4159-simplify which might solve this case. It might be still good to postpone this PR a bit to what is the outcome from
4159-simplify.
@amaliujia Thanks for your investigation.
IMO, some of the ideas in https://github.com/julianhyde/calcite/tree/4159-simplify has already been implemented in https://github.com/apache/calcite/pull/2105, and merged into our code base. I am not sure if Julian is still working on it, so I opened this one.
Anyway, it sounds reasonable to postpone this and wait for some outcome from that PR.