Arrays with elements other than literal are not supported

[jiangzhx]

Is your feature request related to a problem or challenge?

Using the CASE WHEN statement in ARRAY.

select [case when col1>0 then true else false end,case when col1>0 then true else false end];

Describe the solution you'd like

select [case when col1>0 then true else false end,case when col1>0 then true else false end];

Describe alternatives you've considered

perhaps this is a good place to give it a try.

https://github.com/apache/arrow-datafusion/blob/62816370822cb5e16a46d5050a41f62016af917f/datafusion/sql/src/expr/value.rs#L128-L151

Additional context

No response

[jiangzhx]

I'm not sure if this feature should be included in the discussion on the following issue:
#6980.

[jiangzhx]

I found another way to make this work.

select make_array(case when 1>0 then true else false end,case when 2>0 then true else false end);