Describe the bug
#14538 introduced UNION [ALL] BY NAME. A few of the tests in the union_by_name.slt currently fail due to the sanity checker (here for example).
Investigate and fix these failing tests.
To Reproduce
No response
Expected behavior
No response
Additional context
No response