gongzexin opened a new issue, #11496: URL: https://github.com/apache/doris/issues/11496
### 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 1.1.1 ### What's Wrong? The result of left join operator is empty ### What You Expected? The result set is: CW20210501005770-CN CW20210521029956-CN CW20210521030543-CN2 CW20210521030543-CN3 CW20210527001972-CN CW20210528047020-CN CW20210528047872-CN CW20210528060253-CN2 CW20210615000339-CN CW20210615001054-CN CW20210615001354-CN CW20210615001648-CN CW20210616000480-CN CW20210616000562-CN CW20210616000786-TL CW20210616001075-DE CW20210616001220-DE CW20210616001611-AU CW20210616003135-TL CW20210616003200-TL CW20210617001525-CN CW20210621000107-CN CW20210621000228-CN CW20210621000440-CN CW20210621000571-CN CW20210621000850-CN6 CW20210622002707-CN CW20210628000595-CN2 CW20210628000595-CN3 CW20210628000949-CN CW20210629000528-DE2 CW20210629000909-DE2 CW20210629001025-DE2 DE20210628001 DE20210628003 DE20210628004 DE20210628005 DE20210629003 DE20210629010 DE20210630003 NC20210618002 NC20210618004 NC20210621001 NC20210621003 NC20210621005 NC20210621007 NC20210621009 NC20210622002 NC20210624001 NC20210630002 NC20210630003 ### How to Reproduce? [test_doris.txt](https://github.com/apache/doris/files/9256441/test_doris.txt) **After the test_doris.txt file is executed, the following SQL is executed with no result** SELECT a.column_31 FROM table1 AS a LEFT JOIN table2 AS g ON g.column_1=a.column_3 LEFT JOIN table5 AS s ON s.column_6=g.column_97 AND g.column_97 > 1 WHERE a.column_66=0 AND (CASE WHEN a.column_61>0 AND a.column_87>0 THEN 1 WHEN a.column_61=0 THEN 1 ELSE 0 END)=1 AND a.column_74=0 AND a.column_71 in (0,2) ORDER BY a.column_31 ASC; ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] 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
