• Drew Kimball's avatar
    opt: add rules to eliminate a do-nothing join under a Project · 6bf047df
    Drew Kimball authored
    Previously, the optimizer couldn't eliminate a join in the input of a
    Project when the removal would have no effect on the output of the
    Project operator.
    
    This patch adds rules to replace a join with one of its input relations
    when the following conditions are met:
    
    1. The Project doesn't use any columns from the discarded input.
    2. The Join doesn't eliminate or duplicate rows from the preserved input.
    
    Fixes #49149
    
    Release note (sql change): The optimizer can now remove an unnecessary
    join from the input of a Project operator.
    6bf047df
Name
Last commit
Last update
.github Loading commit data...
build Loading commit data...
c-deps Loading commit data...
cloud Loading commit data...
docs Loading commit data...
githooks Loading commit data...
licenses Loading commit data...
monitoring Loading commit data...
pkg Loading commit data...
scripts Loading commit data...
vendor @ 052117d3 Loading commit data...
.editorconfig Loading commit data...
.gitattributes Loading commit data...
.gitignore Loading commit data...
.gitmodules Loading commit data...
.node-version Loading commit data...
AUTHORS Loading commit data...
CONTRIBUTING.md Loading commit data...
Gopkg.lock Loading commit data...
Gopkg.toml Loading commit data...
LICENSE Loading commit data...
Makefile Loading commit data...
README.md Loading commit data...