Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Fix LATERAL join test in test memoize.sql - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Fix LATERAL join test in test memoize.sql
Date
Msg-id 2144818.1674517061@sss.pgh.pa.us
Whole thread Raw
In response to pgsql: Fix LATERAL join test in test memoize.sql  (David Rowley <drowley@postgresql.org>)
Responses Re: pgsql: Fix LATERAL join test in test memoize.sql  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-committers
Tree view 
David Rowley <drowley@postgresql.org> writes:
> Here we add a simple ORDER BY to stop the planner from being able to
> pullup the lateral subquery.

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?

            regards, tom lane

pgsql-committers by date:

Previous
From: David Rowley
Date:
Subject: pgsql: Fix LATERAL join test in test memoize.sql
Next
From: David Rowley
Date:
Subject: Re: pgsql: Fix LATERAL join test in test memoize.sql