Re: [HACKERS] [sqlsmith] ERROR: plan should not reference subplan's variable

2016-07-01 Thread Tom Lane
Robert Haas writes: > On Fri, Jul 1, 2016 at 5:29 PM, Tom Lane wrote: >> ... but if I try to actually execute the query, it crashes at runtime, >> apparently because the CTE has not been passed over to the parallel >> worker. Robert, is it expected that CTEs should be parallel-safe? >> I'd have

Re: [HACKERS] [sqlsmith] ERROR: plan should not reference subplan's variable

2016-07-01 Thread Robert Haas
On Fri, Jul 1, 2016 at 5:29 PM, Tom Lane wrote: > Andreas Seltenreich writes: >> Updating master from f8c5855..1bdae16, sqlsmith triggers "failed to >> generate plan" errors again. Below is the smallest query logged so far. > > Hmm, interesting. This can be reduced to > > set force_parallel_mod

Re: [HACKERS] [sqlsmith] ERROR: plan should not reference subplan's variable

2016-07-01 Thread Tom Lane
Andreas Seltenreich writes: > Updating master from f8c5855..1bdae16, sqlsmith triggers "failed to > generate plan" errors again. Below is the smallest query logged so far. Hmm, interesting. This can be reduced to set force_parallel_mode = on; explain with j1 as (select * from int8_tbl) select