Skip to content

[SQL] Fix incorrect implementation of LEFT JOINs after sharing indexes#5936

Merged
mihaibudiu merged 1 commit intofeldera:mainfrom
mihaibudiu:issue5935
Mar 27, 2026
Merged

[SQL] Fix incorrect implementation of LEFT JOINs after sharing indexes#5936
mihaibudiu merged 1 commit intofeldera:mainfrom
mihaibudiu:issue5935

Conversation

@mihaibudiu
Copy link
Copy Markdown
Contributor

Fixes #5935

Checklist

  • Unit tests added/updated

@mihaibudiu
Copy link
Copy Markdown
Contributor Author

The bug was in the rewriting of the join functions when receiving inputs from a different index operator: the join function is actually the composition of the original join function with a function which shifts the indices of the input parameter to accommodate for the wider index output.

There was actually a much shorter fix, but it would generate worse code, because we haven't implemented #5507.
So I used a different method to achieve the same effect.

Signed-off-by: Mihai Budiu <mbudiu@feldera.com>
@mihaibudiu mihaibudiu added this pull request to the merge queue Mar 27, 2026
Copy link
Copy Markdown

@mythical-fred mythical-fred left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM.

Merged via the queue into feldera:main with commit 95428f7 Mar 27, 2026
1 check passed
@mihaibudiu mihaibudiu deleted the issue5935 branch March 27, 2026 08:06
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

[SQL] Compiler generates incorrect code when implementing shared join indexes

3 participants