Re: [sqlsmith] Parallel worker crash on seqscan - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [sqlsmith] Parallel worker crash on seqscan
Date
Msg-id 22470.1479747637@sss.pgh.pa.us
Whole thread Raw
In response to Re: [sqlsmith] Parallel worker crash on seqscan  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [sqlsmith] Parallel worker crash on seqscan  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Nov 21, 2016 at 11:43 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> so what we've got is a case where a parameter computed by the FunctionScan
>> (in the master) would need to be passed into the parallel workers at
>> runtime.  Do we have code for that at all?  If so where is it?

> No, that's not supposed to happen.

OK, that makes this a planner failure: we should not have allowed this
query to become parallelized.

> Maybe it's checking the quals but not recursing into the tlist?

It seems like maybe searching for individual Params is the wrong thing.
Why are we allowing it to generate a parameterized Gather path at all?
Given the lack of any way to transmit runtime param values to the worker,
I can't see how that would ever work.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [sqlsmith] Parallel worker crash on seqscan
Next
From: Kevin Grittner
Date:
Subject: Re: delta relations in AFTER triggers