On Sun, Oct 13, 2019 at 02:06:02PM -0400, Tom Lane wrote: > Justin Pryzby <pry...@telsasoft.com> writes: > > On Fri, Oct 11, 2019 at 10:48:37AM -0400, Tom Lane wrote: > >> Could you provide a self-contained test case please? > > > [ test case ] > > Oh, this is the same issue Amit described in > > https://www.postgresql.org/message-id/flat/CA%2BHiwqG2WVUGmLJqtR0tPFhniO%3DH%3D9qQ%2BZ3L_ZC%2BY3-EVQHFGg%40mail.gmail.com > > namely that we're not generating EquivalenceClass members corresponding > to sub-joins of a partitionwise join. > > Are you interested in helping to test the patches proposed there?
Sure. Any requests other than testing that our original query works correctly and maybe endeavoring to read the patch ? BTW it probably should've been documented as an "Open Item" for v12. -- Justin Pryzby System Administrator Telsasoft +1-952-707-8581
