Horton

Re: [sqlsmith] Failed assertion during partition pruning

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Andreas Seltenreich <seltenreich@gmx.de>, pgsql-hackers@lists.postgresql.org
Date: 2020-12-01T20:31:24Z
Lists: pgsql-hackers 
I wrote:
> What it looks like to me is that the code for setting up run-time
> partition pruning has failed to consider the possibility of nested
> partitioning: it's expecting that every partitioned table will have
> at least one direct child that is a leaf.  I'm not sure though
> whether just the Assert is wrong, or there's more fundamental
> issues here.

After looking into the git history I realized that this assertion is
quite new, stemming from David's a929e17e5a8 of 2020-11-02.  So there's
something not right about that.

			regards, tom lane

Commits

  1. Remove [Merge]AppendPath.partitioned_rels.

  2. Remove incidental dependencies on partitioned_rels lists.

  3. Revise make_partition_pruneinfo to not use its partitioned_rels input.

  4. Fix two issues in TOAST decompression.