Re: [sqlsmith] ERROR: partition missing from subplans

2018-08-19 Thread David Rowley
On 17 August 2018 at 04:01, Alvaro Herrera wrote: > Looks good, pushed. I edited the comment a little bit. Thanks for pushing. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: [sqlsmith] ERROR: partition missing from subplans

2018-08-16 Thread Alvaro Herrera
On 2018-Aug-11, David Rowley wrote: > On 11 August 2018 at 14:09, David Rowley wrote: > > So my best idea on a > > fix is simply to remove the code that raises the error. > > Here's a patch to do that. I've also included a further simplified > test to ensure this case performs run-time pruning c

Re: [sqlsmith] ERROR: partition missing from subplans

2018-08-10 Thread David Rowley
On 11 August 2018 at 14:09, David Rowley wrote: > So my best idea on a > fix is simply to remove the code that raises the error. Here's a patch to do that. I've also included a further simplified test to ensure this case performs run-time pruning correctly. -- David Rowley ht

Re: [sqlsmith] ERROR: partition missing from subplans

2018-08-10 Thread David Rowley
On 11 August 2018 at 10:12, Andreas Seltenreich wrote: > running sqlsmith on REL_11_STABLE at 1b9d1b08fe for a couple hours > yielded the previously-unseen internal error "partition missing from > subplans". It is readily reproducible on the regression database with > the following query: > > sel

[sqlsmith] ERROR: partition missing from subplans

2018-08-10 Thread Andreas Seltenreich
Hi, running sqlsmith on REL_11_STABLE at 1b9d1b08fe for a couple hours yielded the previously-unseen internal error "partition missing from subplans". It is readily reproducible on the regression database with the following query: select * from public.fk_partitioned_fk as sample_0 tablesample sy