NOT operator should not return internal error when args are not boolean value #8965
Description
Describe the bug
❯ select not('hi');
Internal error: NOT 'Literal { value: Utf8("hi") }' can't be evaluated because the expression's type is Utf8, not boolean or NULL.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
❯ select 1 and 2;
Error during planning: Cannot infer common argument type for logical boolean operation Int64 AND Int64
I think the return error message of NOT should like And operator, they both only work for boolean value.
Originally posted by @haohuaijin in #8957 (comment)
To Reproduce
No response
Expected behavior
No response
Additional context
No response