Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Considering this condition, (a or d) and (a or c) and a and b. This condition can be simplified to a and b, but now simplify can not do this.
This case is found out by materialized view test:
materialized view: select 'a',empid,deptno,salary as s from emps where (replace(name,'e','a') is not null or replace(name,'a','c') is not null) and (replace(name,'c','b') is not null or replace(name,'n','d') is not null) sql: select salary +1 as s,deptno from emps where replace(name,'c','b')is not null and replace(name,'a','c') is not null and salary>10 The sql will not be rewritten by materialized view because when splitFilter, $3 > 10 and REPLACE($2, 'a', 'c') is not null and REPLACE($2, 'c', 'b') is not null and (REPLACE($2, 'a', 'c') is not null or REPLACE($2, 'e', 'a') is not null) and (REPLACE($2, 'c', 'b') is not null or REPLACE($2, 'n', 'd') is not null) can not be simplified to $3 > 10 and REPLACE($2, 'a', 'c') is not null and REPLACE($2, 'c', 'b') is not null materialized view: select empid,deptno,salary as s from emps where (replace(name,'e','a') ='aaa' or replace(name,'a','c') ='aaa') and (replace(name,'c','b') ='aaa' or replace(name,'n','d') ='aaa') sql: select salary as s,deptno from emps where replace(name,'c','b') ='aaa' is not null and replace(name,'a','c') ='aaa' This case also can not be rewritten.
Attachments
Issue Links
- is related to
-
CALCITE-4988 ((A IS NOT NULL OR B) AND A IS NOT NULL) can't be simplify to (A IS NOT NULL) When A is deterministic
- Closed
- links to