Ruben Q L created CALCITE-3783:

             Summary: Rule to remove Join on top of empty Values
                 Key: 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

Reply via email to