Thread: pgsql: Adjust the definition of is_pushed_down so that it's always true
pgsql: Adjust the definition of is_pushed_down so that it's always true
From
tgl@postgresql.org (Tom Lane)
Date:
Log Message: ----------- Adjust the definition of is_pushed_down so that it's always true for INNER JOIN quals, just like WHERE quals, even if they reference every one of the join's relations. Now that we can reorder outer and inner joins, it's possible for such a qual to end up being assigned to an outer join plan node, and we mustn't have it treated as a join qual rather than a filter qual for the node. (If it were, the join could produce null-extended rows that it shouldn't.) Per bug report from Pelle Johansson. Tags: ---- REL8_2_STABLE Modified Files: -------------- pgsql/src/backend/optimizer/plan: initsplan.c (r1.123.2.3 -> r1.123.2.4) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/initsplan.c.diff?r1=1.123.2.3&r2=1.123.2.4) pgsql/src/include/nodes: relation.h (r1.128 -> r1.128.2.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/relation.h.diff?r1=1.128&r2=1.128.2.1)