cockroachdb / cockroachdb/cockroach

opt: propagate null-rejection cols through semi joins

Open
#100,564 0 comments 0 reactions 0 assignees View on GitHub
C-enhancement T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Currently, we do not consider pushing a null-rejecting filter through a semi-join in order to simplify an outer join below it, although we do consider null-rejecting using the filters of the semi-join itself. This leads to cases like in #100559, where an outer-join doesn't get simplified despite a null-rejecting filter because of a semi-join (#100559 also has an internal error for an unrelated reason). We should null-reject columns through semi-joins and maybe also anti-joins.

Jira issue: CRDB-26497

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.