- Notifications
You must be signed in to change notification settings - Fork5
Commit5b1f9ce
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 tothrow it into the toplevel WHERE clause. Just don't push down thejoin in that case.To maximize the number of cases where we can still push down fulljoins, push inner join conditions into the ON clause at the firstopportunity rather than postponing them to the top-level WHEREclause. This produces nicer SQL, anyway.This bug was introduced ine4106b2.Ashutosh Bapat, per report from Rajkumar Raghuwanshi.1 parentcbabb70 commit5b1f9ce
File tree
3 files changed
+184
-98
lines changed- contrib/postgres_fdw
- expected
- sql
3 files changed
+184
-98
lines changed0 commit comments
Comments
(0)