Re: pgsql: Fix some issues with step generation in partition pruning.

On Sat, Aug 1, 2020 at 11:13 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Thomas Munro <thomas(dot)munro(at)gmail(dot)com> writes:
> > Hi Fujita-san
> > I wonder if this build farm failure is related?

Thanks for letting me know!

> Sure looks that way, doesn't it? I'm just now working to reproduce
> on gaur's host and poke into it with a debugger. More news in an
> hour or two (it's slow :-().

Thanks for that!

I'm not sure this is related to that failure, but self-reviewing the
patch, one thing I noticed I missed is that get_steps_using_prefix()
assumes that clauses in the passed-in prefix list are sorted in an
ascending order of partkeyidx, but the caller (ie,
gen_prune_steps_from_opexps()) doesn't take that into account. I
might have broken something. I'm a bit tired today, so I'll look at
this more closely tomorrow.

Best regards,
Etsuro Fujita