Skip to content

Support prefix/suffix/substring function pushdown to DuckDB. Fix contains() performance. #7734

@myrrc

Description

@myrrc

We support function pushdown from #7727.
In our benchmarks, we also have prefix/starts_with and suffix/ends_with.
We should push down these functions as well. For that we need to implement Vortex's prefix/suffix/substring expressions.

Our contains() function is pushed down as %pattern% (LIKE) which has bad performance. We should have a separate expression for that as well.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions