[jira] [Created] (CALCITE-4364) "a in (1, 2) and a = 1" should be simplified to "a=1"

["Danny Chen (Jira)" <ji...@apache.org>]

Danny Chen created CALCITE-4364:
-----------------------------------

             Summary: "a in (1, 2) and a = 1" should be simplified to "a=1"
                 Key: CALCITE-4364
                 URL: https://issues.apache.org/jira/browse/CALCITE-4364
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.26.0
            Reporter: Danny Chen
             Fix For: 1.27.0


Check this test in {{RexProgramTest}}:

```java
@Test void testSimplifyInAnd() {
    // deptno in (20, 10) and deptno = 10
    //   ==>
    // deptno = 10
    final RexNode e =
        and(
            in(vInt(), literal(20), literal(10)),
            eq(vInt(), literal(10)));
    checkSimplify(e, "=(?0.int0, 10)");
  }
```



--
This message was sent by Atlassian Jira
(v8.3.4#803005)