starocean999 opened a new issue, #12093: URL: https://github.com/apache/doris/issues/12093
### 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? `select CASE WHEN true THEN 1 ELSE 1 END AS c0 FROM (SELECT a AS c0 FROM outerjoin_A ) AS subq_1 RIGHT JOIN (SELECT a AS c0 FROM outerjoin_B ) AS subq_2 ON (subq_1.c0 = subq_2.c0 );` The above sql would crash. Because the hash join node has no column to output after projection. ### What You Expected? the sql execute correctly. ### How to Reproduce? _No response_ ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
