Should allow concatenating arrays with compatible types

[stdrc]

Describe the bug

No response

To Reproduce

select array[1]::int[] || array[1.2]::numeric[];
select 1::int || array[1.2]::numeric[];
select array[1.2]::numeric[] || 1::int;

Expected behavior

Should successfully concatenate the two arrays.

Additional context

#5060 (comment)

[CAJan93]

PR is merged and issue is finished. Thank you very much for you help @xiangjinwu