Zhenghua Lyu

Thanks a lot for this PR. Will take a look at this soon.

> @kainwen, is this PR interesting? Thanks for reminding me. We are going to go through all the open PRs and try our best to make further steps.

Looks Good. Why WIP?

Hi, @cobolbaby Thanks for reporting the issue. Would you please paste the following SQL result (run them in the same session) here? ``` set gp_select_invisible = 1; select * from...

@cobolbaby do you set gp_select_invisible？

> > do you set gp_select_invisible？ > > No. I have not set this parameter before. So would you please collect the result as I mentioned in https://github.com/greenplum-db/gpdb/issues/13809#issuecomment-1186130642 ```sql set...

The direct reason seems that there is a bad buffer in shared buffer, a buffer is dirty and point to the not-exists path. Then any SQL in theory might lead...

Would you please describe what plan you want to get?

Hi, with your minirepro, in my local env, ORCA can produce a very good plan: ``` demo=# explain select * from item2_jd t1 join itemattr2_jd t2 on t1.cat1=t2.cat1 and t1.time=t2.time...

I am looking into this. Thanks for the PR.