Re: [HACKERS] [sqlsmith] Planner crash on foreign table join - Mailing list pgsql-hackers

From Mark Dilger
Subject Re: [HACKERS] [sqlsmith] Planner crash on foreign table join
Date
Msg-id D323FE6C-13D7-47B0-8453-D3DB011D72D8@gmail.com
Whole thread Raw
In response to Re: [HACKERS] [sqlsmith] Planner crash on foreign table join  (Mark Dilger <hornschnorter@gmail.com>)
List pgsql-hackers
> On Apr 8, 2017, at 7:41 PM, Mark Dilger <hornschnorter@gmail.com> wrote:
>
>
>> On Apr 8, 2017, at 7:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> Mark Dilger <hornschnorter@gmail.com> writes:
>>> This is very near where the original crash reported in this thread was crashing, probably only
>>> different due to the extra lines of Assert that were added.  Am I missing some portion of the
>>> fix that you are testing?  I have only applied the patch that Tom included in the previous email.
>>
>> No, that was the whole patch --- but did you do a full "make clean" and
>> rebuild?  The patch changed NodeTag numbers which would affect the whole
>> tree.
>
> <snip>

> I'm going to pull completely fresh sources and reapply and retest, though you are welcome
> to review my patch while I do that.

That fixed it.  Thanks.




pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: [HACKERS] [sqlsmith] Planner crash on foreign table join
Next
From: David Rowley
Date:
Subject: Re: [HACKERS] Performance improvement for joins where outer side is unique