You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "joroKr21 (via GitHub)" <gi...@apache.org> on 2023/12/12 07:40:09 UTC

[I] COUNT(NULL) should always return 0 [arrow-datafusion]

joroKr21 opened a new issue, #8509:
URL: https://github.com/apache/arrow-datafusion/issues/8509

   ### Describe the bug
   
   `SELECT count(null) FROM test` returns 5, i.e. it counts `null` 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 the `null` to another type.
   
   ### Additional context
   
   _No response_


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] COUNT(NULL) should always return 0 [arrow-datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #8509: COUNT(NULL) should always return 0
URL: https://github.com/apache/arrow-datafusion/issues/8509


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] COUNT(NULL) should always return 0 [arrow-datafusion]

Posted by "joroKr21 (via GitHub)" <gi...@apache.org>.
joroKr21 commented on issue #8509:
URL: https://github.com/apache/arrow-datafusion/issues/8509#issuecomment-1851515850

   See https://github.com/apache/arrow-rs/pull/4838


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org