Richard Guo <guofengli...@gmail.com> writes: > On Fri, Nov 29, 2024 at 7:33 AM Tom Lane <t...@sss.pgh.pa.us> wrote: >> It seems to be sufficient to just not mark lateral >> references at all in this case. (I have a nagging feeling that more >> complexity may be needed in cases where there are several levels of >> outer join, but some attempts to break it with that didn't succeed.)
> You're right about your feeling. Here is a query that breaks it. Ah, thanks for the test case. I'll look into it tomorrow. regards, tom lane