Open LizZhang315 opened 1 year ago
Please paste the table schema of mysql and doris.
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
Search before asking
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?
Code of Conduct