UNION ALL with null constants results in Schema error

[alamb]

Describe the bug

UNION ALL with null constants results in Schema error

To Reproduce

Run the following query from https://github.com/apache/datafusion/blob/main/datafusion/sqllogictest/test_files/metadata.slt

query T
select name from (
  SELECT nonnull_name as name FROM "table_with_metadata"
  UNION ALL
  SELECT NULL::string as name
) group by name order by name;
----
no_bar
no_baz
no_foo
NULL

It results with

External error: query failed: DataFusion error: Schema error: No field named nonnull_name. Valid fields are table_with_metadata.id, table_with_metadata.name, table_with_metadata.l_name. [SQL] select name from ( SELECT nonnull_name as name FROM "table_with_metadata" UNION ALL SELECT NULL::string as name ) group by name order by name; at test_files/metadata.slt:127 Error: Execution("1 failures") error: test failed, to rerun pass `-p datafusion-sqllogictest --test sqllogictests`

Expected behavior

Query should complete

Additional context

No response

[alamb]

@wiedld is working on this one I believe -- see https://github.com/apache/datafusion/pull/12954

[alamb]

I believe @itsjunetime may have some time to work on this this week.

[itsjunetime]

take