Content-Length: 244163 | pFad | http://github.com/postgrespro/postgres_cluster/commit/5b1f9ce1d9e8dcae2bcd93b2becffaba5e4f3049

06 postgres_fdw: Don't push down certain full joins. · postgrespro/postgres_cluster@5b1f9ce · GitHub
Skip to content

Commit 5b1f9ce

Browse files
robertmhaasrobertmhaas
committed
postgres_fdw: Don't push down certain full joins.
If there's a filter condition on either side of a full outer join, it is neither correct to attach it to the join's ON clause nor to throw it into the toplevel WHERE clause. Just don't push down the join in that case. To maximize the number of cases where we can still push down full joins, push inner join conditions into the ON clause at the first opportunity rather than postponing them to the top-level WHERE clause. This produces nicer SQL, anyway. This bug was introduced in e4106b2. Ashutosh Bapat, per report from Rajkumar Raghuwanshi.
1 parent cbabb70 commit 5b1f9ce

File tree

3 files changed

+184
-98
lines changed

3 files changed

+184
-98
lines changed

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/5b1f9ce1d9e8dcae2bcd93b2becffaba5e4f3049

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy