Jesus Camacho Rodriguez created CALCITE-2190:
------------------------------------------------
Summary: Extend SubstitutionVisitor.splitFilter to cover different
order of operands
Key: CALCITE-2190
URL: https://issues.apache.org/jira/browse/CALCITE-2190
Project: Calcite
Issue Type: Improvement
Components: core
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
{{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:
{code}
condition: x = 1 or y = 2
target: y = 2 or x = 1
-> residue: true
{code}
However, the following equivalent example fails:
{code}
condition: x = 1 or y = 2
target: y = 2 or 1 = x
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
