Hi community, Currently, there is a minor inconsistent behavior in `RexBuilder#makeIn`. It does not take `RelDataTypeSystem.shouldConvertRaggedUnionTypesToVarying()` into consideration.
I guess it's reasonable if `shouldConvertRaggedUnionTypesToVarying` is true, we should use less restrictive type based on all ranges types instead of first range type. CALCITE-4888 aims to update the `makeIn` behavior. PR: https://github.com/apache/calcite/pull/2612 JIRA: https://issues.apache.org/jira/browse/CALCITE-4888 Best, Jing Zhang