[jira] [Created] (CALCITE-3783) Rule to remove Join on top of empty Values

["Ruben Q L (Jira)" <ji...@apache.org>]

Ruben Q L created CALCITE-3783:
----------------------------------

             Summary: Rule to remove Join on top of empty Values
                 Key: CALCITE-3783
                 URL: https://issues.apache.org/jira/browse/CALCITE-3783
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Ruben Q L
            Assignee: Ruben Q L


There are some scenarios where a Join with a left/right child being an empty values can be removed:
- [ LEFT | INNER | SEMI | ANTI ]  JOIN(EmptyValues, X) => EmptyValues
- [ INNER | SEMI ]  JOIN(X, EmptyValues) => EmptyValues
- ANTI  (equi)JOIN(X, EmptyValues) => X

The goal is to create new rule(s) (inside a new class named e.g. JoinRemoveRule) to match and cover these scenarios.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)