pgsql: Fix generation of EC join conditions at the wrong plan level.

2024-04-16 Thread Tom Lane
Fix generation of EC join conditions at the wrong plan level. get_baserel_parampathinfo previously assumed without checking that the results of generate_join_implied_equalities "necessarily satisfy join_clause_is_movable_into". This turns out to be wrong in the presence of outer joins, because th

pgsql: Fix generation of EC join conditions at the wrong plan level.

2024-04-16 Thread Tom Lane
Fix generation of EC join conditions at the wrong plan level. get_baserel_parampathinfo previously assumed without checking that the results of generate_join_implied_equalities "necessarily satisfy join_clause_is_movable_into". This turns out to be wrong in the presence of outer joins, because th

pgsql: Fix generation of EC join conditions at the wrong plan level.

2024-04-16 Thread Tom Lane
Fix generation of EC join conditions at the wrong plan level. get_baserel_parampathinfo previously assumed without checking that the results of generate_join_implied_equalities "necessarily satisfy join_clause_is_movable_into". This turns out to be wrong in the presence of outer joins, because th

pgsql: Fix generation of EC join conditions at the wrong plan level.

2024-04-16 Thread Tom Lane
Fix generation of EC join conditions at the wrong plan level. get_baserel_parampathinfo previously assumed without checking that the results of generate_join_implied_equalities "necessarily satisfy join_clause_is_movable_into". This turns out to be wrong in the presence of outer joins, because th