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-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
