Repository navigation
UNION ALL with null constants results in Schema error #13010
Description
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
NULLIt 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
Activity
alamb commentedon Oct 18, 2024
@wiedld is working on this one I believe -- see #12954
alamb commentedon Oct 21, 2024
I believe @itsjunetime may have some time to work on this this week.
itsjunetime commentedon Oct 22, 2024
take