Fix logical vs physical schema mismatch for UNION where some inputs are constants

Fix logical vs physical schema mismatch for UNION where some inputs are constants #34285