https://github.com/postgres/postgres
Revision fcd978c57d4ee50bd530490eee1191a155d60205 authored by Tom Lane on 25 October 2005, 20:30:45 UTC, committed by Tom Lane on 25 October 2005, 20:30:45 UTC
for an outer join; symptom is bogus error "RIGHT JOIN is only supported with
merge-joinable join conditions".  Problem was that select_mergejoin_clauses
did its tests in the wrong order.  We need to force left join not right join
for a merge join when there are non-mergeable join clauses; but the test for
this only accounted for mergejoinability of the clause operator, and not
whether the left and right Vars were of the proper relations.  Per report
from Jean-Pierre Pelletier.
1 parent 01145f9
History
Tip revision: fcd978c57d4ee50bd530490eee1191a155d60205 authored by Tom Lane on 25 October 2005, 20:30:45 UTC
Fix longstanding bug that would sometimes let the planner generate a bad plan
Tip revision: fcd978c
File Mode Size
config
contrib
doc
src
COPYRIGHT -rw-r--r-- 1.2 KB
GNUmakefile.in -rw-r--r-- 3.4 KB
Makefile -rw-r--r-- 1.4 KB
README -rw-r--r-- 1.3 KB
README.CVS -rw-r--r-- 767 bytes
aclocal.m4 -rw-r--r-- 442 bytes
configure -rwxr-xr-x 511.5 KB
configure.in -rw-r--r-- 39.0 KB

README

back to top