8000 Filter Combiner Clean-up: move filter pushdown to separate functions, remove old commented out code by Mytherin · Pull Request #16443 · duckdb/duckdb · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Filter Combiner Clean-up: move filter pushdown to separate functions, remove old commented out code #16443

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

Merged
merged 5 commits into from
Feb 27, 2025

Conversation

Mytherin
Copy link
Collaborator

This PR cleans up the FilterCombiner:

  • The GenerateTableScanFilters had been growing, this PR splits the various pieces into separate functions which makes the function much more readable
  • At some point (years ago) we commented out a bunch of code here - that is unlikely to ever come back, so just remove it

This shouldn't change functionality with one minor exception: when pushing down a prefix(col, 'literal') filter, we now remove the original prefix filter (since the filter we are pushing down exactly computes the prefix).

@Mytherin
Copy link
Collaborator Author

The regression failure is caused by the IMDB queries in question choosing a different join order because we are no longer duplicating the prefix condition (LIKE 'Z%' gets translated by the optimizer into prefix(...))

@Mytherin Mytherin merged commit df24978 into duckdb:main Feb 27, 2025
47 of 49 checks passed
@Mytherin Mytherin deleted the filtercombinercleanup branch April 2, 2025 09:24
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 15, 2025
Filter Combiner Clean-up: move filter pushdown to separate functions, remove old commented out code (duckdb/duckdb#16443)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 15, 2025
Filter Combiner Clean-up: move filter pushdown to separate functions, remove old commented out code (duckdb/duckdb#16443)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 16, 2025
Filter Combiner Clean-up: move filter pushdown to separate functions, remove old commented out code (duckdb/duckdb#16443)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 17, 2025
Filter Combiner Clean-up: move filter pushdown to separate functions, remove old commented out code (duckdb/duckdb#16443)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 18, 2025
Filter Combiner Clean-up: move filter pushdown to separate functions, remove old commented out code (duckdb/duckdb#16443)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 18, 2025
Filter Combiner Clean-up: move filter pushdown to separate functions, remove old commented
608B
 out code (duckdb/duckdb#16443)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

1 participant
0