aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial
diff options
context:
space:
mode:
authorDavid Rowley <drowley@postgresql.org>2023-01-24 12:29:57 +1300
committerDavid Rowley <drowley@postgresql.org>2023-01-24 12:29:57 +1300
commit73f77ab508d1514ca604c47b6f56c5dee4dd9025 (patch)
treed4cf9139c2fbf70208dd1e6ebf437e423fc9720a /src/tutorial
parent95f62b16a3344e48ecce1ceb2882e5af24c13a1b (diff)
downloadpostgresql-73f77ab508d1514ca604c47b6f56c5dee4dd9025.tar.gz
postgresql-73f77ab508d1514ca604c47b6f56c5dee4dd9025.zip
Fix LATERAL join test in test memoize.sql
The test in question was meant to be testing Memoize to ensure it worked correctly when the inner side of the join contained lateral vars, however, nothing in the lateral subquery stopped it from being pulled up into the main query, so the planner did that, and that meant no more lateral vars. Here we add a simple ORDER BY to stop the planner from being able to pullup the lateral subquery. Author: Richard Guo Discussion: https://postgr.es/m/CAMbWs4_LHJaN4L-tXpKMiPFnsCJWU1P8Xh59o0W7AA6UN99=cQ@mail.gmail.com Backpatch-through: 14, where Memoize was added.
Diffstat (limited to 'src/tutorial')
0 files changed, 0 insertions, 0 deletions