[Bug] hash join node should keep at least one column after projection

[starocean999]

Search before asking

• I had searched in the issues 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?

• Yes I am willing to submit a PR!

Code of Conduct

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