This problem only occurs in large IN-lists, because small IN-lists - those smaller than SqlToRelConverter.Config.InSubQueryThreshold - are always converted to OR, and converting to OR always gives correct results. For correct results, IN-lists that reference column values must be converted to OR, no matter how large they are.
The ISSUE ADDRESS: https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-4844?filter=updatedrecently The PR ADDRESS: https://github.com/apache/calcite/pull/2594
