You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/04/15 05:56:04 UTC
[GitHub] [incubator-doris] jackwener opened a new issue, #9042: [Feature] Split the implict `is not null` from `whereclause`
jackwener opened a new issue, #9042:
URL: https://github.com/apache/incubator-doris/issues/9042
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Description
*It's original from the comment from #9018, more detail discussion in it*
> For comparison operator, semantics is different in select expr and where expr. Only where expr implicit include is not null.
I'd like to split the predicate with implicit `is not null` from `whereclause`, like:
```sql
select * from table where c1 > 0;
--->
select * from table where c1 > 0 and c1 is not null;
```
After this, I don't need to consider `implicit not null` in `whereclause predicate` 😍
Like #7698 #9016, we just need to consider the explicit `not null`.
### Use case
_No response_
### Related issues
- #9018
- #7698
- #9016
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] jackwener closed issue #9042: [Feature] Split the implict `is not null` from `whereclause`
Posted by GitBox <gi...@apache.org>.
jackwener closed issue #9042: [Feature] Split the implict `is not null` from `whereclause`
URL: https://github.com/apache/doris/issues/9042
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org