Skip to content

not support similar to expr run in physical expr? #12155

@zhuliquan

Description

@zhuliquan

Describe the bug

There is SimilarTo expr in logical expr

SimilarTo(Like),

However, there is not arm for SimilarTo expr in func create_physical_expr (in datafusion/physical-expr/src/planner.rs:L106)
If I write sql include SimilarTo expr will got a panic which throw from below code
other => {
not_impl_err!("Physical plan does not support logical expression {other:?}")
}

For example:

> select * from t1 where c1 similar to 'x*';
This feature is not implemented: Physical plan does not support logical expression SimilarTo(Like { negated: false, expr: Column(Column { relation: Some(Bare { table: "t1" }), name: "c1" }), pattern: Literal(Utf8("x*")), escape_char: None, case_insensitive: false })

To Reproduce

No response

Expected behavior

No response

Additional context

Whether to consider removing the SimilarTo expression from the logical expression or add arm for it to convert to a special physical expression in func create_physical_expr

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions