Re: MERGE SQL statement for PG12 - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: MERGE SQL statement for PG12
Date
Msg-id CAJGNTeNuB1Fkfwrfpb9T3t6qjdjTs43uMV_+5B_Vkk=fOdWiHw@mail.gmail.com
Whole thread Raw
In response to Re: MERGE SQL statement for PG12  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Responses Re: MERGE SQL statement for PG12
List pgsql-hackers
On Tue, 4 Sep 2018 at 00:01, Pavan Deolasee <pavan.deolasee@gmail.com> wrote:
>
> I've rebased the patch against the current master. The patch hasn't changed much since the last time.
>

Hi Pavan,

I had this crash when running sqlsmith against the previous version of
this patch and just confirmed it still crash with this version (which
makes sense because you said patch hasn't changed much)

To reproduce run this query against regression database:

"""
MERGE INTO public.pagg_tab_ml_p3 as target_0
USING public.prt2_l_p3_p2 as ref_0 ON target_0.a = ref_0.a
WHEN MATCHED AND cast(null as tid) <= cast(null as tid) THEN DELETE;
"""

attached is a backtrace

-- 
Jaime Casanova                      www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: pointless check in RelationBuildPartitionDesc
Next
From: Amit Langote
Date:
Subject: Re: speeding up planning with partitions