[Bug] orca cannot generate a plan for query 'select t1.*, t2.* from t1 full join t2 on false where (t1.b < t1.b) is null'

[fanfuxiaoran]

Cloudberry Database version

create table t1(a int, b int);
create table t2(like t1);
select t1.*, t2.* from t1 full join t2 on false where (t1.b < t1.b) is null;

for query select t1.*, t2.* from t1 full join t2 on false where (t1.b < t1.b) is null; orca failed to generate a plan for it.

What happened

explain select t1.*, t2.* from t1 full join t2 on false where (t1.b < t1.b) is null;
LOG:  statement: explain select t1.*, t2.* from t1 full join t2 on false where (t1.b < t1.b) is null;
LOG:  2024-11-21 11:18:57:010057 CST,THD000,ERROR,"No plan has been computed for required properties",
2024-11-21 11:18:57:011228 CST,THD000,ERROR,"No plan has been computed for required properties",

What you think should happen instead

No response

How to reproduce

create table t1(a int, b int);
create table t2(like t1);
select t1.*, t2.* from t1 full join t2 on false where (t1.b < t1.b) is null;

Operating System

centos7

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.

[github-actions[bot]]

Hey, @fanfuxiaoran welcome!🎊 Thanks for taking the time to point this out.🙌