Skip to content
This repository has been archived by the owner on Feb 20, 2023. It is now read-only.

Generate vectorized selection filters for IN. #1340

Open
lmwnshn opened this issue Nov 18, 2020 · 0 comments
Open

Generate vectorized selection filters for IN. #1340

lmwnshn opened this issue Nov 18, 2020 · 0 comments
Labels
beginner Good for newcomers. Mark issues with this. performance Performance related issues or changes.

Comments

@lmwnshn
Copy link
Contributor

lmwnshn commented Nov 18, 2020

Feature Request

Summary

Right now, foo IN (1,2,3) is translated to foo = 1 OR foo = 2 OR foo = 3.

Per Prashanth's suggestion in #1326, we can go HAM with IN (I am suddenly fond of this phrasing) and translate IN to use vectorized selection builtins for each value in the IN list.

I think this would mainly involve a tweak to where filters are currently being generated in SeqScanTranslator::GenerateFilterClauseFunctions (and perhaps CTE scan, whenever that eventually merges). We already generate the vectorized select for the = case.

@lmwnshn lmwnshn added beginner Good for newcomers. Mark issues with this. performance Performance related issues or changes. labels Nov 18, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
beginner Good for newcomers. Mark issues with this. performance Performance related issues or changes.
Projects
None yet
Development

No branches or pull requests

1 participant