OSDN Git Service

Do not push down quals into subqueries that have LIMIT/OFFSET clauses,
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 16 Jul 2001 17:57:02 +0000 (17:57 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 16 Jul 2001 17:57:02 +0000 (17:57 +0000)
commit40db52af341f24d61950e8311f634ddfb278ee5b
tree3b05dd21a9ddfd160de24dc0afba073d4de581bf
parent8ba3548ebf68b176e79d35929514da698fb62bf8
Do not push down quals into subqueries that have LIMIT/OFFSET clauses,
since the added qual could change the set of rows that get past the
LIMIT.  Per discussion on pgsql-sql 7/15/01.
src/backend/optimizer/path/allpaths.c