You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2020/10/29 09:58:00 UTC
[jira] [Created] (CALCITE-4364) "a in (1, 2) and a = 1" should be
simplified to "a=1"
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)