You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "alamb (via GitHub)" <gi...@apache.org> on 2024/10/18 19:37:30 UTC
[I] UNION ALL with null constants results in Schema error [datafusion]
alamb opened a new issue, #13010:
URL: https://github.com/apache/datafusion/issues/13010
### 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
```sql
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_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] UNION ALL with null constants results in Schema error [datafusion]
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #13010:
URL: https://github.com/apache/datafusion/issues/13010#issuecomment-2423121116
@wiedld is working on this one I believe -- see https://github.com/apache/datafusion/pull/12954
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] UNION ALL with null constants results in Schema error [datafusion]
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #13010:
URL: https://github.com/apache/datafusion/issues/13010#issuecomment-2427210208
I believe @itsjunetime may have some time to work on this this week.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] UNION ALL with null constants results in Schema error [datafusion]
Posted by "itsjunetime (via GitHub)" <gi...@apache.org>.
itsjunetime commented on issue #13010:
URL: https://github.com/apache/datafusion/issues/13010#issuecomment-2430364916
take
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] UNION ALL with null constants results in Schema error [datafusion]
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #13010: UNION ALL with null constants results in Schema error
URL: https://github.com/apache/datafusion/issues/13010
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org