[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17223851#comment-17223851 ]
Julian Hyde commented on CALCITE-4364: -------------------------------------- Thanks for checking. If you start work on a fix, be sure to build on top of the fix for CALCITE-4352. It should be merged in a few days. > "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 > Priority: Major > Fix For: 1.27.0 > > > Check this test in {{RexProgramTest}}: > {code: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)"); > } > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)