Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins. - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.
Date
Msg-id 6191.1306248297@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.  (Hitoshi Harada <umi.tanuki@gmail.com>)
Responses Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.
List pgsql-committers
Hitoshi Harada <umi.tanuki@gmail.com> writes:
> It looks to me like mergejoin_allowed should be initialized to false.
> If enable_mergejoin is off and jointype != JOIN_FULL then mergejoin is
> not allowed, isn't it? Sorry for noise if it's only my confusing.

No, the code is correct as-is: we need the flag to be set true by
default, because the way that the function is using it, we'll also skip
some nestloop possibilities when it's false.  Note the comment for step
2.

It could be that a different name for that flag variable would be a
better idea, but neither Robert nor I could come up with a better one.

            regards, tom lane

pgsql-committers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.
Next
From: Tom Lane
Date:
Subject: pgsql: Avoid uninitialized bits in the result of QTN2QT().