Skip to content

Commit 06c4d41

Browse files
mbutrovichneilconwaykumarUjjawal
authored
[branch-54] fix: handle IS TRUE correctly in EliminateOuterJoin (backport #22444) (#23580)
## Which issue does this PR close? - Backport of #22444 to `branch-54` (for 54.1.0, tracked in #22547). - Fixes wrong results #22441 (regression introduced in 54.0.0 by #21549). ## Rationale for this change `IS TRUE` in `EliminateOuterJoin` wrongly converts outer joins to inner joins, so 54.0.0 drops rows that 53.1.0 returned. Empirically verified: 53.1.0 returns correct rows, 54.0.0 does not. No API changes, correctness-only fix, so it fits the backport criteria. ## What changes are included in this PR? Clean cherry-pick of #22444. No adaptation required. ## Are these changes tested? Yes. Carries the original regression coverage (`eliminate_outer_join.slt`), all tests pass. ## Are there any user-facing changes? Affected outer-join queries now return the correct rows. No API changes. Co-authored-by: Neil Conway <[email protected]> Co-authored-by: Kumar Ujjawal <[email protected]>
1 parent 7fd1b0d commit 06c4d41

2 files changed

Lines changed: 359 additions & 102 deletions

File tree

0 commit comments

Comments
 (0)