You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/11/23 03:25:42 UTC
[GitHub] [arrow-datafusion] liukun4515 opened a new issue, #4335: can't compare boolean type with NULL type
liukun4515 opened a new issue, #4335:
URL: https://github.com/apache/arrow-datafusion/issues/4335
**Describe the bug**
A clear and concise description of what the bug is.
```
❯ explain select false and null;
Plan("'Boolean AND Null' can't be evaluated because there isn't a common type to coerce the types to")
❯ explain select false or null;
Plan("'Boolean OR Null' can't be evaluated because there isn't a common type to coerce the types to")
❯
```
**To Reproduce**
Steps to reproduce the behavior:
**Expected behavior**
A clear and concise description of what you expected to happen.
**Additional context**
Add any other context about the problem here.
--
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
[GitHub] [arrow-datafusion] liukun4515 commented on issue #4335: can't compare boolean type with NULL type
Posted by GitBox <gi...@apache.org>.
liukun4515 commented on issue #4335:
URL: https://github.com/apache/arrow-datafusion/issues/4335#issuecomment-1324505207
maybe has been fixed by https://github.com/apache/arrow-datafusion/pull/4242
--
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
[GitHub] [arrow-datafusion] jackwener commented on issue #4335: can't compare boolean type with NULL type
Posted by GitBox <gi...@apache.org>.
jackwener commented on issue #4335:
URL: https://github.com/apache/arrow-datafusion/issues/4335#issuecomment-1324703949
Not supported is normal, the two types are not compatible.
--
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
[GitHub] [arrow-datafusion] jackwener commented on issue #4335: can't compare boolean type with NULL type
Posted by GitBox <gi...@apache.org>.
jackwener commented on issue #4335:
URL: https://github.com/apache/arrow-datafusion/issues/4335#issuecomment-1324705384
I can do it.
--
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
[GitHub] [arrow-datafusion] alamb closed issue #4335: can't compare NULL type with NULL type
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #4335: can't compare NULL type with NULL type
URL: https://github.com/apache/arrow-datafusion/issues/4335
--
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
[GitHub] [arrow-datafusion] melgenek commented on issue #4335: can't compare NULL type with NULL type
Posted by "melgenek (via GitHub)" <gi...@apache.org>.
melgenek commented on issue #4335:
URL: https://github.com/apache/arrow-datafusion/issues/4335#issuecomment-1413436700
@jackwener Hey! This issue is assigned to you. But I bumped into it and decided to give it a try, so I opened a pr https://github.com/apache/arrow-datafusion/pull/5158. I hope it is alright.
--
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
[GitHub] [arrow-datafusion] HaoYang670 commented on issue #4335: can't compare boolean type with NULL type
Posted by GitBox <gi...@apache.org>.
HaoYang670 commented on issue #4335:
URL: https://github.com/apache/arrow-datafusion/issues/4335#issuecomment-1324618829
Two cases not supported yet:
```sql
❯ select null and null;
ArrowError(ExternalError(Internal("Cannot evaluate binary expression And with types Null and Null")))
❯ select null or null;
ArrowError(ExternalError(Internal("Cannot evaluate binary expression Or with types Null and Null")))
```
While on Postgre, we get nulls: https://onecompiler.com/postgresql
--
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
[GitHub] [arrow-datafusion] jackwener commented on issue #4335: can't compare NULL type with NULL type
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener commented on issue #4335:
URL: https://github.com/apache/arrow-datafusion/issues/4335#issuecomment-1413556495
Thank you @melgenek
I try to fix it but meet problem, so I forgot it🥲, sorry for it.
--
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