[Bug] left join result not correct

[chenlinzhong]

Search before asking

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

Version

master

What's Wrong?

In the case of multiple copies of the left join, the vectorization and non vectorization results are different, and the vectorization results are correct

left join 在多副本情况下，向量化和非向量化的结果不一样，向量化的结果是正确的

create table T_CORE_MAIN(
   ID bigint not null,
   CRCL_NO varchar(100)  null,
   PARENT_ID BIGINT(20) NULL
)ENGINE=OLAP
UNIQUE KEY(`ID`)
COMMENT "DD"
DISTRIBUTED BY HASH(`ID`) BUCKETS 3
PROPERTIES(
       "replication_allocation"="tag.location.default:3",
       "in_memory"="false",
       "storage_format"="V2"
) ;

create table T_CORE_MAIN_STATUS(
           ID bigint(20) not null,
           CRCL_ID bigint(20) null,
           CRCL_VALID bigint(20) null comment ""
)ENGINE=OLAP
UNIQUE KEY(`ID`)
DISTRIBUTED BY HASH(`ID`) BUCKETS 3
PROPERTIES(
       "replication_allocation"="tag.location.default:3",
       "in_memory"="false",
       "storage_format"="V2"
) ;

INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES (329586, 'YX20191217-000003',NULL);
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES (329687, 'YX20191217-000003-0004','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329688', 'YX20191217-000003-0005','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329689','YX20191217-000003-0006','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329709', 'YX20191217-000003-0007','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329710','YX20191217-000003-0008','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329712', 'YX20191217-000003-0010','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329684','YX20191217-000003-0002','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329686', 'YX20191217-000003-0003','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329934', 'YX20191217-000003-0014','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329937', 'YX20191217-000003-0015','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES('329947','YX20191217-000003-0017','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('348093', 'YX20191217-000003-0018qs','329586'); 
INSERT INTO T_CORE_MAIN (ID,CRCL_NO,PARENT_ID) VALUES ('329620', 'YX20191217-000003-0001', '329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329711', 'YX20191217-000003-0009','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329713','YX20191217-000003-0011','329586'); 
INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID)VALUES ('329714','YX20191217-000003-0012','329586');
 INSERT INTO T_CORE_MAIN(ID,CRCL_NO,PARENT_ID) VALUES ('329938','YX20191217-000003-0016','329586'); 
select * from T_CORE_MAIN;
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170120090751','329713','1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170128018559', '329620', '-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170128260223', '329937','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170128869503', '329688','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170128988287', '329712', '-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES('220171170115265663','329938','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES('220171170128459903','329934','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170128868479', '329687','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES('220171170128870527','329689','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170128987263', '329711', '-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170107852927', '329684','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170112455807','348093','1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170115268735','329947','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES('220171170128867455','329686','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170129379455','329709','-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES('220171170129380479', '329710', '-1'); 
INSERT INTO T_CORE_MAIN_STATUS(ID,CRCL_ID,CRCL_VALID) VALUES ('220171170129381503', '329714', '-1');



SELECT T.CRCL_NO,T1.CRCL_NO,T1.ID,T2.CRCL_ID,T2.CRCL_VALID
FROM T_CORE_MAIN T
LEFT JOIN T_CORE_MAIN T1 ON T1.PARENT_ID=T.ID
LEFT JOIN T_CORE_MAIN_STATUS T2 ON T2.CRCL_ID=T1.ID WHERE T.CRCL_NO IN('YX20191217-000003');

What You Expected?

i hope the result between vectorize and not vectorize is 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

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