Use OFFSET 0 instead of ORDER BY to stop subquery pullup

David Rowley <drowley@postgresql.org>

Commit: 0765b2f8f6fe8b7c1c07f94b764ef8bb74a292b4
Author: David Rowley <drowley@postgresql.org>
Date: 2023-01-24T00:50:11Z
Releases: 14.7
Use OFFSET 0 instead of ORDER BY to stop subquery pullup

b762fed64 recently changed this test to prevent subquery pullup to allow
us to test Memoize with lateral_vars.  As pointed out by Tom Lane, OFFSET
0 is our standard way of preventing subquery pullups, so do it that way
instead.

Discussion: https://postgr.es/m/2144818.1674517061@sss.pgh.pa.us
Backpatch-through: 14, same as b762fed64

Files

PathChange+/−
src/test/regress/expected/memoize.out modified +2 −2
src/test/regress/sql/memoize.sql modified +2 −2

Discussion

Cited messages not in the archive: 2144818.1674517061@sss.pgh.pa.us