From: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com> |
Subject: | Re: print_path is missing GatherMerge and CustomScan support |
Date: | 2018-07-19 06:36:13 |
Message-ID: | CAFjFpReKq0M8+18wtmRAAydsAj=cGPcJ6GTGgQOf2S0ewq4b7g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Jul 19, 2018 at 11:56 AM, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> On Thu, Jul 19, 2018 at 10:41:10AM +0530, Ashutosh Bapat wrote:
>> I had extensive testcases in my original patch-set to exercise that
>> code but 1. that testset was too extensive; even today
>> partition_join.sql is a separate testcase and it's quite large. 2.
>> that function returns NULL rather than throwing an error, if it can
>> not produce a parameterized path. So, unless we check whether each of
>> those paths get created no test is useful and that can only be done
>> through an EXPLAIN OUTPUT which means that the testcase becomes
>> fragile. I fine if we want to add more tests just to cover the code if
>> those are not as fragile and do not blow up partition_join too much.
>
> Did those really check the reparameterization of a MergeAppendPath for a
> child of the parent? I'd be surprised if this one was stressed as there
> was no match in the list.
I don't remember but given this evident, it was not. But there are
some testcases in partition_join which test this code using LATERAL
joins. But those do not cover the entire function.
--
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company
From | Date | Subject | |
---|---|---|---|
Next Message | Oleksandr Shulgin | 2018-07-19 08:04:01 | Re: psql's \d versus included-index-column feature |
Previous Message | Marco van Eck | 2018-07-19 06:30:34 | Re: Have an encrypted pgpass file |