Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

infer join side nullability for joined tables #5994

Closed
comphead opened this issue Apr 13, 2023 · 1 comment · Fixed by #6060
Closed

infer join side nullability for joined tables #5994

comphead opened this issue Apr 13, 2023 · 1 comment · Fixed by #6060
Labels
enhancement New feature or request

Comments

@comphead
Copy link
Contributor

comphead commented Apr 13, 2023

Is your feature request related to a problem or challenge?

Followup on #5748 which closes the issue with LEFT joins
This ticket to infer same nullability for RIGHT, FULL joins
Closes partially #5747 (FULL/Right join)

create table full_join_test as 
with t1 as (select 1 as col1, 'asd' as col2), 
     t2 as (select 1 as col3, 'sdf' as col4)
select col2, col4 from t1 full outer join t2 on col1 = col3;
Error during planning: Mismatch between schema and batches

create table temp as 
with t1 as (select 1 as col1, 'asd' as col2), 
     t2 as (select 1 as col3, 'sdf' as col4)
select col2, col4 from t1 right join t2 on col1 = col3;
Error during planning: Mismatch between schema and batches

Describe the solution you'd like

This ticket to infer nullability for RIGHT, FULL columns to prevent errors like Error during planning: Mismatch between schema and batches

Describe alternatives you've considered

None

Additional context

None

@comphead comphead added the enhancement New feature or request label Apr 13, 2023
@comphead
Copy link
Contributor Author

Working on this

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
1 participant