• Tom Lane's avatar
    Fix set_append_rel_pathlist() to deal intelligently with cases where · 9b27eab7
    Tom Lane authored
    substituting a child rel's output expressions into the appendrel's restriction
    clauses yields a pseudoconstant restriction.  We might be able to skip scanning
    that child rel entirely (if we get constant FALSE), or generate a one-time
    filter.  8.3 more or less accidentally generated plans that weren't completely
    stupid in these cases, but that was only because an extra recursive level of
    subquery_planner() always occurred and allowed const-simplification to happen.
    8.4's ability to pull up appendrel members with non-Var outputs exposes the
    fact that we need to work harder here.  Per gripe from Sergey Burladyan.
    9b27eab7
prepunion.c 51.9 KB