Skip to content

InList support for pre-image udf #20050

@sdf-jkl

Description

@sdf-jkl

Is your feature request related to a problem or challenge?

With #18320 closed we now support evaluating pre-image for binary comparison operators: (=, !=, >, >=, <. <=, is distinct from, is not distinct from)

It would be great to extend preimage to support InList expressions, like:
where date_part(col, 'YEAR') IN (2024, 2025)

part of #19946

Describe the solution you'd like

Add Inlist expression support to expr_simplifier.rs, similar to unwrap_cast

// For case:
// try_cast/cast(expr as left_type) in (expr1,expr2,expr3)
Expr::InList(InList {

Describe alternatives you've considered

No response

Additional context

No response

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions