Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

Commit 5b1f9ce

Browse filesBrowse 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
Copy full SHA for 5b1f9ce

File tree

Expand file treeCollapse file tree

3 files changed

+184
-98
lines changed
Filter options
Expand file treeCollapse file tree

3 files changed

+184
-98
lines changed

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.