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

Generate vectorized selection filters for IN. #1340

Open
@lmwnshn

Description

@lmwnshn

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    beginnerGood for newcomers. Mark issues with this.performancePerformance related issues or changes.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions