chenlinzhong opened a new issue, #12851: URL: https://github.com/apache/doris/issues/12851
### 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. ### 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](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
