Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

Semijoin removal (redundant join elim) fails if expressions are simplified #28403

Open
frankmcsherry opened this issue Jul 22, 2024 · 0 comments
Labels
C-bug Category: something is broken

Comments

@frankmcsherry
Copy link
Contributor

What version of Materialize are you using?

main

What is the issue?

Transforms that simplify expressions, e.g. replacing #1 with #0 when they are known to be equal, breaks the RedundantJoin transform, whose provenance detection is not robust to these sorts of transformations (it largely ignores the filters and equivalences in Filter and Join, although it does clone the provenance for columns introduced in Project).

@frankmcsherry frankmcsherry added the C-bug Category: something is broken label Jul 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Category: something is broken
Projects
None yet
Development

No branches or pull requests

1 participant