You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Commit c76ed53
Browse filesBrowse the repository at this point in the historyBrowse files
fix: Correct ANY/ALL results for unaliased subqueries on the same table (apache#25273)
## Which issue does this PR close?
- Closesapache#25258.
## Rationale for this change
During the various decorrelation passes, stripping outer references too
early makes the outer and inner columns indistinguishable. Both operands
are then rewritten to reference the subquery, turning the join predicate
into a comparison of an inner column with itself (something like col1 >
col1).
## What changes are included in this PR?
Its mostly a minor change in where we strip the outer column reference
from the join filter in the optimizer.
## What is the testing strategy for this PR?
New SLT tests provided in the initial issue, asserting both results and
logical plan shape.
## Are there any user-facing changes?
Depreciating the `find_join_exprs` which isn't called internally
anymore, replacing it with a helper function in `decorrelate.rs`.
---------
Signed-off-by: Adam Gutglick <[email protected]>
0 commit comments