We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
SELECT count(null) FROM test returns 5, i.e. it counts null as a not-null value.
SELECT count(null) FROM test
null
Add a test SELECT count(null) FROM test
It should return 0, same as SELECT count(null::int) FROM test e.g. if we cast the null to another type.
SELECT count(null::int) FROM test
Confusing Arrow behaviour (but they will not change it): apache/arrow-rs#4838
The text was updated successfully, but these errors were encountered:
Successfully merging a pull request may close this issue.
Describe the bug
SELECT count(null) FROM test
returns 5, i.e. it countsnull
as a not-null value.To Reproduce
Add a test
SELECT count(null) FROM test
Expected behavior
It should return 0, same as
SELECT count(null::int) FROM test
e.g. if we cast thenull
to another type.Additional context
Confusing Arrow behaviour (but they will not change it): apache/arrow-rs#4838
The text was updated successfully, but these errors were encountered: