David Rowley <david.row...@2ndquadrant.com> writes: > On 24 July 2018 at 16:55, Jaime Casanova <jaime.casan...@2ndquadrant.com> > wrote: >> I was trying sqlsmith on REL_11_STABLE (commit >> 1b957e59b92dc44c14708762f882d7910463a9ac) with a database i have at >> hand, and got an assertion failure.
> In this case, the 2nd to 5th Append subplan's parents are actually > partitioned tables rather than leaf partitions. > make_partition_pruneinfo() assumes these will always be leaf > partitions. Looking more closely at accumulate_append_subpath() I can > see that there are cases where it won't pull sub-Append paths into the > main Append. That's what we're seeing in this plan. Hm, wouldn't this be fixed by your pending patch at <cakjs1f_eywhk2x0xx7qw42rv_grsjgbme3aqn9mylrss1s+...@mail.gmail.com> ? (I apologize for having seemingly dropped the ball on that thread; RL has intruded on my time a bit lately. I hope to get it dealt with next week.) regards, tom lane