Re: Consistent segfault in complex query - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: Consistent segfault in complex query
Date
Msg-id 878t46pu1b.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Consistent segfault in complex query  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
>>>>> "Andrew" == Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
>>>>> "Kyle" == Kyle Samson <kysamson@tripadvisor.com> writes:

 Kyle> This is on a 9.3.19 server and we saw no
 Kyle> mention of a fix in the release notes since this version and we
 Kyle> do not know if it affects later major releases as well.

 Andrew> There's a relevant commit from Feb this year (ea6d67cf8)
 Andrew> specifically referring to the case of CTEs inside subplans
 Andrew> inside EvalPlanQual, which is exactly the scenario you have in
 Andrew> your query. So you need to try this in 9.3.22 or later (ideally
 Andrew> 9.3.24, the latest) which contain this fix.

Kyle, you can disregard this suggestion because I've now confirmed the
bug still exists in 9.3.24 (actually in REL9_3_STABLE head).

-- 
Andrew (irc:RhodiumToad)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting ERROR: could not open file "base/13164/t3_16388" with partition table with ON COMMIT
Next
From: Andrew Gierth
Date:
Subject: Re: Consistent segfault in complex query