[Bug] [daily] right outer join 'on' only left table condition result diff from mysql

[LizZhang315]

Search before asking

• I had searched in the issues and found no similar issues.

Version

doris-0.0.0-trunk-0222056

What's Wrong?

palo result is different from mysql result
SQL:
select count(*) from baseall a right outer join test b on a.k1 >0;

palo result:

mysql result:

test data can be seen: https://doris-case.cdn.bcebos.com/data/init.zip

What You Expected?

palo result and mysql result are the same

How to Reproduce?

No response

Anything Else?

No response

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

[smallhibiscus]

Please paste the table schema of mysql and doris.

[LizZhang315]

Please paste the table schema of mysql and doris.

create table test_db.test(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5

create table test_db.baseall(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5