Skip to content

Decorrelated predicate subqueries with disjuncition has duplicated rows #13135

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom
Closed
eejbyfeldt opened this issue Oct 27, 2024 · 0 comments · Fixed by #13134
Closed

Decorrelated predicate subqueries with disjuncition has duplicated rows #13135

eejbyfeldt opened this issue Oct 27, 2024 · 0 comments · Fixed by #13134
Labels
bug Something isn't working

Comments

@eejbyfeldt
Copy link
Contributor

Describe the bug

In #12945 the emulation of an mark join has a bug when there is duplicate values in the subquery. This would be fixable by adding a distinct before the join. This can also be resolved by using a LeftMark join.

To Reproduce

No response

Expected behavior

No response

Additional context

No response
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat: Implement LeftMark join to fix subquery correctness issue eejbyfeldt/datafusion
1 participant
@eejbyfeldt