Support ALL operator

[ovr]

Hello!

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

SELECT 1 = ALL(ARRAY[1,1,1,1]);

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Thanks

[NiwakaDev]

Hi @alamb,

Is this feature already supported? ALL seems not to work right now:

SELECT 1 = ALL(ARRAY[1,1,1,1]);
This feature is not implemented: Unsupported ast node in sqltorel: AllOp 

May I take this issue?

[alamb]

Feel free @NiwakaDev -- it might be worth checking / ensuring none of the existing fucntions do this:
https://datafusion.apache.org/user-guide/sql/scalar_functions.html#array-functions

If you want to add support, I think the right hting to do is to add a function array_all and then add a rule in the sql planner to plan the ALL... syntax to be a function call to array_all

This is similar to how the ARRAY(..) syntax is handled (it is rewritten to a call to the make_array function)

[NiwakaDev]

take

[Jefffrey]

Hey @NiwakaDev just checking in if you're still working on this; otherwise I'll remove the assignment to free it up

[NiwakaDev]

Hey @Jefffrey, I was actually working on this just now. If it’s not completed by the end of October, feel free to unassign me.