You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Regression in 43.0.0: coalesce no longer works between Utf8 and Utf8View columns #13568
thread 'main' panicked at src/main.rs:25:10:
called `Result::unwrap()` on an `Err` value: Plan("Execution error: User-defined coercion failed with Execution(\"Fail to find the coerced type, errors: Some(Execution(\\\"Expect to get struct but got Utf8\\\"))\") No function matches the given name and argument types 'coalesce(Utf8, Utf8View)'. You might need to add explicit type casts.\n\tCandidate functions:\n\tcoalesce(UserDefined)")
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
It seems the issue is fixed already, I couldn't reproduce the error on the latest commit
Including your test and this
statement count 0
create table t(a varchar, b varchar) as values ('a', 'b'), ('c', 'd');
statement ok
create table t2 as
select
a as c1,
arrow_cast(b, 'Utf8View') as c2
from t;
query T
select coalesce(c2, c1) from t2;
----
b
d
Activity
alamb commentedon Nov 27, 2024
I vaguely remember that @jayzhan211 worked on coalesece recently, maybe that was releated
jayzhan211 commentedon Nov 27, 2024
It seems the issue is fixed already, I couldn't reproduce the error on the latest commit
Including your test and this
alamb commentedon Dec 22, 2024
I verified that the reproducer query now runs without error on main (will be release in DataFusion 44).
Thank you again for the report @ttencate