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.

Sign up for GitHub

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

Jump to bottom

Unexpected Result with null in equality operator. #21351

Open
YuanchengJiang opened this issue May 17, 2023 · 1 comment
Open

Unexpected Result with null in equality operator. #21351

YuanchengJiang opened this issue May 17, 2023 · 1 comment
Labels
bug Something isn't working

Comments

@YuanchengJiang
Copy link

Bug Description
Unexpected Result with null in equality operator:

To Reproduce

select null=null;

Result: False

Expected Behavior
I guess the result should be None according to SQL standards or at least be True intuitively. Not sure if it is a bug or an intended feature?
@YuanchengJiang YuanchengJiang added the bug Something isn't working label May 17, 2023
@yu285
Copy link
Contributor

yu285 commented May 25, 2024

we will check on this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
2 participants
@YuanchengJiang @yu285