Search before asking

• I had searched in the issues 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:

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?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct