unexpected output for `concat` for arrays

### Describe the bug

`concat` builtin in function should concat arrays like `array_concat`, currently the output is wrong

```
> select concat(make_array(1, 2, 3), make_array(4, 5));
+------------------------------------------------------------------------------+
| concat(make_array(Int64(1),Int64(2),Int64(3)),make_array(Int64(4),Int64(5))) |
+------------------------------------------------------------------------------+
| [1, 2, 3][4, 5] |
+------------------------------------------------------------------------------+
1 row(s) fetched.
Elapsed 0.012 seconds.

> select array_concat(make_array(1, 2, 3), make_array(4, 5));
+------------------------------------------------------------------------------------+
| array_concat(make_array(Int64(1),Int64(2),Int64(3)),make_array(Int64(4),Int64(5))) |
+------------------------------------------------------------------------------------+
| [1, 2, 3, 4, 5] |
+------------------------------------------------------------------------------------+
1 row(s) fetched.
Elapsed 0.014 seconds.

```

`concat` for array should return same as `array_concat`

### To Reproduce

_No response_

### Expected behavior

_No response_

### Additional context

_No response_

Start at the concat and array_concat function entry points in DataFusion and compare the array behavior shown in the reproduction. Add or update coverage for concat(make_array(1, 2, 3), make_array(4, 5)) so its result matches array_concat and returns [1, 2, 3, 4, 5].

Written by the indexing model from the issue text.