Suppress subquery pullup/pushdown when a subquery contains volatile
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 19 Aug 2006 02:48:53 +0000 (02:48 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 19 Aug 2006 02:48:53 +0000 (02:48 +0000)
commitb05b5d4e5c262a9a79ca782bdd2dfa4e11d33b65
tree34223f005cacff665ed0286608b99ed54267dc68
parentbb1f9e6a367f54c680f6d96df0a770ff7de00abb
Suppress subquery pullup/pushdown when a subquery contains volatile
functions in its targetlist, to avoid introducing multiple evaluations
of volatile functions that textually appear only once.  This is a
slightly tighter version of Jaime Casanova's recent patch.
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/prep/prepjointree.c