[CALCITE-2190] Extend SubstitutionVisitor.splitFilter to cover different order of operands

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Component/s: core
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 23/Feb/18 01:01
• Updated: 27/Feb/24 22:24
• Resolved: 23/Feb/18 23:32

Description

SubstitutionVisitor.splitFilter does structural comparison to identify relevant predicates. The method could sort the operands for some expressions in a deterministic way to maximize possible matches.

For instance, currently this example yields correct results:

condition: x = 1 or y = 2
target:    y = 2 or x = 1
-> residue:   true

However, the following equivalent example fails:

condition: x = 1 or y = 2
target:    y = 2 or 1 = x