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
between with NULL literals does not work: can't be evaluated because there isn't a common type to coerce the types to #1193
>select5 between nulland10as foo from foo;
Plan("'Int64 >= Utf8' can't be evaluated because there isn't a common type to coerce the types to")
>select5 between 5andnullas foo from foo;
Plan("'Int64 <= Utf8' can't be evaluated because there isn't a common type to coerce the types to")
>selectnull between 5andnullas foo;
Plan("'Utf8 >= Int64' can't be evaluated because there isn't a common type to coerce the types to")
The correct output is null
I think the solution will likely be to teach Expr::Between about type coercion (as is done in BinaryExpr and function calls) once coercion knows about the null type (and that it can be cast to any other type). See #1184 for more details
changed the title [-]`between` with NULL literals does not work[/-][+]`between` with NULL literals does not work: can't be evaluated because there isn't a common type to coerce the types to[/+]on Oct 28, 2021
Activity
[-]`between` with NULL literals does not work[/-][+]`between` with NULL literals does not work: can't be evaluated because there isn't a common type to coerce the types to[/+]Jefffrey commentedon Nov 14, 2022
Seems to be resolved as of master 96512ac
Running on datafusion-cli:
Edit: probably fixed by #3407?
minor: move shuffle classes from common to spark (apache#1193)
feat: add support for array_contains expression (apache#1163)