[CALCITE-1116] Extend simplify for reducing expressions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Component/s: core
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 01/Mar/16 12:28
• Updated: 27/Feb/24 22:24
• Resolved: 17/Mar/16 22:22

Description

We would like to cover more cases in expression simplification, such as:

x>5 and x is not null => x>5
x>5 and x is null => not satisfiable
x>5 and x<=5 => not satisfiable

Issue Links

• is superceded by: CALCITE-1220 Further extend simplify for reducing expressions