Re: pgsql: Fix LATERAL join test in test memoize.sql

On Tue, 24 Jan 2023 at 12:37, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Hmmm ... we have an agreed syntax for a subquery optimization fence,
> and that ain't it.  I wouldn't count on this not breaking again in
> the future.  Why not OFFSET 0, which is the usual method?

You're right that OFFSET 0 would have been a better choice. I just
wasn't aware that we were considering changing the code so we pull up
subqueries with an ORDER BY. In fact, I thought there were several
good reasons we're not doing that. e.g. allow aggregation in outer
query by some order specified by the subquery. But perhaps any changes
we make in this area would be more conditional than just ignoring the
fact that the subquery has an ORDER BY.

In any case, I agree that OFFSET 0 is a better choice, so I'll go and edit that.

David