postgres.git / summary / log / commit / refs

commit    b44a55fa9563afcee05fda28fc9f0b0204d46d4d
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Oct 01 14:31:22 2015 +0000
First released in: 9.6.0, 9.0.23, 9.1.19, 9.2.14, 9.3.10, 9.4.5, 9.5.0

    Fix documentation error in commit 8703059c6b55c427100e00a09f66534b6ccbfaa1.
    
    Etsuro Fujita spotted a thinko in the README commentary.


src/backend/optimizer/README | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/backend/optimizer/README b/src/backend/optimizer/README index b896f91a3dd..b930354a292 100644 --- a/src/backend/optimizer/README +++ b/src/backend/optimizer/README @@ -254,7 +254,7 @@ lower leftjoin has min LHS of {B} and min RHS of {C,D}. Given such information, join_is_legal would think it's okay to associate the upper join into the lower join's RHS, transforming the query to B leftjoin (A leftjoin (C innerjoin D) on Pa) on (Pbcd) -which yields totally wrong answers. We prevent that by forcing the min LHS +which yields totally wrong answers. We prevent that by forcing the min RHS for the upper join to include B. This is perhaps overly restrictive, but such cases don't arise often so it's not clear that it's worth developing a more complicated system. [parent: 2bbe8a6847a0]