[COMMITTERS] pgsql: Teach predtest.c that "foo" implies "foo IS NOT NULL".

2015-08-01 Thread Tom Lane
Teach predtest.c that "foo" implies "foo IS NOT NULL". Per complaint from Peter Holzer. It's useful to cover this special case, since for a boolean variable "foo", earlier parts of the planner will have reduced variants like "foo = true" to just "foo", and thus we may fail to recognize the applic

[COMMITTERS] pgsql: Teach predtest.c that "foo" implies "foo IS NOT NULL".

2015-08-01 Thread Tom Lane
Teach predtest.c that "foo" implies "foo IS NOT NULL". Per complaint from Peter Holzer. It's useful to cover this special case, since for a boolean variable "foo", earlier parts of the planner will have reduced variants like "foo = true" to just "foo", and thus we may fail to recognize the applic

[COMMITTERS] pgsql: Fix some planner issues with degenerate outer join clauses.

2015-08-01 Thread Tom Lane
Fix some planner issues with degenerate outer join clauses. An outer join clause that didn't actually reference the RHS (perhaps only after constant-folding) could confuse the join order enforcement logic, leading to wrong query results. Also, nested occurrences of such things could trigger an As

[COMMITTERS] pgsql: Fix some planner issues with degenerate outer join clauses.

2015-08-01 Thread Tom Lane
Fix some planner issues with degenerate outer join clauses. An outer join clause that didn't actually reference the RHS (perhaps only after constant-folding) could confuse the join order enforcement logic, leading to wrong query results. Also, nested occurrences of such things could trigger an As

[COMMITTERS] pgsql: Fix some planner issues with degenerate outer join clauses.

2015-08-01 Thread Tom Lane
Fix some planner issues with degenerate outer join clauses. An outer join clause that didn't actually reference the RHS (perhaps only after constant-folding) could confuse the join order enforcement logic, leading to wrong query results. Also, nested occurrences of such things could trigger an As

[COMMITTERS] pgsql: Fix some planner issues with degenerate outer join clauses.

2015-08-01 Thread Tom Lane
Fix some planner issues with degenerate outer join clauses. An outer join clause that didn't actually reference the RHS (perhaps only after constant-folding) could confuse the join order enforcement logic, leading to wrong query results. Also, nested occurrences of such things could trigger an As

[COMMITTERS] pgsql: Fix some planner issues with degenerate outer join clauses.

2015-08-01 Thread Tom Lane
Fix some planner issues with degenerate outer join clauses. An outer join clause that didn't actually reference the RHS (perhaps only after constant-folding) could confuse the join order enforcement logic, leading to wrong query results. Also, nested occurrences of such things could trigger an As

[COMMITTERS] pgsql: Fix some planner issues with degenerate outer join clauses.

2015-08-01 Thread Tom Lane
Fix some planner issues with degenerate outer join clauses. An outer join clause that didn't actually reference the RHS (perhaps only after constant-folding) could confuse the join order enforcement logic, leading to wrong query results. Also, nested occurrences of such things could trigger an As

[COMMITTERS] pgsql: Fix some planner issues with degenerate outer join clauses.

2015-08-01 Thread Tom Lane
Fix some planner issues with degenerate outer join clauses. An outer join clause that didn't actually reference the RHS (perhaps only after constant-folding) could confuse the join order enforcement logic, leading to wrong query results. Also, nested occurrences of such things could trigger an As