Skip to content

Fix "NULL IN [NULL]" #1805

Merged
mergify[bot] merged 1 commit intoArcadeData:mainfrom
gramian:incond
Nov 1, 2024
Merged

Fix "NULL IN [NULL]" #1805
mergify[bot] merged 1 commit intoArcadeData:mainfrom
gramian:incond

Conversation

@gramian
Copy link
Copy Markdown
Collaborator

@gramian gramian commented Oct 31, 2024

What does this PR do?

This change makes an IN-condition return true if left and right side are null. This is necessary because the existing test with queryOperatorEquals returns false as soon as one operand is null (which is generally correct in terms of null arithmetic). This solution is likely not the most elegant but it seems to work. @lvca feel free to suggesst better solutions.

Related issues

#1785

I suspected that InCondition could still be a problem even if InOperator works: #1785 (comment)

Checklist

  • I have run the build using mvn clean package command
  • My unit tests cover both failure and success scenarios

@gramian gramian requested a review from lvca October 31, 2024 21:08
Copy link
Copy Markdown
Member

@lvca lvca left a comment

Choose a reason for hiding this comment

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

Good for me, thanks!!!

@lvca lvca added the bug label Nov 1, 2024
@lvca lvca added this to the 24.11.1 milestone Nov 1, 2024
@mergify mergify bot merged commit 926712d into ArcadeData:main Nov 1, 2024
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.

2 participants