[Bug] PG optimizer will core in LASJ_NOTIN case

[jiaqizho]

Apache Cloudberry version

Current main branch is 6cec348

What happened

create table t_13722(id int, tt timestamp)
  distributed by (id);
  
set optimizer to off;
select
  t1.*
from
  t_13722 t1
where
  t1.id not in (select id from t_13722 where id != 4)
  and
  t1.tt = (select min(tt) from t_13722 where id = t1.id);

What you think should happen instead

No response

How to reproduce

upper

Operating System

no relatived

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.

[jiaqizho]

I am not sure whether this case cause by cherry-pick missing some commits or not...

[yjhjstz]

pls cherry-pick Possible qual postponing past ANTI-JOIN/LASJ_NOTIN-JOIN..

[yjhjstz]

fixed by #878