davidhewitt opened a new issue, #17055: URL: https://github.com/apache/datafusion/issues/17055
### Describe the bug IS NOT NULL expressions are not inferred as boolean when used as inputs to another udf. ### To Reproduce Sqllogictest example: ``` statement ok create table t (a float) as values (1), (2), (3); # is not null query B select greatest(a is not null, false) from t; ---- true true true statement ok drop table t; ``` fails with: ``` query failed: DataFusion error: Execution error: Function 'greatest' user-defined coercion failed with "Error during planning: Cannot find a common type for arguments" [SQL] select greatest(a is not null, false) from t; ``` ### Expected behavior IS NOT NULL expressions should always be inferred as non-nullable boolean. ### Additional context I think I see the bug and will file a PR. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
