Hi Richard, On Fri, Aug 30, 2019 at 3:08 AM Etsuro Fujita <etsuro.fuj...@gmail.com> wrote: > On Thu, Aug 29, 2019 at 6:45 PM Richard Guo <ri...@pivotal.io> wrote: > > Attached is a patch as an attempt to address this issue. The idea is > > quite straightforward. When building partition info for joinrel, we > > generate any possible EC-derived joinclauses of form 'outer_em = > > inner_em', which will be used together with the original restrictlist to > > check if there exists an equi-join condition for each pair of partition > > keys. > > Will review.
I've just started reviewing this patch. One comment I have for now is: this is categorized into Bug Fixes, but we have a workaround at least to the regression test case in the patch (ie, just reorder join clauses), so this seems to me more like an improvement than a bug fix. Sorry for the delay. Best regards, Etsuro Fujita