Unclear error message when calling a function with no parameters. #10915
Description
Is your feature request related to a problem or challenge?
The changes in #10651 lead to a change in the error messages given when a function is called without any arguments. I think it can be made a little clearer to the user what actually went wrong.
The current error message in main:
"Error during planning: Error during planning: [data_types_with_aggregate_udf] Coercion from [] to the signature VariadicAny failed. and No function matches the given name and argument types 'selector_last()'. You might need to add explicit type casts.\n\tCandidate functions:\n\tselector_last(Any, .., Any)"
Describe the solution you'd like
An error that displays to the user that they called a function that requires arguments without providing any. One example could be:
"Error during planning: Error during planning: SUM does not support zero arguments. No function matches the given name and argument types 'SUM()'. You might need to add explicit type casts.\n\tCandidate functions:\n\tSUM(UserDefine
d)"
Describe alternatives you've considered
No response
Additional context
No response