aboutsummaryrefslogtreecommitdiff
path: root/src/backend/executor/nodeSubplan.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2012-08-30 14:32:22 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2012-08-30 14:33:00 -0400
commit77387f0ac859c099c6ab669db1e7a852524696c4 (patch)
treebd1de1f24e2b5b9f90e5c11eb18d11ba041eab77 /src/backend/executor/nodeSubplan.c
parent35738b5906bb80bc4bb77ce1adea7dfbd3f64274 (diff)
downloadpostgresql-77387f0ac859c099c6ab669db1e7a852524696c4.tar.gz
postgresql-77387f0ac859c099c6ab669db1e7a852524696c4.zip
Suppress creation of backwardly-indexed paths for LATERAL join clauses.
Given a query such as SELECT * FROM foo JOIN LATERAL (SELECT foo.var1) ss(x) ON ss.x = foo.var2 the existence of the join clause "ss.x = foo.var2" encourages indxpath.c to build a parameterized path for foo using any index available for foo.var2. This is completely useless activity, though, since foo has got to be on the outside not the inside of any nestloop join with ss. It's reasonably inexpensive to add tests that prevent creation of such paths, so let's do that.
Diffstat (limited to 'src/backend/executor/nodeSubplan.c')
0 files changed, 0 insertions, 0 deletions